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 |
|
KingCarlos
Yak Posting Veteran
74 Posts |
 Posted - 2010-04-05 : 23:45:04
|
| Page total Value when running DBCC SHOWCONTIGI ran the following SQL Script on a DB TableDBCC SHOWCONTIG (test) WITH FAST, TABLERESULTS, ALL_INDEXES, NO_INFOMSGSAnd the value for the scandensity for the column testid was low, 30So I fixed it up using the followingDBCC DBREINDEX (test, testid,0) When I run the following SQL scriptDBCC SHOWCONTIG (test) WITH FAST, TABLERESULTS, ALL_INDEXES, NO_INFOMSGSTestid scandensity is 91 but the total in the pages has jumped up to 160 from 2 is this something to be concerned about and if so how to reduce that number? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-04-06 : 16:50:01
|
| agree with Tara. I filter on WHERE pagecount > 999 among other things. |
 |
|
|
KingCarlos
Yak Posting Veteran
74 Posts |
Posted - 2010-04-06 : 18:38:53
|
| Thanks for the info I was unsure if 160 was a high page count, so rule of thumb is anything over 1000.I am using SQL 2008, should there be different SQL Scripts to use to check and repair the scandensity? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
|
|
High Page total Value when running DBCC SHOWCONTIG