Troubleshooting

SQL Server Performance Troubleshooting with SQL Monitor 5

  • Article

Any SQL Server monitoring tool must gather the metrics that will allow a DBA to diagnose CPU, memory or I/O issues on their SQL Servers. It should also provide a set of accurate, reliable, configurable alerts that will inform the DBA of any abnormal or undesirable conditions and properties, as well as specific errors, on any of the monitored servers. This article provides an in-depth guide to the monitoring and alerting functionality available in one such tool, Redgate SQL Monitor. It focuses on the latest edition (5.0), which includes several key new features, such as performance diagnosis using wait statistics, the ability to compare to baselines, and more.

2016-02-29

3,147 reads

Free eBook: Troubleshooting SQL Server: A Guide for the Accidental DBA

  • Article

Three SQL Server MVPs (Jonathan Kehayias, Ted Krueger and Gail Shaw) provide fascinating insight into the most common SQL Server problems, why they occur, and how they can be diagnosed using tools such as Performance Monitor, Dynamic Management Views and server-side tracing. The focus is on practical solutions for removing root causes of these problems, rather than "papering over the cracks".

2019-07-03 (first published: )

103,660 reads

Blogs

A simple powershell script to look up server hardware and OS information

By

This is a simple powershell script to query and display hardware and OS information...

Collecting Server Performance Metrics: Performance Monitor

By

Whether you’re a DBA/administrator looking to tune a server, planning for hardware updates, or...

Introduction to SQL Server Execution Plans

By

Watch this week’s episode on YouTube! I nearly always use execution plans as the...

Read the latest Blogs

Forums

Evergreen SQL Server

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Evergreen SQL Server

Do you really know what’s happening with your servers?

By Additional Articles

Comments posted to this topic are about the item Do you really know what’s...

Going from long to wide

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Going from long to wide

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers