Over a million developers have joined DZone.
{{announcement.body}}
{{announcement.title}}

Tracing SQL Server Performance and Stability Issues

DZone's Guide to

Tracing SQL Server Performance and Stability Issues

· Performance Zone ·
Free Resource

Sensu is an open source monitoring event pipeline. Try it today.

The following two undocumented stored procedures will do a miracle to your efforts to trace issues in SQL Server:

  1. EXEC sp_readerrorlog;
  2. DBCC LOG('DATABASE_NAME', 3);
The first can be used to find failures, backup procedures and other goodies in the database log. The second can be used to trace heavy UPDATE, DELETE and INSERT transactions  in the transaction log of a specific database.

Keep Performing,

Sensu: workflow automation for monitoring. Learn more—download the whitepaper.

Topics:

Published at DZone with permission of

Opinions expressed by DZone contributors are their own.

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}