Tracking specific error numbers

• 
  Hi Andrew, 
  
  Thanks for your post!
  
  Unfortunately, there is no feature in SQL Monitor to track and send alerts for specific SQL Errors.
  
  It might be possible using a Custom Metric, but it's not a feature we've provided or tested!

  Robyn August 08, 2019 15:10

  - 0 +
• 
  Hi there,
  
  Thanks for your reply. I've decided to do it with a custom metric using this scrip:
  
  

  DROP TABLE IF EXISTS #errorLog;

  
  

  CREATE TABLE #errorLog

  (

      LogDate DATETIME,

      ProcessInfo VARCHAR(64),

      [Text] VARCHAR(MAX)

  );

  DECLARE @starttime DATETIME = DATEADD(MINUTE, -5, GETDATE()), @now DATETIME = GETDATE()

  
  

  INSERT INTO #errorLog

  EXEC xp_readerrorlog 0,1,NULL, NULL, @starttime, @now

  SELECT COUNT(*)

  FROM #errorLog a

  WHERE EXISTS

  (

      SELECT *

      FROM #errorLog b

      WHERE [Text] LIKE '%I/O requests taking longer than 15 seconds%'

            AND a.LogDate = b.LogDate

            AND a.ProcessInfo = b.ProcessInfo

  );

  
  

  DROP TABLE IF EXISTS #errorLog;
  
  Regards
  
  
  Andrew

  crimdon August 08, 2019 15:42

  - 0 +
• 
  It'd be good to submit that to sqlmonitormetrics.com .
  

  Russell D August 09, 2019 08:57

  - 0 +

Add comment

Please sign in to leave a comment.