Tracing SQL Server Performance and Stability Issues
DZone's Guide to
Tracing SQL Server Performance and Stability Issues
Join the DZone community and get the full member experience.
Join For FreexMatters delivers integration-driven collaboration that relays data between systems, while engaging the right people to proactively resolve issues. Read the Monitoring in a Connected Enterprise whitepaper and learn about 3 tools for resolving incidents quickly.
The following two undocumented stored procedures will do a miracle to your efforts to trace issues in SQL Server:
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,
Like This Article? Read More From DZone
Topics:
Published at DZone with permission of Moshe Kaplan , DZone MVB. See the original article here.
Opinions expressed by DZone contributors are their own.
{{ parent.title || parent.header.title}}
{{ parent.tldr }}
{{ parent.linkDescription }}
{{ parent.urlSource.name }}