SentryOne Team Blog
Latest Builds of Management Studio

Latest Builds of Management Studio

Find information about the builds of SQL Server Management Studio in the new release cycle approach; locate previous versions.

Seeing Memory Pressure Affect SQL Server Performance in SentryOne

Seeing Memory Pressure Affect SQL Server Performance in SentryOne

We all know (or should know) that SQL Server wants a lot of memory – in fact, it wants all of it. The more memory you allocate to SQL Server, the better the performance of the server (in general.) So it's important to know when you have memory pressure, whether it comes from internal or

SentryOne Partner Spotlight: UpSearch

SentryOne Partner Spotlight: UpSearch

The SentryOne Global Partner Network is pleased to highlight UpSearch, our Partner Spotlight for this month. UpSearch is a company of data platform and analytics experts who exclusively support Microsoft’s technologies. As a Managed Microsoft Gold Partner (top 1%), UpSearch provides full lifecycle support for SQL Server, SQL Server in Azure (IaaS), Azure SQL DB

T-SQL Tuesday #99: Missing Indexes and Index Key Order

T-SQL Tuesday #99: Missing Indexes and Index Key Order

Welcome to the 99th edition of T-SQL Tuesday, hosted this month by friend (and coworker) Aaron Bertrand. We were given a choice and I decided to dive into Aaron's Index of T-SQL bad habits to find my inspiration. I knew I found a winner when I saw Aaron's "Don't just blindly create those "missing" indexes!"

T-SQL Tuesday #99 – My favorite Aaron Bertrand (T-SQL) rant

T-SQL Tuesday #99 – My favorite Aaron Bertrand (T-SQL) rant

Lori Edwards, SentryOne Training Manager, writes about one of her favorite T-SQL rants in this T-SQL Tuesday #99 blog post.

T-SQL Tuesday #99 : Performing is my Passion

T-SQL Tuesday #99 : Performing is my Passion

Allen White, MS-MVP and SentryOne Senior Technical Training Specialist, writes about his passion for performing for T-SQL Tuesday #99.

Paul White : Setting and Identifying Row Goals in Execution Plans

Paul White : Setting and Identifying Row Goals in Execution Plans

Paul White provides some great information about row goals, explaining why they're important to understand when examining why the query optimizer made a certain choice.

Latest Builds of SentryOne Software

Latest Builds of SentryOne Software

Latest builds of the SentryOne platform and Plan Explorer, as well as updated blog posts, downloads, and change lists.

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.

When Troubleshooting Performance Start with the Big Picture

When Troubleshooting Performance Start with the Big Picture

Allen White blogs about one of the great benefits of SQL Sentry: it presents you with an overall picture of the server's performance, allowing you to see what's going on as a whole, and then allowing you to drill into the areas that may be of concern.

Q & A from our Parameter Sniffing webinar series

Q & A from our Parameter Sniffing webinar series

Aaron Bertrand addresses the questions raised during two parameter sniffing webinars in January with Kimberly L. Tripp and Andy Mallon.

SQL Saturdays are for Learning

SQL Saturdays are for Learning

Allen White, Microsoft MVP and SentryOne Senior Technical Training Specialist, explores different avenues for learning at SQL Saturday events.

Diagnose Performance Issues in Microsoft APS and Azure Data Warehouse with SentryOne Alerts

Diagnose Performance Issues in Microsoft APS and Azure Data Warehouse with SentryOne Alerts

Steven Wright explains how to diagnose performance issues in Microsoft APS and Azure Data Warehouse with SentryOne Alerts and lists some custom Advisory Conditions (AC) that many people find useful when monitoring these systems.

SentryOne Adds Irish Subsidiary

SentryOne Adds Irish Subsidiary

SentryOne announced it would expand internationally by opening an office in Dublin City Centre, Ireland, in early 2018 in order to better serve EMEA markets. The new Irish subsidiary, SentryOne Ltd., will add sales, channel and customer support staff as soon as next month.

Upcoming Webinar

Upcoming Webinar "Preventing SQL Server Performance Problems Before They Hit Production" on Feb 8th

Kevin Kline describes a new Webinar featuring Sabin IO. If you're a DBA who must remedy poor performance on a SQL Server, or a Developer responsible for writing fast and dependable code, then you'll want to attend this session.