SentryOne Team Blog (

Tag : performance advisor

Finding Low Use Indexes via SentryOne

Finding Low Use Indexes via SentryOne

Andy Yun writes about one of his upcoming sessions for SQLBits and encourages everyone to take the time to find and clean up their low use indexes. For SentryOne users, Andy offers up sp_FindLowUseIndexesS1 to help you identify nonclustered indexes that are under used or not used at all.

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.

How to Reduce Latency and Boost SQL Server Performance Webcast, Slides, and Scripts

Kevin Kline (@kekline) shares the slide deck and video from his recent webinar on reducing latency and boosting performance in SQL Server.

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 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: