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

Download our Introduction to API Performance Testing and learn why testing your API is just as important as testing your website, and how to start 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,

Find scaling and performance issues before your customers do with our Introduction to High-Capacity Load Testing guide.

Topics:

Published at DZone with permission of Moshe Kaplan, DZone MVB. See the original article here.

Opinions expressed by DZone contributors are their own.

THE DZONE NEWSLETTER

Dev Resources & Solutions Straight to Your Inbox

Thanks for subscribing!

Awesome! Check your inbox to verify your email so you can start receiving the latest in tech news and resources.

X

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

{{ parent.tldr }}

{{ parent.urlSource.name }}