February 19, 2007 at 7:23 am
One of our SQL 2000 databases is returning 0 space available in taskpad view in EM. There is physically more space. The vendor came in and did a mass upgrade and caused the inaccurate values. How do we determine if we should/must run DBCC updateusage(0). When can we run it? The only information I can find is that is could take a long time to run on large databases (ours is 15GB). Can users and or processes be running or does everyone have to be out of the system? The database server is up 24x7 with no downtime. thanks,
February 19, 2007 at 7:31 am
dbccc updateusage is usually pretty quick to run and isn't as much of a problem as other dbcc commands. I run this daily on every database, but at the quietest time, I have run it at peak times without issue although there may be a small amount of blocking.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
February 19, 2007 at 7:32 am
Hello Dana,
The DBCC UPDATEUSAGE will refresh the linked list of the pages for particular tables and hence it is not required that the users be logged out of the system. Just that a server would appear a bit slower during the period since DB/table level locks would be taken. Hence better do it during the off peak hours , but for a 15 Gb database it should not take more that 10 min I believe.
February 19, 2007 at 7:47 am
Thank you for the replys. The information is comforting to know that it can be run with users on the system and in relation to the size of the database 15-20min to run is not bad at all.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply