dbcc showcontic output analysys

Question

dbcc showcontic output analysys

sivark1

SSCrazy

Points: 2654
More actions
June 17, 2010 at 3:16 am

#222208

Hi if i run the DBCC SHOWCONTIG( ) for the entire database
we will get huge output each table wise
Whar are the imp parameters we need to analyze
Like AVg Sacn Density etc...
please reply soon
Thanks in advance

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Rather don't use showcontig. It's deprecated and will be removed in a future version of SQL. The 2005 replacement for showcontig is sys.dm_db_index_physical_stats.

The columns of interest (well, of most interest) are avg fragmentation in percent, page count, average page space used in percent.

I have a presentation that may be of some interest. http://sqlinthewild.co.za/index.php/resources/. Under PASS Community Summit 2009, the one 'insight into indexes'

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

VastSQL SSC-Dedicated Points: 36097 More actions · Answer 2

use DMV dm_db_index_physical_stats

http://msdn.microsoft.com/en-us/library/ms188917.aspx.

Gail have alredy given advise 😎

sivark1 SSCrazy Points: 2654 More actions · Answer 3

Thanks for the replies Dudes.

the above link is not working it seems it is throwing error like

Server Error in '/' Application.

free_mascot One Orange Chip Points: 27169 More actions · Answer 4

Above link is working fine just eliminate period (.).

http://msdn.microsoft.com/en-us/library/ms188917.aspx

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."