Related MicroZone Resources
Like this piece? Share it with your friends:
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.
Keep Performing,
Moshe Kaplan
Published at DZone with permission of Moshe Kaplan, author and DZone MVB. (source)(Note: Opinions expressed in this article and its replies are the opinions of their respective authors and not those of DZone, Inc.)
