User Rating!

Home > Search > Knowledge Base > SQL Server > Articles

FIX: AUTO-SHRINK Option or DBCC SHRINKDATABASE May Slow Down SQL Server 2000 Performance (Q296386)

Total Hits: 1302  |  Today: 0       Rating:

Read Reviews | Write Review |   Your Rating:  Select One 5 Stars - Best Rating 4 Stars 3 Stars 2 Stars 1 Star - Worst Rating

If a database is full or nearly full, and a large number of the tables in the database do not have clustered indexes, the AUTO-SHRINK database option or DBCC SHRINKDATABASE command may cause severe performance degradation for SQL Server 2000. The performance may degrade to the point where queries do not return results in a timely fashion. It takes longer for new connections to connect, resulting in connection timeouts. SQL Server 2000 may appear to stop responding (hang).

DevASP.Net users Rating What is your opinion? 5 Stars4 Stars3 Stars2 Stars1 Star

Is this your listing?

If this is your listing and you like to add the rating box
displayed on the right side on your site you can use the following code.