We got the advice to run DBCC UPDATEUSAGE, on one of our databases.
What impact can be expected from this command?
Can this be done online?
Does this impact the servers performance?
This is for a 2005 system, databasesize is 40 Gb.
On a 2008 system a comparable database of 10 Gb was done in 10 secs.
On a 2008 R2 system (small) a 200 Gb database was done in just under 6 minutes.
Test for a 2005 system on the backup of the database is in preparation.
thanks for your time and attention,