Friday, January 15, 2010

14 Year Old In Diapers

Viewing statistics database

time ago in another post I showed how to re-index an entire database.
Well, before you do that you can study the state of the database and display the statistics with the command: exec

sp_msforeachtable 'dbcc SHOWCONTIG ("?")'

One of the important parameters is the "Scan Density", plus the value is low unless the indexes will be performing.

0 comments:

Post a Comment