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