SentryOne Team Blog (blogs.sentryone.com)

Category : Monitoring

T-SQL Tuesday #66 – Monitoring

Lori Edwards (@loriedwards) contributes to this month's T-SQL Tuesday, advising us to focus on alerts that matter, and save the rest for reporting.

T-SQL Tuesday #66 : Monitoring

For T-SQL Tuesday, Jason Hall (@SQLSaurus) reminds us about checks and balances – your monitoring solution needs to be monitored to some degree, too.

I Didn't Know it Could Do That! : Enabling Additional Performance Counters

Justin Randall (@jh_randall) describes how to add additional performance counters in SQL Sentry Performance Advisor, and how you can make use of that data.

SQL Sentry Performance Advisor : Alerting, Baselines, and Standard Deviations

Lori Edwards (@loriedwards) gives some background on using standard deviation from a baseline for custom conditions in SQL Sentry Performance Advisor.

SQL Server Monitoring – Getting it Right

Justin Randall (@jh_randall) talks about some of the core principles you should adhere to when building or considering tools for SQL Server monitoring.

Tim Radney : Monitoring Read/Write Latency

Tim Radney (@tradney) of SQLskills.com shows us how we can be proactive in monitoring our I/O subsystems for read/write latency that can affect SQL Server performance.

Erin Stellato : Proactive SQL Server Health Checks : Settings

Erin Stellato (@erinstellato) adds another entry to her series on proactive health checks for SQL Server, this time treating database and instance settings.

Erin Stellato : Proactive SQL Server Health Checks : Maintenance

Erin Stellato (@erinstellato) of SQLskills.com continues her series on proactive SQL Server health checks, this time focusing on mastering maintenance tasks.

Erin Stellato : Proactive SQL Server Health Checks : Disk Space

Erin Stellato (@erinstellato) of SQLskills.com kicks off a series on proactive SQL Server health checks, explaining how she handles disk space management for customers.

Patience and sys.dm_exec_requests

Lori Edwards (@loriedwards) reminds us about a couple of columns in sys.dm_exec_requests that can give us an idea about the progress of certain operations.

Gap Analysis

Today I want to take a minute to talk about gaps. Not the kind where you find trendy clothes for the young (and young at heart) folks, but the kind that you might see in a performance chart on the SQL Sentry Performance Advisor Dashboard.

I've found myself explaining this to a few customers in recent months, and I wanted to get this down somewhere so that others may be able to find it on their own, or if they do ask I have reference material for them.

As a SQL Server DBA, Why Do I Need Performance Advisor for Windows?

SQL Sentry Performance Advisor (PA) for Windows is one of our newer product offerings, and I think one that could use a little bit of use-case clarification. I am often asked questions like this: "Why would I need Performance Advisor for Windows when Performance Advisor for SQL Server already shows me Windows metrics?"

There are several possible answers to this question:

Simplify your on-call hours with SQL Sentry's alerting and response features

For many DBAs and other IT professionals, on-call hours are part of the job. Keeping critical servers and applications running 24/7 requires the ability to respond to problems at any time of day. This usually means that a call or page to the on-call administrator when something does go wrong off-hours. With SQL Sentry's extensive automated alerting and response capabilities, this isn't always necessary. Let's take a look at how it works.