February 15, 2012 at 2:16 am
Hello,
I am seeing lots of Lazy Writer processes running when I run sp_who2 and "LastBatch" is showing time when server was rebooted. But, it is still showing it using lots of CPU and I/O resources. Can this cause issues with SQL Server operations? Also, we use SQL litespeed for backups and it has been failing today (Error: General Network Error), Can lazy Writer be causing any issues. I am attaching a screen shot of sp_who2 output
Kindly help how to solve this memory Problem.
February 15, 2012 at 3:10 am
That CPU and IO is cumulative since the server last started. You didn't say when the server was last started, but if that was quite some time ago, those numbers could be normal or even low.
No, lazy writer will not cause problems with litespeed backups, check the litespeed error logs. General network error means just that, something went wrong with the network.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply