Post reply

Resource Monitor and Lazy Writer on SP_WHO2

  • November 13, 2008 at 5:12 am

    #201337

    Hi All

    When i use SP_WHO2 and see the process the first 3 process with SPID 1,2,3 are RESOURCE MONITOR,LAZY WRITER,LOCK MONITOR, on all my servers, this has got 0 diskI/O and a huge CPU Time, and the date is the date when the instance was last resatrted,

    Does this affect performance on the system, if so how can i clear this??

    Please give me a light on this 😀

    Cheers

    🙂

  • November 13, 2008 at 5:17 am

    #897997

    Hello CrazyMan,

    Do not crazy about SPID 1,2,3...

    I mean do not worry about 1 to 50 SPID it's exclusively used by internal system. You should worry about 51 onwards SPID.

    Good Day!

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • November 13, 2008 at 5:19 am

    #897998

    Thanks mate

    I can see that, but i am just worried about the system performance, will this affect any performance???? 🙂

  • November 13, 2008 at 5:26 am

    #898003

    If performance is affected will you kill?

    Irespective of performance; you can't kill system processes you will get messge "Only user processes can be killed."

    JUST DO NOT WORRY ABOUT THIS PROCESSES.

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • November 13, 2008 at 5:39 am

    #898008

    Thanks Mascott, u definetly cant kill or do anything on system process 🙂

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

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