The Performance Zone is brought to you in partnership with New Relic. New Relic APM provides constant monitoring of your apps so you don't have to.
The following two undocumented stored procedures will do a miracle to your efforts to trace issues in SQL Server:
- EXEC sp_readerrorlog;
- 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.
The Performance Zone is brought to you in partnership with New Relic. New Relic’s SaaS-based Application Performance Monitoring helps you build, deploy, and maintain great web software.
Published at DZone with permission of
, DZone MVB
Opinions expressed by DZone contributors are their own.