Tag : performance advisor - SentryOne Team Blog

Tag: performance advisor

SQL Server Optimizer Secrets With Trace Flag 86xx

SQL Server Optimizer Secrets With Trace Flag 86xx

Kevin Kline (@kekline) provides his slides and scripts from his new SQLBits session describing the deep internals exposed by the 86xx series of trace flags.

Custom Conditions: Trigger Threshold

Melissa Connors (@MelikaNoKaOi) explains when you should set a Trigger Threshold value on a Custom Condition and demonstrates a use case.

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.

I Didn’t Know It Could Do That! (Reports – not just for managers)

Continuing his series on "hidden" gems in SQL Sentry software, Justin Randall (@jh_randall) provides some valuable information about Performance Advisor and Event Manager reports.

SQL Sentry v8.2: Adaptive Web UIs and Fast Query Capture

Greg Gonzalez (@SQLsensei) walks through two exciting new features in SQL Sentry v8.2 : Adaptive UIs and Fast Query Capture.

I Didn't Know It Could Do That! (Part 2)

Justin Randall (@jh_randall) continues his insightful blog series, showing users things they may not know about the grids in SQL Sentry Performance Advisor.

SQL Sentry Fragmentation Manager : An Overview

Lori Edwards (@loriedwards) provides an overview of our add-in for SQL Sentry Performance Advisor, Fragmentation Manager, aimed at helping you manage and automate index maintenance.

I Didn't Know It Could Do That!

Justin Randall (@jh_randall) kicks off a blog series aimed at showing our customers things they might not know about SQL Sentry Performance Advisor and SQL Sentry Event Manager. First up: the "Jump To" menu.

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.