sp_server_diagnostics process running all the time

Question

sp_server_diagnostics process running all the time

sql-lover

SSCoach

Points: 18530
More actions
February 15, 2013 at 1:13 pm

#270973

Got sp_server_diagnostics process constantly running on my SQL2012 Cluster. I do believe it's for self health tuning or data collection? But can someone please explain in more detail why is there, hugging resources and running forever?
Can I safely disable sp_server_diagnostics? And why it's or was absent on SQL2008 or previous implementation.
I Google this finding little or no explanations. Or maybe I need to improve my Google search skills. 😉
Thanks in advance

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

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

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

It's used for the cluster's IsAlive check. It takes minimal resources. It wasn't there on SQL 2008 or below because it was only introduced in SQL 2012.

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

sql-lover SSCoach Points: 18530 More actions · Answer 2

GilaMonster (2/15/2013)
It's used for the cluster's IsAlive check. It takes minimal resources. It wasn't there on SQL 2008 or below because it was only introduced in SQL 2012.

Thanks for reply!

Well, that explains why I do not recall such thing on the Cluster I managed before.

Do you know any useful link I can use for further reading?

Also, my RedGate Monitor tool (and Management Studio) have a different opinion, lol ... they keep flagging it as intensive query ... I wonder if I can filter it on SQL Monitor and exclude. But I was afraid of flagging an important stuff ..

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

sql-lover (2/15/2013)
GilaMonster (2/15/2013)
It's used for the cluster's IsAlive check. It takes minimal resources. It wasn't there on SQL 2008 or below because it was only introduced in SQL 2012.
Thanks for reply!
Well, that explains why I do not recall such thing on the Cluster I managed before.
Do you know any useful link I can use for further reading?

A quick search turned up these

http://msdn.microsoft.com/en-us/library/ff878233.aspx

http://blogs.msdn.com/b/psssql/archive/2012/03/08/sql-server-2012-true-black-box-recorder.aspx

Also, my RedGate Monitor tool (and Management Studio) have a different opinion, lol ... they keep flagging it as intensive query ...

Possibly because it's running often.

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

saravanan.thamidurai SSC Enthusiast Points: 166 More actions · Answer 4

Will "sp_server_diagnostics" help not to fail-over to passive node if I am patching(SP) the passive node and assuming there is an issue with the Active node for Active\Passive cluster?