LAZY WRITER

  • 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 --

    I will appreciate any input.

    Thank You,

    Jay

  • Hello Mr.Jay,

    Did u sort out this issue...? can u share the solution, am facing same issue.

    TIA....

  • Can anyone help me to sort out this issue.

    Today i faced problem with this server, suddenly there is nothing executed on this server.

    In Event Viewer i noticed the Error : 701 "Insufficient memory to run this Query".

    Any solution on this would be Highly appreciated...

  • Please post new questions in a new thread. Thank you.

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply