March 2, 2011 at 3:14 pm
With two quad processors and 8 GB memory and a light SQL load would you expect to see 401,412,031,545 'I/0 Writes Bytes' in Task manager from sqlservr.exe? I'm also seeing a PF Usage of 7.88 GB and a very high Page IO Latch. It looks to me as SQL Server is starving for memory. How do I determine if this is SQL Server of some other process? there is a process with a PF Delta with a very high burst from every second or so, klnagent.exe. There are complaints at the Kaspersky Labs forum of the same symptoms. Does anyone have a strategy for isolating the offending process without killing processes or restarting the server?
March 4, 2011 at 8:26 am
Task Manager's I/O number could be misleading without knowing how long the server has been running. What are the specs of SQL Server? Min/Max memory settings. What are the database sizes on the server? Just an I/O number doesn't give much to go on.
As for klnagent.exe, you might want to check your virus scan settings. If you have real-time scans on the database files, you could be begging for performance problems.
I suggest you look at running process explorer instead of Task Manager. You can get a great deal of information that Task Manager just doesn't have.
Download it from microsoft here:
http://download.sysinternals.com/Files/ProcessExplorer.zip
--------------------------------------------------------------------------
When you realize you've dug yourself into a hole....Step 1...stop digging.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply