O'Reilly logo

Microsoft SQL Server 2012 Performance Tuning Cookbook by Bihag Thaker, Ritesh Shah

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Determining long-running transactions

Long-running transactions block the other transactions and in turn introduce new long-running transactions! This affects the performance of the database server.

As a DBA, you should regularly monitor your database transactions and should take necessary remedial steps whenever you identify such long-running transactions, as they can degrade the performance of the application drastically.

In this recipe, you will see how you can monitor the transactions by looking at their time duration. If you frequently find some transactions running for a long time, you may probably want to find if they are blocked by other transactions. You may also probably look into the query to investigate which statements of the transaction ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required