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 |
|
poser
Posting Yak Master
124 Posts |
 Posted - 2011-08-23 : 15:28:18
|
| I have a database that was upgraded from sql 2000 to 2005. Not sure if previous dba who did the upgrade ran the DBCC UPDATEUSAGE.I am getting the following error from DBCC CHECKDB:The In-row data RSVD page count for object "table", index ID 0, partition ID 1222222222222, alloc unit ID 12222222222 (type In-row data) is incorrect. Run DBCC UPDATEUSAGE.CHECKDB found 0 allocation errors and 1 consistency errors in table 'table' (object ID 28222222).I am doing lots of Inserts\updates\deletes daily to this database.Question: Could this be a possible problem with performanceThanks in advancer/p |
|
|
poser
Posting Yak Master
124 Posts |
Posted - 2011-08-23 : 15:31:17
|
| Also could this cause problems with logging...I am running database in simple mode.Thanks, p |
 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-08-23 : 16:27:45
|
| The incorrect page usage data won't cause any performance problems or logging problems. Just run UpdateUsage once, providing you're on the latest service pack of SQL 2005 you shouldn't need to run it again.--Gail ShawSQL Server MVP |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2011-08-23 : 16:54:52
|
| "Not sure if previous dba who did the upgrade ran the DBCC UPDATEUSAGE."Anything else they missed? Take a look at this (its for SQL 2008 upgrade, but most of it is relevant to SQL 2005 upgrade too)http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=138230 |
|
|
|
poser
Posting Yak Master
124 Posts |
Posted - 2011-08-26 : 12:24:10
|
| Thanks for all the help and informantion.I will back-track and make sure it is all taken care of.R/P |
|
|
|
|
|
|
DBCC UPDATEUSAGE