perhaps first look if your I/O is fine

Benchmarking SQL Server IO with SQLIO

http://www.mssqltips.com/tip.asp?tip=2127

if there are WMI problems, use the microsoft tool to verify your WMI

http://www.microsoft.com/downloads/details.aspx?familyid=d7ba3cd6-18d1-4d05-b11e-4c64192ae97d&displaylang=en

regards,

Xander

Andras Belokosztolszki (10/19/2007)

---

rabartels (10/19/2007)

---

You also could add a step, after backing up the transaction log :

dump transaction mydatabasename with no_log

dump log mydatabasenameg with no_log

/* no shrink DB */

EXECUTE sp_updatestats

Then shrinking...

You also could add a step, after backing up the transaction log :

dump transaction mydatabasename with no_log

dump log mydatabasenameg with no_log

/* no shrink DB */

EXECUTE sp_updatestats

Then shrinking database

You also can try to shrink the individual tempdb files

Go to the  shrink database window

At the button, press files, the another window is opened where you can select one of...