June 30, 2009 at 2:49 pm
Hi,
i want script to notify when any opentransctions running more than 30 seconds.
June 30, 2009 at 9:50 pm
vinaykumar.bommareddy (6/30/2009)
Hi,i want script to notify when any opentransctions running more than 30 seconds.
I'd suggest setting up an alert.
Under Object, select :Transactions
Under Counter, select Longest Transaction Running Time
Under Alert if Counter, select Rises Above
Under Value, select 30.
Set up your operator, and you should be all set.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
July 1, 2009 at 9:16 am
Wayne has probably provided the best solution, but you can get transaction information from the sys.dm_tran* management views. So you could write a script if you really wanted.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
July 2, 2009 at 1:06 am
Yes that is the best answer i think.
The other ideas of creating the SPs and running them every 30 seconds will be pain as well as resource consuming .
Regards
Abhay Chaudhary
Sr.DBA (MCITP/MCTS :SQL Server 2005/2008 ,OCP 9i)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply