Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
miranwar
Posting Yak Master
125 Posts |
 Posted - 2003-04-07 : 11:26:10
|
| Hello, our invoicing application is taking around 2 minutes to create an invoice via an SP. I have been asked to look into this. One of the commands i have come across is DBCC SHOWCONTIG. I ran this for our main invoice table called ominvoicedetail. The out put is returned as followsDBCC SHOWCONTIG scanning 'omInvoiceDetail' table...Table: 'omInvoiceDetail' (674921576); index ID: 1, database ID: 6TABLE level scan performed.- Pages Scanned................................: 28127- Extents Scanned..............................: 3525- Extent Switches..............................: 3528- Avg. Pages per Extent........................: 8.0- Scan Density [Best Count:Actual Count].......: 99.63% [3516:3529]- Logical Scan Fragmentation ..................: 0.60%- Extent Scan Fragmentation ...................: 9.67%- Avg. Bytes Free per Page.....................: 747.3- Avg. Page Density (full).....................: 90.77%DBCC execution completed. If DBCC printed error messages, contact your system administrator.Can anybody tell me if this table is OK or does it need reindexing.If not are there other thing i can look at increasin the speed of invoicing SPThanks for your help in advance. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-04-07 : 13:09:23
|
| Duplicate post:[url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=25187[/url]Tara |
 |
|
|
|
|
|
Performance Issue