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.

Here is your download link for SQL Diagnostic Manager for SQL Server!

Please choose the file that meets your system requirements:

You’ll also receive a confirmation email with a download link for your product. To ensure email delivery, please whitelist [email protected]. If you do not receive your email, please be sure to check both your inbox and filters for a message from [email protected]

Topics :

Products :

Robert L Davis

Robert L Davis is a senior database administrator and technical lead at Microsoft.
He is a speaker and a trainer as well as a writer for SQL Server Magazine, & co-authored “Pro SQL Server 2008 Mirroring” (Apress).Blog www.sqlsoldier.com
Twitter @sqlsoldier

Try SQL Compliance Manager FREE for 14 days


SQL-Compliance-Manager-Audit-SQL-Database-Screenshot

Monitor, audit and alert on SQL Server changes

  • Audit sensitive data to see who did what, when, where, and how
  • Monitor and alert on suspicious activity to detect and track problems
  • Satisfy audits for multiple industry regulatory requirements
  • Select from over 25 pre-defined compliance reports and create custom views
  • Lightweight data collection agent minimizes server impact

Start for Free