SentryOne Team Blog (blogs.sentryone.com)

Category : Monitoring

SQL Sentry v9.0 : Virtualization, Cloud VMs, Global Baselines

Jason Hall (@SQLSaurus) explains major features in the SQL Sentry v9 release, including virtualization, cloud support, global baselines, and enhanced setup.

SQL Sentry v9.0 Virtualization Support : Hyper-V

Jason Hall (@SQLSaurus) explains SQL Sentry Performance Advisor monitoring of Hyper-V virtual machines as a follow-up to his v9.0 announcement post.

SQL Sentry v9.0 Virtualization Support : VMware

Continuing from his v9.0 announcement post, Jason Hall (@SQLSaurus) describes SQL Sentry Performance Advisor monitoring of VMware guests and hosts.

SQL Sentry v9.0 : Monitoring APS and Azure SQL Data Warehouse

David Benoit gives a high-level overview of new monitoring capabilities in SQL Sentry v9.0 : APS and Azure SQL Data Warehouse.

Troubleshooting SQL Server Part 3: Where are the Waits?

Kevin Kline (@kekline) marches on with another entry in his checklist series on troubleshooting SQL Server, this time focusing on wait statistics.

Erin Stellato : Capture Execution Plan Warnings using Extended Events

Erin Stellato (@erinstellato) of SQLskills shows how to use Extended Events to monitor for query plans with certain characteristics, such as joins missing predicates, columns missing statistics, and unmatched filtered indexes.

Troubleshooting SQL Server, Part 2 : Inside or outside? Error or Not?

Kevin Kline (@kekline) continues his checklist series on troubleshooting SQL Server, looking at locating the source of the problem and error conditions.

SQL Saturday #434 Holland – Slides

John Martin (@SQLDiplomat) talks about his session at the recent SQL Saturday event in Utrecht, Holland, and shares his slide deck from the session.

Troubleshooting SQL Server, Part 1 : Do You Use These Shortcuts?

Kevin Kline (@kekline) starts a new blog series, presenting a checklist of things you can do to help you better troubleshoot SQL Server.

T-SQL Tuesday #70 – Managing an Enterprise

For September's T-SQL Tuesday, Lori Edwards (@loriedwards) talks about how she coped with managing a critical hospital application in her first DBA gig.

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.

Jonathan Kehayias : Monitoring Availability Group Replica Synchronization

Jonathan Kehayias (@SQLPoolBoy) of SQLskills uses practical examples to show multiple ways to monitor Availability Group replica synchronization in your environment.

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.

Tracing usage of trace flags

After a presentation at SQLintersection, Aaron Bertrand (@AaronBertrand) shows how to monitor when users are turning trace flags on and off.

T-SQL Tuesday #66 : Babysitting a slow backup or restore

For T-SQL Tuesday, Aaron Bertrand (@AaronBertrand) talks about two undocumented trace flags that help provide additional diagnostics to help troubleshoot slow backup or restore operations.