<div>
<div class="content wysiwyg-content">
A client is running a database server with the following OS and database: <br />
Windows Server 2003 with Service Pack 2 (SP2), Enterprise Edition 32-bit &nbsp;<br />
Microsoft SQL Server 2005 - (Intel X86) Standard Edition <br />
<br />
We recently had an issue with two open transactions identified in SQL Server Activity Monitor that severly affected database perfomance. We rarely see open transction across multiple client sites (months apart / hundreds of sites) which leads me to believe there is no issue with the application but rather something fluky happening in SQL Server at that time. &nbsp;<br />
<br />
We have some time sensitive operations about to start and was hoping that there is a way to be notified if an open transaction exists for more than x minutes. The other option is to dedicate a resource to manually watch the activity monitor for mulitple days which is not ideal.<br />
<br />
Any advice would be appreciated!
</div>
</div>


A client is running a database server with the following OS and database: 
Windows Server 2003 with Service Pack 2 (SP2), Enterprise Edition 32-bit  
Microsoft SQL Server 2005 - (Intel X86) Standard Edition 

We recently had an issue with two open transactions identified in SQL Server Activity Monitor that severly affected database perfomance. We rarely see open transction across multiple client sites (months apart / hundreds of sites) which leads me to believe there is no issue with the application but rather something fluky happening in SQL Server at that time.  

We have some time sensitive operations about to start and was hoping that there is a way to be notified if an open transaction exists for more than x minutes. The other option is to dedicate a resource to manually watch the activity monitor for mulitple days which is not ideal.

Any advice would be appreciated!

SQL Server - Activity Monitor - Open Transaction

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Windows Server 2003 was based on Windows XP and was released in four editions: Web, Standard, Enterprise and Datacenter. It also had derivative versions for clusters, storage and Microsoft’s Small Business Server. Important upgrades included integrating Internet Information Services (IIS), improvements to Active Directory (AD) and Group Policy (GP), and the migration to Automated System Recovery (ASR).