|
|
|
|
|
Total Hits: 1330 | Today: 0
|
|
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).
|
|
|
|
Latest Posts at Dev Forums
|
|
|
|
|
|
|
|
|
|
|
