2012年3月27日星期二

disk queuing

I appear to have 100% disk queuing performance problems even when there are
not any users interigating data?
This leads to blocking when users do attempt to run data interegation.
We have a 3Gb processor running 2Gb of Ram
I have watched the performance monitor endlessly and the problem is
intermitant, the CPU usage is barely used
Please can anyone direct me towards the problem?Probably related to checkpoints. Lookup Checkpoint in BooksOnLine for more
details. You can monitor when this happens with Perfmon and the SQL
CheckPoint per Second counter. Or something else is going on with the
server that you are not aware of.
--
Andrew J. Kelly SQL MVP
"Michael Ayers" <michael.ayers(RemoveThis)@.phonetics.co.uk> wrote in message
news:B5D9F392-3ADF-4B4B-A48F-500398DFC377@.microsoft.com...
>I appear to have 100% disk queuing performance problems even when there are
> not any users interigating data?
> This leads to blocking when users do attempt to run data interegation.
> We have a 3Gb processor running 2Gb of Ram
> I have watched the performance monitor endlessly and the problem is
> intermitant, the CPU usage is barely used
> Please can anyone direct me towards the problem?sql

没有评论:

发表评论