Monitor
*******

Links
=====

- `Monitoring Stored Procedure Usage`_
- `SQL SERVER - Find Currently Running Query - T-SQL`_

Profiler
========

- `Using SQL Server Profiler`_

Transactions
============

From *Management Studio*:

::

  dbcc opentran(<database name>)


.. _`Monitoring Stored Procedure Usage`: http://www.databasejournal.com/features/mssql/article.php/3687186
.. _`SQL SERVER - Find Currently Running Query - T-SQL`: http://blog.sqlauthority.com/2009/01/07/sql-server-find-currently-running-query-t-sql/
.. _`Using SQL Server Profiler`: http://msdn2.microsoft.com/en-us/library/ms187929.aspx