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.
Kevin Kline (@kekline) shares the slide deck and video from his recent webinar on reducing latency and boosting performance in SQL Server.
Melissa Connors (@MelikaNoKaOi) continues her series on data compression, focusing on costs of implementation, index maintenance, and running SQL Sentry.
Greg Gonzalez (@SQLsensei) walks through two exciting new features in SQL Sentry v8.2 : Adaptive UIs and Fast Query Capture.
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.
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: