SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Resource Monitor and Lazy Writer on SP_WHO2


Resource Monitor and Lazy Writer on SP_WHO2

Author
Message
CrazyMan
CrazyMan
Hall of Fame
Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)

Group: General Forum Members
Points: 3068 Visits: 1597
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 BigGrin


Cheers

Smile
free_mascot
free_mascot
SSCertifiable
SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)

Group: General Forum Members
Points: 7599 Visits: 2250
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."
CrazyMan
CrazyMan
Hall of Fame
Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)

Group: General Forum Members
Points: 3068 Visits: 1597
Thanks mate
I can see that, but i am just worried about the system performance, will this affect any performance???? Smile
free_mascot
free_mascot
SSCertifiable
SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)

Group: General Forum Members
Points: 7599 Visits: 2250
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."
CrazyMan
CrazyMan
Hall of Fame
Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)

Group: General Forum Members
Points: 3068 Visits: 1597
Thanks Mascott, u definetly cant kill or do anything on system process Smile
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search