SentryOne Team Blog (blogs.sentryone.com)

Tag: SQL Sentry

Enabling "super admin" on Windows 10

Aaron Bertrand (@AaronBertrand) explains how he worked around a recent problem with Windows 10 and its not-so-administrator administrator account.

Live and In-Person: SQL Sentry Events in September

Kevin Kline (@kekline) tells you about four big upcoming SQL Server events in September where various members of the SQL Sentry team will be speaking.

SQL Sentry Adds Two Powerhouse Technology Evangelists in the UK

WHAT’S HAPPENED? When I joined SQL Sentry three years ago, I was the 14th person in the building. We occupied a much smaller and more crowded space in a different building then. But the community responded – in a huge way – by buying our products and supporting our growth. Nick Harshbarger's Office circa 2012.

Applying Data Compression to the SQL Sentry Database : Part 5 (Follow-up)

Melissa Connors (@MelikaNoKaOi) follows up on her data compression series, providing details on wait statistics, MAXDOP settings, and Performance Advisor.

Applying Data Compression to the SQL Sentry Database : Part 4

Melissa Connors (@MelikaNoKaOi) concludes her data compression series, providing the DDL commands you can apply to your own SQL Sentry database.

Applying Data Compression to the SQL Sentry Database : Part 3

Melissa Connors (@MelikaNoKaOi) continues her compression series, looking at disk I/O, memory usage, and decision-making tables for selecting compression.

Applying Data Compression to the SQL Sentry Database : Part 2

Melissa Connors (@MelikaNoKaOi) continues her series on data compression, focusing on costs of implementation, index maintenance, and running SQL Sentry.

Applying Data Compression to the SQL Sentry Database : Part 1

Melissa Connors (@MelikaNoKaOi) investigates the approach, costs, and space/performance benefits of applying data compression to the SQL Sentry database.

Validating network blips using SQL Sentry data

Aaron Bertrand (@AaronBertrand) shows a few tricks for visualizing and comparing "service offline" alerts to help validate and troubleshoot network blips.

A New Chapter Begins

Jason Hall (@SQLSaurus) talks about his career here at SQL Sentry – from his early beginnings as a developer to his future as a Product Manager.

SQL Sentry in the Cloud

Rick Pittser (@rjpittser) talks about his new role as Cloud Services Product Manager here at SQL Sentry, and welcomes suggestions for our offerings.

White Paper : A New Take on Alerting

The promise of alerting is that it makes it possible for people to keep up with the information that matters most to them. Simple, right? But this doesn't always work – read this white paper to discover why.

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:

SQL Sentry v8: Baselines from Every Angle

In my last post I covered the exciting new intelligent alerting features in SQL Sentry v8. Next up in the series is another huge and often requested feature: Baselining.