/ Performance Zone
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

by
Moshe Kaplan
·
Feb. 14, 13 · Performance Zone
Free Resource

Comment (0)

Save
Tweet
{{ articles[0].views | formatCount}} Views

Transform incident management with machine learning and analytics to help you maintain optimal performance and availability while keeping pace with the growing demands of digital business with this eBook, brought to you in partnership with BMC.

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,

Evolve your approach to Application Performance Monitoring by adopting five best practices that are outlined and explored in this e-book, brought to you in partnership with BMC.

Like This Article? Read More From DZone

Using AI to Predict Cardiac Risk in Liver Transplant Patients
New RegEx Features in Java 9
Announcing log4j-aws-appenders

Free DZone Refcard

Scalability & High Availability
DOWNLOAD
Topics:

Comment (0)

Save
Tweet
{{ articles[0].views | formatCount}} Views

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

Opinions expressed by DZone contributors are their own.

Performance Partner Resources

Improve App Performance and User Experience Across Your Hybrid Infrastructure
Don't Take Chances When Choosing an APM Solution - APM Tools & Features Review
Five Strategies to Move from a Reactive to a Proactive Approach to Incident Management

Performance Partner Resources

Improve App Performance and User Experience Across Your Hybrid Infrastructure
Don't Take Chances When Choosing an APM Solution - APM Tools & Features Review
Five Strategies to Move from a Reactive to a Proactive Approach to Incident Management
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.linkDescription }}

{{ parent.urlSource.name }}
by {{ parent.authors[0].realName || parent.author}}
· {{ parent.articleDate | date:'MMM. dd, yyyy' }} {{ parent.linkDate | date:'MMM. dd, yyyy' }}
· {{ parent.portal.name }} Zone