|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Urgent! - time out errors while inserting into the dBI am getting time-out errors in my web application on pages which involve
inserts into the dB. The application has not changed a bit so it is not a problem with the ASP code, Please help me trouble shoot and fix this problem. Pages that do a 'select' work without any problem, the problem is only with pages that have a insert operation. I am using sql server 2000 How many indexes do you have on that table?
Can you show us the table structure, and the indexes? What's the size of the table in terms of rows? What is the execution plan looking like, for the insert statement, when you insert directly from Query Analyzer? Anything strange? "Mike" <M***@discussions.microsoft.com> wrote in message I am getting time-out errors in my web application on pages which involvenews:A09CF054-2225-4387-80B4-D2DE18D21DC7@microsoft.com... inserts into the dB. The application has not changed a bit so it is not a problem with the ASP code, Please help me trouble shoot and fix this problem. Pages that do a 'select' work without any problem, the problem is only with pages that have a insert operation. I am using sql server 2000 I have about 20 databases with atleast 15 tables in each database, Is there a
command that I can run to get this info? Show quote "Narayana Vyas Kondreddi" wrote: > How many indexes do you have on that table? > > Can you show us the table structure, and the indexes? > > What's the size of the table in terms of rows? > > What is the execution plan looking like, for the insert statement, when you > insert directly from Query Analyzer? Anything strange? > -- > HTH, > Vyas, MVP (SQL Server) > SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/ > > > "Mike" <M***@discussions.microsoft.com> wrote in message > news:A09CF054-2225-4387-80B4-D2DE18D21DC7@microsoft.com... > I am getting time-out errors in my web application on pages which involve > inserts into the dB. The application has not changed a bit so it is not a > problem with the ASP code, Please help me trouble shoot and fix this > problem. > > Pages that do a 'select' work without any problem, the problem is only with > pages that have a insert operation. > I am using sql server 2000 > > > run sp_helpindex 'tablename' in your database to see how many indexes you
have got. SELECT COUNT(*) FROM yourTableName will give you the number of rows inside the table. SET SHOWPLAN_TEXT ON The above command gives you the execution plan for your queries in textual format. "Mike" <M***@discussions.microsoft.com> wrote in message I have about 20 databases with atleast 15 tables in each database, Is therenews:4B73E986-550B-45AD-ACB8-C5744A2EFE9D@microsoft.com... a command that I can run to get this info? Show quote "Narayana Vyas Kondreddi" wrote: > How many indexes do you have on that table? > > Can you show us the table structure, and the indexes? > > What's the size of the table in terms of rows? > > What is the execution plan looking like, for the insert statement, when you > insert directly from Query Analyzer? Anything strange? > -- > HTH, > Vyas, MVP (SQL Server) > SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/ > > > "Mike" <M***@discussions.microsoft.com> wrote in message > news:A09CF054-2225-4387-80B4-D2DE18D21DC7@microsoft.com... > I am getting time-out errors in my web application on pages which involve > inserts into the dB. The application has not changed a bit so it is not a > problem with the ASP code, Please help me trouble shoot and fix this > problem. > > Pages that do a 'select' work without any problem, the problem is only with > pages that have a insert operation. > I am using sql server 2000 > > > Hi,
I have many tables, some tables have more than 200,000 records. I executed dbcc showconfig on some indexes, here is the output DBCC SHOWCONTIG scanning 'Orders' table... Table: 'Orders' (2105058535); index ID: 1, database ID: 13 TABLE level scan performed. - Pages Scanned................................: 126 - Extents Scanned..............................: 21 - Extent Switches..............................: 122 - Avg. Pages per Extent........................: 6.0 - Scan Density [Best Count:Actual Count].......: 13.01% [16:123] - Logical Scan Fragmentation ..................: 53.17% - Extent Scan Fragmentation ...................: 95.24% - Avg. Bytes Free per Page.....................: 2449.8 - Avg. Page Density (full).....................: 69.73% DBCC execution completed. If DBCC printed error messages, contact your system administrator. DBCC SHOWCONTIG scanning 'Main' table... Table: 'Main' (1986106116); index ID: 1, database ID: 13 TABLE level scan performed. - Pages Scanned................................: 3553 - Extents Scanned..............................: 447 - Extent Switches..............................: 1426 - Avg. Pages per Extent........................: 7.9 - Scan Density [Best Count:Actual Count].......: 31.18% [445:1427] - Logical Scan Fragmentation ..................: 15.28% - Extent Scan Fragmentation ...................: 30.20% - Avg. Bytes Free per Page.....................: 1274.4 - Avg. Page Density (full).....................: 84.26% DBCC execution completed. If DBCC printed error messages, contact your system administrator. DBCC SHOWCONTIG scanning 'Cart' table... Table: 'Cart' (1993058136); index ID: 0, database ID: 13 TABLE level scan performed. - Pages Scanned................................: 127 - Extents Scanned..............................: 24 - Extent Switches..............................: 23 - Avg. Pages per Extent........................: 5.3 - Scan Density [Best Count:Actual Count].......: 66.67% [16:24] - Extent Scan Fragmentation ...................: 91.67% - Avg. Bytes Free per Page.....................: 393.0 - Avg. Page Density (full).....................: 95.15% DBCC execution completed. If DBCC printed error messages, contact your system administrator. Show quote "Narayana Vyas Kondreddi" wrote: > run sp_helpindex 'tablename' in your database to see how many indexes you > have got. > > SELECT COUNT(*) FROM yourTableName will give you the number of rows inside > the table. > > SET SHOWPLAN_TEXT ON > > The above command gives you the execution plan for your queries in textual > format. > -- > HTH, > Vyas, MVP (SQL Server) > SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/ > > > "Mike" <M***@discussions.microsoft.com> wrote in message > news:4B73E986-550B-45AD-ACB8-C5744A2EFE9D@microsoft.com... > I have about 20 databases with atleast 15 tables in each database, Is there > a > command that I can run to get this info? > > "Narayana Vyas Kondreddi" wrote: > > > How many indexes do you have on that table? > > > > Can you show us the table structure, and the indexes? > > > > What's the size of the table in terms of rows? > > > > What is the execution plan looking like, for the insert statement, when > you > > insert directly from Query Analyzer? Anything strange? > > -- > > HTH, > > Vyas, MVP (SQL Server) > > SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/ > > > > > > "Mike" <M***@discussions.microsoft.com> wrote in message > > news:A09CF054-2225-4387-80B4-D2DE18D21DC7@microsoft.com... > > I am getting time-out errors in my web application on pages which involve > > inserts into the dB. The application has not changed a bit so it is not a > > problem with the ASP code, Please help me trouble shoot and fix this > > problem. > > > > Pages that do a 'select' work without any problem, the problem is only > with > > pages that have a insert operation. > > I am using sql server 2000 > > > > > > > > > This might help you
There are lot of parameters you should check on your SQL server - Free disk space - Execute DBCC check - Check the indexes Show quote "Mike" wrote: > I am getting time-out errors in my web application on pages which involve > inserts into the dB. The application has not changed a bit so it is not a > problem with the ASP code, Please help me trouble shoot and fix this problem. > > Pages that do a 'select' work without any problem, the problem is only with > pages that have a insert operation. > I am using sql server 2000 I am a newbie, can you tell me how I can do a dbcc check and index check pls
Show quote "Anirudha Vengurlekar" wrote: > This might help you > There are lot of parameters you should check on your SQL server > - Free disk space > - Execute DBCC check > - Check the indexes > > > "Mike" wrote: > > > I am getting time-out errors in my web application on pages which involve > > inserts into the dB. The application has not changed a bit so it is not a > > problem with the ASP code, Please help me trouble shoot and fix this problem. > > > > Pages that do a 'select' work without any problem, the problem is only with > > pages that have a insert operation. > > I am using sql server 2000 please have a look at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_dbcc_00gy.asp
Show quote "Mike" wrote: > I am a newbie, can you tell me how I can do a dbcc check and index check pls > > "Anirudha Vengurlekar" wrote: > > > This might help you > > There are lot of parameters you should check on your SQL server > > - Free disk space > > - Execute DBCC check > > - Check the indexes > > > > > > "Mike" wrote: > > > > > I am getting time-out errors in my web application on pages which involve > > > inserts into the dB. The application has not changed a bit so it is not a > > > problem with the ASP code, Please help me trouble shoot and fix this problem. > > > > > > Pages that do a 'select' work without any problem, the problem is only with > > > pages that have a insert operation. > > > I am using sql server 2000 These are the stats from DBCC showcontig on some tables -
DBCC SHOWCONTIG scanning 'Orders' table... Table: 'Orders' (2105058535); index ID: 1, database ID: 13 TABLE level scan performed. - Pages Scanned................................: 126 - Extents Scanned..............................: 21 - Extent Switches..............................: 122 - Avg. Pages per Extent........................: 6.0 - Scan Density [Best Count:Actual Count].......: 13.01% [16:123] - Logical Scan Fragmentation ..................: 53.17% - Extent Scan Fragmentation ...................: 95.24% - Avg. Bytes Free per Page.....................: 2449.8 - Avg. Page Density (full).....................: 69.73% DBCC execution completed. If DBCC printed error messages, contact your system administrator. DBCC SHOWCONTIG scanning 'Main' table... Table: 'Main' (1986106116); index ID: 1, database ID: 13 TABLE level scan performed. - Pages Scanned................................: 3553 - Extents Scanned..............................: 447 - Extent Switches..............................: 1426 - Avg. Pages per Extent........................: 7.9 - Scan Density [Best Count:Actual Count].......: 31.18% [445:1427] - Logical Scan Fragmentation ..................: 15.28% - Extent Scan Fragmentation ...................: 30.20% - Avg. Bytes Free per Page.....................: 1274.4 - Avg. Page Density (full).....................: 84.26% DBCC execution completed. If DBCC printed error messages, contact your system administrator. DBCC SHOWCONTIG scanning 'Cart' table... Table: 'Cart' (1993058136); index ID: 0, database ID: 13 TABLE level scan performed. - Pages Scanned................................: 127 - Extents Scanned..............................: 24 - Extent Switches..............................: 23 - Avg. Pages per Extent........................: 5.3 - Scan Density [Best Count:Actual Count].......: 66.67% [16:24] - Extent Scan Fragmentation ...................: 91.67% - Avg. Bytes Free per Page.....................: 393.0 - Avg. Page Density (full).....................: 95.15% DBCC execution completed. If DBCC printed error messages, contact your system administrator. Show quote "Anirudha Vengurlekar" wrote: > please have a look at > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_dbcc_00gy.asp > > "Mike" wrote: > > > I am a newbie, can you tell me how I can do a dbcc check and index check pls > > > > "Anirudha Vengurlekar" wrote: > > > > > This might help you > > > There are lot of parameters you should check on your SQL server > > > - Free disk space > > > - Execute DBCC check > > > - Check the indexes > > > > > > > > > "Mike" wrote: > > > > > > > I am getting time-out errors in my web application on pages which involve > > > > inserts into the dB. The application has not changed a bit so it is not a > > > > problem with the ASP code, Please help me trouble shoot and fix this problem. > > > > > > > > Pages that do a 'select' work without any problem, the problem is only with > > > > pages that have a insert operation. > > > > I am using sql server 2000  |
|||||||||||||||||||||||
Other interesting topics