Custom Alerts

• Robert W Marda

  SSChampion

  Points: 13413

  More actions

  March 15, 2002 at 12:04 pm

  #57584

  Is there a way to customize alerts?

  There seems to be if I look at

  Type: SQL Server performance condition alert

  Object: SQL Server: User Settable

  Counter: Query

  Instance: User counter 1, User counter 2, etc. on up to User counter 10.

  How do I define User counter 1?

  Robert Marda

  Robert W. Marda
  Billing and OSS Specialist - SQL Programmer
  MCL Systems

• K. Brian Kelley

  SSC Guru

  Points: 114642

  More actions

  March 16, 2002 at 12:26 pm

  #425503

  Take a look at the following:

  http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_perfmon_7eb8.asp

  Basically, the counter value has to be set manually. Perfmon will report the value set until it's changed, so if you do the following:

  
  
  EXEC sp_user_counter1 10
  
  

  Performance Monitor will report User Counter as 10 until you execute a new sp_user_counter1 with a different value.

  K. Brian Kelley

  bkelley@sqlservercentral.com

  http://www.sqlservercentral.com/columnists/bkelley/

  K. Brian Kelley
  @kbriankelley