Whitepaper : Establishing and Setting Thresholds for a SQL Server Environment

 

Introduction:

This white paper is a guide for DBAs about determining the proper thresholds for monitoring a SQL Server environment.

Monitoring SQL Server is a critical component of a Database Administrator’s, or DBA’s, job. The bigger the environment is, the more important monitoring becomes. Enterprise environments typically have a high ratio of servers to DBAs and no DBA can keep watch of every aspect of the environment on their own. A very important aspect of monitoring is alerting.

Monitoring alone isn’t enough. When certain resource metrics or counters are reached, the DBA needs to be alerted and, in some cases, immediately notified that the threshold has been reached. Alerts can be delivered in a variety of ways and should not be confused with notifications. Alerts can be written to a log, raised in an application interface, or sent to another system for processing. A notification is a response to an alert that informs a person, or a group of people, that a specific alert has been raised.

Topics :

Products :

Robert L Davis

Robert L. Davis was a senior database administrator and technical lead at Microsoft. He had over 11 years of experience with SQL Server, including expertise in high availability, disaster recovery, performance tuning, and data architecture. Robert was a speaker and trainer. He was also a writer for SQL Server Magazine and co-authored “Pro SQL Server 2008 Mirroring” by Apress.

Try SQL Diagnostic Manager for SQL Server FREE for 14 days


SQL Diagnostic Manager Repository dashboard

24X7 SQL performance monitoring, alerting and diagnostics

  • Monitor performance for physical, virtual, and cloud environments.
  • Monitor queries and query plans to see the causes of blocks and deadlocks.
  • Monitor application transactions with SQL Workload Analysis add-on.
  • View expert recommendations from SQL Doctor to optimize performance.
  • Alert predictively with settings to avoid false alerts.
  • View summary of top issues and alerts with the web console add-on.

Start for Free