Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Resource Monitor and Lazy Writer on SP_WHO2 Expand / Collapse
Author
Message
Posted Thursday, November 13, 2008 5:12 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Thursday, July 3, 2014 10:20 AM
Points: 770, Visits: 1,596
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 :D


Cheers

:)
Post #601997
Posted Thursday, November 13, 2008 5:17 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 21, 2014 2:56 AM
Points: 2,603, Visits: 2,061
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."
Post #601998
Posted Thursday, November 13, 2008 5:19 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Thursday, July 3, 2014 10:20 AM
Points: 770, Visits: 1,596
Thanks mate
I can see that, but i am just worried about the system performance, will this affect any performance???? :)
Post #601999
Posted Thursday, November 13, 2008 5:26 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 21, 2014 2:56 AM
Points: 2,603, Visits: 2,061
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."
Post #602004
Posted Thursday, November 13, 2008 5:39 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Thursday, July 3, 2014 10:20 AM
Points: 770, Visits: 1,596
Thanks Mascott, u definetly cant kill or do anything on system process :)
Post #602010
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse