Greg Gonzalez (@SQLsensei) uses Plan Explorer to walk through troubleshooting a very common type of deadlock : updates conflicting with key lookups.
CEO Greg Gonzalez details the history of our company and our software, and explains the reasons behind rebranding our software platform to SentryOne.
No, this isn't a post about Aaron Bertrand's (b|t) SQLCruise around the Mediterranean, but rather a clever (or maybe not so) reference to the recently announced $25M growth equity investment in SQL Sentry! Read on, and I think you'll understand… The not-so-secret formula Work on SQL Sentry software started as a small side project in
Greg Gonzalez (@SQLsensei) walks through two exciting new features in SQL Sentry v8.2 : Adaptive UIs and Fast Query Capture.
It's tempting to insert some clever reference to everyone's favorite vegetable juice medley here, but I will refrain, for fear of diminishing what is perhaps the most significant SQL Sentry release to date! In v8 we've addressed the three most frequent requests from our users – performance alerting, baselining, and cloud access – and we've done so in typical SQL Sentry fashion.
First up in the series on v8: Performance Alerting (aka, Custom Conditions).
Our ultimate objective with this release of SQL Sentry Performance Advisor was to increase visibility and manageability around AlwaysOn in dramatic fashion, thereby enabling it to reach its full potential. This new functionality is so powerful, some of our clients are even using it for resource management across commodity servers, something I'm not sure the AlwaysOn creators ever envisioned. I'll delve into that in a future post, but for now, I wanted to give some insight into these features.
Have you ever worked with a query plan that was so large and unwieldy that it was next to impossible to make any sense of it? It can be a frustrating endeavor, for sure.
The new version of Plan Explorer PRO 2.5 is focused on making these big plans easier to manage, and it does so using a variety of techniques that you have been asking for, which I will cover below.
It's hard to believe that we released the first version of Plan Explorer almost two years ago! The acceptance it has seen by the SQL Server community during that time has been amazing, and tremendously gratifying for all of us here at SQL Sentry.
From the start we've had many requests for additional features and functionality. Many of those went directly into the free tool (for a full list go here). For others, it was obvious that some serious heavy lifting and/or an increase in the support requirements would be involved, making them not well-suited for a free tool.
Plan Explorer PRO is the result of many months of building out several of those high effort/high value features you've been asking for. Initially we've targeted the features that we believe will have the greatest impact on efficiency and information sharing. Here are the top 5 major features in PRO: