Viewing 3 posts - 1 through 3 (of 3 total)
Can you post the contents of your ..\MSSQL\LOG\SQLAGENT.OUT file too please.
March 7, 2008 at 3:58 am
#786533
From SQL Server BOL "The Windows process spawned by xp_cmdshell has the same security rights as the SQL Server service account."
So make sure the account that starts up SQL Server...
February 7, 2008 at 2:48 am
#775915
Sounds to me like SQL Server is performing a CHECKPOINT (flushing dirty pages to Disk) when you get your disk queue spike.. You can use Perfmon to verify by...
December 18, 2007 at 8:39 am
#761069