Red Gate forums :: View topic - Custom Metric does not fire off
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Monitor 3
SQL Monitor 3 forum

Custom Metric does not fire off

Search in SQL Monitor 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
buttonbj



Joined: 12 Oct 2012
Posts: 8

PostPosted: Wed Feb 20, 2013 9:53 pm    Post subject: Custom Metric does not fire off Reply with quote

Hello everyone,

I created a custom metric to watch for transactions that are running for more than a day. The reason why I have to do this is, is because one of our vendors has followed poor coding practices and every now and then their transactions run for days at a time on our system. Their transaction uses up the space in our tempdb ldf file and creates issues for us. The vendor is currently working with Microsoft to fix the issue, but in the mean time I need a way to identify these transaction so I can manually kill them. The vendor told us to kill the transactions. The query I used to identify these issues is as follows:

SELECT TOP 1 elapsed_time_seconds
FROM sys.dm_tran_active_snapshot_database_transactions
WHERE elapsed_time_seconds >= 86400
ORDER BY elapsed_time_seconds DESC;

I have the alert being raised with the following thresholds:

Low: 86399
Medium: 172799
High: 259200

Raise an alert when the threshold is passed for 1 collection.

The alert is enabled too.

I can run the query above and I can see when it returns a value, but the the alert never generates. Does anyone have any ideas why? Thank you in advanced.

-Brandon
Back to top
View user's profile Send private message
priyasinha



Joined: 03 Jan 2007
Posts: 530

PostPosted: Thu Feb 21, 2013 4:00 pm    Post subject: Reply with quote

Hi Brandon,

Can you please email me priya.sinha@red-gate.com screen shot of the following:
- Custom metric showing configuration
- Custom alert showing these thresholds.
- Results of export for this custom metric for last 10 days from Analysis page.
- Screen shot of Alert Inbox, filtered for this alert only. Please select both Cleared and Not cleared alerts.
- Screen shot of Purge page.

Thanks,
Priya
Back to top
View user's profile Send private message
buttonbj



Joined: 12 Oct 2012
Posts: 8

PostPosted: Thu Mar 07, 2013 4:29 pm    Post subject: Solution Reply with quote

As a follow up, Priya Sinha was able to help identify my issue. My Query was returning null values at times and this was interfering with the alert working correctly. Once I fixed my query to not return a null value, the alert worked as intended.
Back to top
View user's profile Send private message
priyasinha



Joined: 03 Jan 2007
Posts: 530

PostPosted: Fri Mar 08, 2013 11:18 am    Post subject: Reply with quote

Thank you Brandon for updating the forum Smile.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group