SP_SERVER_DIAGNOSTICS_SLEEP

• D-SQL

  SSCrazy

  Points: 2265

  More actions

  November 5, 2012 at 4:19 pm

  #264473

  We just upgraded our SQL server to 2012 we are in a clustered enviroment.

  We use Confio software to monitor our database and this SP_SERVER_DIAGNOSTICS_SLEEP is skeweing our stats as this is the highest query since we upgraded does any one know where the configuration is for this?

  We know its part of the always on but we are not using that at this time.

  Thanks in advance

• Jason Horner

  Valued Member

  Points: 54

  More actions

  November 29, 2012 at 11:48 am

  #1563953

  You need to add it to the "exclude waits’" list in the Monitored Database Instance Options in the ignite web interface