December 11, 2013 at 12:54 am
If this wait type "PREEMPTIVE_SP_SERVER_DIAGNOSTICS" is very high what does it mean?
What's the downtime of such signal if this is found to be very high?
Thanks.
May 13, 2014 at 2:57 pm
did u ever found out what it is?
I assume its because of the process sp_server_diagnostics, it seems to be causing consistently 50% CPU
SQL is 2012 SP1 CU5
have same setup on an other 10 identical 3 node AlwaysON and this is the only one behaving differently
PREEMPTIVE_SP_SERVER_DIAGNOSTICS is the only wait type on this system for last 1 day
feeling it could be a bug
Prakash Heda
Lead DBA Team - www.sqlfeatures.com
Video sessions on Performance Tuning and SQL 2012 HA
April 6, 2016 at 2:19 am
PREEMPTIVE_SP_SERVER_DIAGNOSTICS just reflects the cumulative wait time of stored procedure sp_server_diagnistics. This proc was introduced in SQL Server 2012 (https://msdn.microsoft.com/en-us/library/ff878233%28v=sql.110%29.aspx) and takes a @repeat_interval parameter that specifies the wait time between data collections. Hope it helps.
~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*Brevity is the soul of wit.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply