SQL Sentry News

Our news room includes recent product reviews, press releases, eNews, and external blogs about SQL Sentry software. Also check out our blog posts for additional articles.

November 2014

eNews, November 2014 - Release of SQL Sentry v8.2

SQL Sentry Recognized For Unparalleled Support of the SQL Server Community With Prestigious Third MVP Award. You might look at the headline and think “Of course, SQL Sentry supports the SQL Server community. That’s where they make all their money.” However, it really is much more than monetization with us, which I’ll explain in a moment. But first I’m proud to announce that Greg Gonzalez, our CEO, was recently awarded Microsoft’s prestigious Most Valuable Professional Award (MVP) for his support of the SQL Server community.

October 2014

How can I view more than one Performance Advisor dashboard at a time?

Jim Holden (@SQLJim) has a new post over on blogs.sqlsentry.com. Have you ever wondered how to view more than one Performance Advisor dashboard at a time? The ability to see multiple dashboards is very helpful to many folks, especially our customers working in Network Operations Centers. So, Jim walks through the steps that you can follow to set this up in any environment.

September 2014

eNews, September 2014 - New Version of Plan Explorer

Until the release of SQL Server 2000, there was no widely known and fully documented way to clear the important caches within SQL Server without fully restarting the service. (There were some undocumented methods introduced in SQL Server 7.) As a person writing a lot of SQL statements and stored procedures, it was especially difficult to get good performance metrics comparing two different queries that returned the same result set without quite a bit of extra work.

August 2014

eNews, August 2014 - SQL Server Resources and Overview of Fragmentation Manager

Back when I was starting my career in the late ‘80s, it took a lot of work to upgrade your technology skills. Back then, you had to deliberately and actively acquire resources to get better. There was no Internet. Purchasing kits to experiment with and learn on was pricey, with an IBM-PC clone costing between $2400 and $3600. That’s nearly 2-3 times more in today's dollars. Bookstores were mostly of the local mom-and-pop variety with few technology titles on the shelves to choose from, since large book chains were years in the future.

August 2014

I Didn't Know It Could Do That! (Part 2)

Justin Randall continues his blog series aimed at showing our customers things they might not know about Performance Advisor and Event Manager. In this post, Justin explores the many properties of a single control type found throughout the SQL Sentry Client - the grid.

July 2014

SQL Sentry Fragmentation Manager: An Overview

Lori Edwards goes over our product Fragmentation Manager, which is an add-in to Performance Advisor. Performance Advisor on its own provides a great deal of information about the indexes within your databases, but Fragmentation Manager adds additional insight into health, size and usage of your indexes as well as provides a tool to manage your indexes.

July 2014

I Didn't Know It Could Do That

Justin Randall begins a blog series aimed at showing our customers things they might not know about Performance Advisor and Event Manager. In this first post, Justin discusses the “Jump To” Menu, which is a context menu command that allows you to navigate from one element of the client to another while maintaining the time range of the jump off point.

July 2014

Another Way to View Automatic Updates to Statistics

Over on SQLPerformance.com, Erin Stellato of SQLskills.com has a blog series where she looks at different methods that can be used to track automatic updates to statistics. In her first post, she went through 3 options that are available in SQL Server: SQL Trace, Extended Events, and snapshots of sys.dm_db_stats_properties. In this post, she discusses how Plan Explorer and Performance Advisor make it easier to track automatic statistics updates.

July 2014

eNews, July 2014 - New White Paper on Alerting

One of the questions I frequently encounter is “I know what I’m supposed to do with my monitoring and tuning tools, but why should I do those things?” I’m happy to inform you that I have been hard at work on answering a variety of those why questions. In fact, we’ve started a push to create more and deeper content on the why of database monitoring and tuning best practices. That means you’ll be seeing a variety of new white papers (i.e. long and in-depth) and tech briefs (i.e. short and distilled) relating to managing, maintaining, and tuning your SQL Server investments.

June 2014

SQL Server, SharePoint & Windows Alerts: A New Take on Alerting

In this white paper, SQL Server MVP Kevin Kline discusses how the basic alerting system included with SQL Server behaves. He also shows how SQL Sentry's alerting functionality overcomes many of these limitations and those of many other alerting systems. Whether you're currently using a Windows, SharePoint, or SQL Server alerting system that you're very happy with or you're considering acquiring one, it's important to be aware of the potential limitations of that alerting system and then develop strategies to shore up those weaknesses.

June 2014

Fixes for SQL Server 2012 & 2014 Online Index Rebuild Issue

Aaron Bertrand warns about a parallelism bug found in SQL Server 2012 and 2014 that could lead to data loss following online index rebuilds. If you are in a situation where you can’t apply the 2012 or 2014 hot fixes that address the issue, then you can use Fragmentation Manager’s MAXDOP setting to bypass the bug.

May 2014

eNews, May 2014 - The Summer Sprint

Our May newsletter is a little later than usual due to what we call the Summer Sprint. This is the yearly period from May to June where we attend what seems like a gazillion conferences and events, such as the PASS Business Analytics Conference and Microsoft TechEd. This keeps us on the go and probably also leaves the Dev team a lot happier that we’re not drinking all of their favorite coffee in the Pub.

April 2014

Welcome Global Alliance Partner SQL Sentry

PASS is excited to welcome SQL Sentry as a Gold Level Global Alliance Partner, expanding the company’s strong individual event and program sponsorships into a comprehensive, strategic relationship that supports the worldwide PASS community year-round.

April 2014

eNews, April 2014 - The New SQL Sentry

Spring has sprung throughout the South here in the USA. The Bradford pear trees, saucer magnolias, and forsythia have all blossomed, bringing a rainbow of colors and sweet fragrances to life. And just as the natural world is bursting forth everywhere you look, so is SQL Sentry. The first thing you might notice upon visiting www.sqlsentry.com (that’s right, DOT COM!) is the entirely new look and feel for the website.

April 2014

SQL Sentry v8: Baselines from Every Angle

In my last post I covered the exciting new intelligent alerting features in SQL Sentry v8. Next up in the series is another huge and often requested feature: Baselining. Designing this feature proved to be somewhat of a challenge due to the diversity of opinions on this topic. Seems that everyone has a different idea about baselining – what it is, and how it should be used effectively to improve performance.

April 2014

SQL Sentry Introduces v8 with Intelligent Alerting, Baselining, and Cloud Features

The Power Suite continues its category dominance as the most complete monitoring solution available for SQL Server, with seamless history tracking and the lowest documented server overhead. The new features of v8 fall into three main categories: intelligent performance alerting, flexible performance baselining and cloud access to shared performance data.

March 2014

SQL Sentry v8: Intelligent Alerting Redefined

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.

March 2014

An updated Plan Explorer demo kit

Back in 2010, we first released SQL Sentry Plan Explorer, a free application for query tuning through deep but intuitive execution plan analysis. The following year, I created a demo kit for Plan Explorer, responding to numerous requests for demos to help people share the tool (without having to come up with their own problematic queries and interesting plans). The kit was designed to give people better insight into the advantages of our tool, and to help them share its virtues with colleagues, user groups, and the SQL Server community at large.

February 2014

eNews, February 2014 - Top SQLPerformance.com Articles

February is the month for Valentine’s Day. So let’s take a couple of minutes to share the love with all of the technical knowledge we’ve been publishing lately. It’s not quite a dozen roses and a box of chocolates, but if it can save me a lot of time and effort at the office, it’s a gift that’s just as sweet.

January 2014

eNews, January 2014 - On The Road

We’ve turned the corner and have come full stride into 2014 with a flurry of activity. On the R&D side, we’re hard at work pushing our latest product release through final beta testing with the intention of putting a wrap on the RTM code very soon.

December 2013

eNews, December 2013 - Year Recap

We’ve reached the time of year, between Christmas and New Year’s Day, in which it is customary to reflect on the past twelve months and to plan for the next twelve. 2013 has been a huge year for SQL Sentry. There are, of course, some of the really big milestones to celebrate, such as doubling the size of our staff.

November 2013

eNews, November 2013 - Meet the Authors

One of the things that attracted me to SQL Sentry as a potential employee was that I liked the people and the culture. The corporate culture is focused on developing technical excellence in our products and within the staff, as well as a strong emphasis on responsiveness to our customers.

October 2013

eNews, October 2013 - PASS Summit Recap

The annual PASS Summit, held in our hometown of Charlotte, NC, was at the top of our minds for the month of October. And we rolled out the red carpet in a big way. If you know anything about the staff here at SQL Sentry, then you’re probably expecting me and my colleague Microsoft MVP Aaron Bertrand to be doing double-duty at the conference. And you certainly wouldn’t be wrong.

September 2013

A Brief Tour of SQL Sentry's "AlwaysOnMonitoring"

"My first impressions are very favorable and I do think this is a useful tool – particularly for environments that have numerous availability groups and higher complexity topologies."

September 2013

eNews, September 2013 - Fall Conference Season

Personally, fall is my favorite season of the year. I’m always thankful when the summer heat abates and the nights take on a chill. Just as so many kids look forward to June and the summer break that follows, I look forward to September and the change in weather that follows.

August 2013

SQL Sentry Introduces v7.5 including AlwaysOn Monitoring

"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," said Greg Gonzalez, President and CEO, SQL Sentry. "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."

August 2013

eNews, August 2013 - Richard Petty Driving Experience Winners

The heavy rains of August may have washed out the gullies and flooded the parking lot here at SQL Sentry HQ, but they certainly didn’t dampen our spirits. With last month’s release of the 7.5 version of our flagship product, SQL Sentry, the Dev team is hard at work on the next elements on our product roadmap.

July 2013

SQL Sentry v7.5: A Better AlwaysOn

When we released SQL Sentry v7.2 with dedicated Windows monitoring last October, we were already hard at work on the AlwaysOn-oriented features that would become v7.5. We wanted to be the first to market with integrated, visual AlwaysOn monitoring and management, and I'm happy to say that we've achieved this goal – v7.5 RTM is now available for download!

July 2013

eNews, July 2013 - version 7.5

There are so many cool things going on at SQL Sentry this month that I hardly know where to start. But I’m going to give it my best shot. Before I get started let me remind you, if you’ve been attending our weekly SQL query tuning webcasts, then you know that on July 31st, we’ll be giving away our big SQLRacerX prizes. There’s still time to get your name into the hat with our last demo webcast scheduled for July 31st.

June 2013

eNews, June 2013 - Richard Petty Driving Experience

Summer is here and we are running full throttle. We’ve already had hundreds of entries, but the odds are still in your favor to win one of 3 Rookie Experience packages or 3 Ride Along packages from the Richard Petty Driving Experience at the Charlotte Motor Speedway! You’ll be able to enjoy the ride of a lifetime and a fun party to boot on the closing Friday of the PASS 2013 Summit in our hometown of Charlotte, NC.

May 2013

eNews, May 2013 - UK Travel Recap and eBook Sign-up

A lot has happened since our last eNews edition and there is even more in the works. Our new eBook is almost ready! You can email ebooks@sqlsentry.net to get on the pre-order list or attend one of our weekly SQL Server webcast to get the promo code allowing you to download the eBook from the Kindle store for free.

April 2013

eNews, April 2013 - Conferences, Keynotes, and Community

April was one of our busiest months ever here at SQL Sentry. Just about every facet of the organization is hard at work. We have a pipeline full of new R&D innovations in the works. All of our teams are growing and on-boarding new staff. Plus, it’s the spring conference onslaught.

March 2013

Plan Explorer PRO 2.5: Query plans your way

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. Plan Explorer has always done some things that can help with these plans, such as color-scaling costs and vertically compressing subtrees. Even so, when you're zoomed out to 10% and still only fitting a quarter of the plan on screen, color-scaling won't buy you much.

March 2013

eNews, March 2013 - The Amazing Little Toolbar

It is amazing how one little toolbar can make such a huge difference by providing an unprecedented level of control in how you visualize your query execution plans.

February 2013

eNews, February 2013 - Plan Explorer + SQLPerformance.com

I love it when a plan comes together! In this case, I’m talking about execution plans. As you’ll see in our Product News category, we’ve been hard at work building an even stronger set of execution plan assessment features into both the Free and PRO versions of Plan Explorer. The key new feature in our February release is, in a word, "socialization". We’ve made it one-click easy to get help with your execution plan at our new Q&A website Answers.SQLPerformance.com.

January 2013

eNews, January 2013 - Announcing Performance Advisor for Windows

There are so many fun and exciting things to tell you about in this issue of the SQL Sentry eNews! First of all, please allow me to say Hi. My name is Kevin Kline, a long-time veteran of the SQL Server community. I was privileged to join the SQL Sentry team back in the summer of 2012. SQL Sentry has some of the most powerful and useful tools on the market today and I'm really happy to be able to contribute to the next generation of even better tools and services.

December 2012

Trimming the Transaction Log Fat

Paul Randal discusses how the database’s transaction log can be a bottleneck that adds to the time it takes a transaction to complete. He also discusses how to identify fragmented indexes to ultimately help reduce transaction log usage.

November 2012

SQL Sentry Introduces Power Suite v7.2 at PASS Community Summit

The Power Suite continues its category dominance as the most complete monitoring solution with seamless history tracking and the lowest documented server overhead. The new features of v7.2 fall into three main categories: Query Plan Analysis, Windows Monitoring, and History/Alert Filtering. v7.2 includes two exciting new products: Performance Advisor for Windows and Event Manager for Windows.

November 2012

eNews, SQL Sentry Launches Version 7.2

We recently showcased our latest release, SQL Sentry version 7.2, at SQLConnections in Las Vegas and the PASS Community Summit 2012 in Seattle. Both were great conferences and we always appreciate the opportunity to meet personally with the SQL Server community.

October 2012

SQL Sentry Launches Plan Explorer PRO

"SQL Sentry Plan Explorer PRO was developed in response to many users’ request for additional features and functionality that fall beyond the scope of a free too", said Greg Gonzalez, President and CEO, SQL Sentry. "Several of the features required significant development effort but they deliver the enhanced efficiency that busy SQL Server professionals require".

October 2012

SQL Sentry v7.2 does Windows (and a whole lot more)

Since releasing SQL Sentry v7 with Fragmentation Manager in May, we've been hard at work on v7.2. Development ran concurrently with Plan Explorer PRO, which was released last week. v7.2 includes two exciting new products: Performance Advisor for Windows and Event Manager for Windows. The release candidate was recently published, and you can download it from our customer portal.

October 2012

It's Time to Go PRO!

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

August 2012

My Perspective: The Top 5 Most Common SQL Server Performance Problems

In this post, Jason Hall shares the top 5 SQL Server Performance issues that our Client Services team sees on daily basis. He discusses the problems with tempdb PAGELATCH contention, expecting auto update statistics to keep statistics updated, and more.

July 2012

SQL Sentry Announces Kevin Kline As Director of Engineering Services

Kevin has been a Microsoft SQL Server MVP since 2004 and is a noted leader in the SQL Server industry. His product designs have won multiple "Best of TechEd" and "Readers' Choice" awards. He is a founding board member and former president of PASS. He has written or co-written eleven books including the best-selling SQL in a Nutshell. Kevin contributes monthly columns to SQL Server Pro and DBTA magazines.

July 2012

eNews, SQL Sentry Announces Kevin Kline as Director of Engineering Services

We're excited to announce the newest addition to the SQL Sentry team, Kevin Kline. It would be difficult to be a member of the SQL Server world and not know who Kevin is, and be aware of his many contributions to the community.

May 2012

SQL Sentry v7 goes Gold!

After what has been a relatively smooth beta, we're going gold with v7 today! Read more about v7 features in my last post. I've also got some exciting news regarding new fragmentation-related features included in the base software, and how to get FREE licenses of both Performance Advisor and Fragmentation Manager.

April 2012

SQL Sentry v7: With our new Fragmentation Manager module

7 represents the culmination of almost a year of effort, and ideas going back much, much further than that. We've completely redone several aspects of the software such as alerting (condition and action) configuration, and we've added some awesome new features like automated defrag, computer groups, and CMS support to boot. Did I mention SQL Server 2012?

January 2012

Comparing multiple plans in SQL Sentry Plan Explorer

I’ve seen the question a few times now: “How do I compare two plans side-by-side in Plan Explorer?” Management Studio allows you to view multiple graphical plans that are visible simultaneously, either by generating plans for every statement in a batch, or by generating plans in separate query windows and then splitting the panes. However, at least in my estimation, a lot of the other metrics and properties are more valuable when performing comparisons.

December 2011

Product Review: SQL Sentry Power Suite 6.2 Earns 4.5 Out of 5 Stars!

"SQL Sentry Power Suite is feature rich and provides easy navigation between its integrated applications using a predictable console. I was impressed by how comprehensive it was and surprised at how useful it could be as a tool for ensuring good performance from the BI solutions that I design," says Brian Erlich, SQL Server Pro (Magazine)

November 2011

SQL Sentry Named As Winner of Multiple SQL Server Magazine Awards

SQL Sentry Performance Advisor, Event Manager and Plan Explorer are recognized with six awards from Penton Media’s SQL Server Magazine in the following categories: Best Database Monitoring and Performance Product, Best Database Management Product, and Best Free Tool.

October 2011

eNews, SQL Sentry Version 6.2, Plan Explorer, and SQLskills

We recently showcased our latest release, SQL Sentry version 6.2, at SQLBits 9 in Liverpool and the PASS Summit 2011 in Seattle. We continue to receive accolades for not only developing SQL Sentry Plan Explorer, but also for making it available to the community for FREE. And, if you've not had the opportunity to attend SQLskills Immersion Training, do whatever you need to in order to make that happen in 2012.

October 2011

SQL Sentry v6.2: SharePoint Timer Jobs, Oh My!

We recently released SQL Sentry v6.2, and it introduces an exciting new product: Event Manager for SharePoint. v6.2 contains several other new features as well, including SSAS usage metrics, performance dashboard event overlay, enhanced console security, and a streamlined setup process. SharePoint support and SSAS usage in particular have been heavily requested, so this release should make quite a few customers very happy!

October 2011

Plan Explorer Demo by Paul Randal (SQLskills)

Paul Randal of SQLskills shows how to analyze what's using space in tempdb, and provides an overview of how to use SQL Sentry Plan Exporer in the investigation.

September 2011

Review of SQL Sentry's Free Plan Explorer

Plan Explorer is so chock–full of features that it’s hard to know where to start...Plan Explorer’s usability features are efficient and easy to use," says Kevin Kline, Director of Engineering Services at SQL Sentry.

August 2011

Why I Went With SQL Sentry

"One of the greatest advantages you can have as a DBA is setting up a fully featured monitoring solution...Each one of these products (Performance Advisor, Event Manager, and Plan Explorer) on its own are great, but when you put them all together, it’s beyond awesome. It let’s you do more than just react to problems on your SQL Server, it let’s you get ahead of them" says Shannon Lowder, Database Engineer

August 2011

SQL Sentry Plan Explorer : New release and an SSMS add-in

Today we released a new build of SQL Sentry Plan Explorer. The build # is 6.2.34 and you can download it from the usual location. The updates in this release include a new "Check for Updates" feature accessible via the Help menu, other new additions to the Help menu, plan diagram tooltips which now indicate whether the operation is ordered and a new theme in place for all grids which is more consistent in both appearance and functionality with the grids in Event Manager / Performance Advisor.

July 2011

SQL Sentry talks with RunAs Radio about the Performance Challenges with Analysis Services

Richard Campbell and Greg Hughes with RunAs Radio, a weekly Internet Audio Talk Show for IT Professionals working with Microsoft products, speak with our own Steve Wright about the performance challenges with Analysis Services.

July 2011

An In-depth Analysis of SQL Sentry's Overhead

One of my first major projects at SQL Sentry was framed shortly after I joined the company: to publish an analysis of the overhead that Performance Advisor and Event Manager place on both the server(s) being monitored and on the server(s) doing the monitoring. Every vendor wants to sell you on the "zero impact" and "no footprint" lines, but we all know that it is not possible for you to accurately measure performance on a server without also causing at least some performance degradation by virtue of performing said monitoring. So what does "zero impact" really mean in those cases?

April 2011

SQL Sentry v6.1: Something Old, Several Things New

Since releasing v6 a couple of months ago, we've been hard at work on some cool new features for v6.1. Our x.1 releases are usually comprised mostly of fixes for bugs not caught during the major release (x.0) beta, and a few new features. This x.1 release is different in that contains many exciting and high impact new features, and a higher feature:fix ratio than normal. This is likely due to the lengthy v6 beta, as well as some new QA processes we've put in place.

February 2011

Five Favorite Free SQL Server Downloads

"SQL Sentry Plan Explorer opens execution plans and gives you much better visibility into the real problem...Once the bad plan is open in Plan Explorer, just right-click on it and the fun starts. When I’m tuning a server with slow IO, I can show the costs by IO only, not CPU – a big timesaver for me," says Brent Ozar, Founder/Owner, Brent Ozar PLF and SQL Server MVP.

February 2011

eNews, Announcing the Release of SQL Sentry Version 6.0

The official release of SQL Sentry Version 6.0 occurred on Feb 14, 2011. We think you'll agree that Version 6 takes Query Plan Analysis and Performance Monitoring to a NEW level. Listed below are several of the new and exciting features.

February 2011

The results are in: What Tech Companies Are Doing it Right?

From a community poll at www.MidnightDBA.com, which SQL (or SQL-adjacent) tech companies are doing right, either by product, by promotions, or by people? ... in first place stands SQL Sentry, at 24% of the votes.

February 2011

Vendors Doing It Right: SQL Sentry

"I talk about SQL Sentry a lot. I don’t get paid to talk about them but I did get free lunch from them once at a Product Advisory Council meeting and I did sit at the Product Advisory Council meeting (that I paid my own travel costs for). Those are my disclaimers. If I didn’t like the product I wouldn’t want to sit on their Product Advisory Council," says Mike Walsh, StraightPath Solutions.

February 2011

SQL Sentry Announces Exclusive Master Immersion Training Sponsorship

SQL Sentry announces their exclusive sponsorship of the first two SQLskills Master Immersion Training events. SQLskills.com, run by renowned experts Paul Randal and Kimberly Tripp, is the premier provider of approved training for the SQL Server Microsoft Certified Master (MCM) exam, and has been deeply involved with the re-architecting of the overall MCM certification throughout 2010.

February 2011

Making Use of Plan Explorer in my own Environment

"Today I had the opportunity to work with a vendor of mine on a performance problem and during the investigation of the problems, I identified a query that if rewritten a different way, without any index changes impact to the SQL Server was significantly lower. To show this to the vendor I got on a WebEx session and shared my desktop with the vendors developers and executed their original query and my rewritten version of the query to show that my version output the same result and had significantly less impact to the server than their original one did," says Jonathan Kehayias, Senior Consultant at SQLskills.

November 2010

More Intuitive Tool for Reading SQL Server Execution Plans

"Anyone responsible for performance tuning or troubleshooting should be familiar with the graphical execution plan feature of SQL Server Management Studio. This allows you to visually display the execution plan for a particular query (or multiple plans in a batch). There are weaknesses in this feature, however...SQL Sentry Plan Explorer is a no-risk, no-strings-attached alternative to the graphical plans we've been saddled with for the last decade," says Aaron Bertrand, SQL Server MVP.

November 2010

FREE SQL Sentry Plan Explorer Launched at PASS Summit 2010

SQL Sentry announces the availability of SQL Sentry Plan Explorer - a FREE software tool that greatly improves how you work with SQL Server Query plans. Plan Explorer builds upon the graphical plan view in SQL Server Management Studio (SSMS) to make query plan analysis more efficient. It contains many of the plan analysis features being introduced in SQL Sentry v6, but it does not require a collection service or database.

November 2010

SQL Sentry Performance Advisor Named Winner "Best Of Connections 2010" By DevConnections

"We are honored to have Performance Advisor recognized as the 'Best SQL Server Product' by DevConnections," said Greg Gonzalez, President and CEO of SQL Sentry. "Since the product was first introduced in 2008, we've continued to release new product capabilities with the goal of providing the best performance tool for Microsoft SQL Server."

October 2010

eNews, SQL Sentry Plan Explorer Beta and Aaron Bertrand Joins the Team

We recently published the Beta release of a new software tool that will greatly improve how you work with SQL Server Query plans. As we were building this tool, we saw how it could help the entire SQL Server community, so we are pleased to make it available for FREE! And we're proud to announce that Aaron Bertrand has joined the SQL Sentry team as Senior Consultant. Honored by Microsoft as a Microsoft Most Valuable Professional (MVP) since 1997, Aaron has over 10 years of technical experience with Microsoft SQL Server.

October 2010

SQL Sentry Announces Aaron Bertrand as Senior Consultant

We're proud to announce that Aaron Bertrand has joined the SQL Sentry team as Senior Consultant. Honored by Microsoft as a Microsoft Most Valuable Professional (MVP) since 1997, Aaron has over 10 years of technical experience with Microsoft SQL Server. His responsibilities include development of SQL Sentry consulting services; interacting with clients; and driving new product initiatives.

August 2010

eNews, SQLCruise Recap and Fall Conference Schedule

SQL Sentry prides itself in being a strong supporter of educational events for the SQL Server community world-wide. We recently sent four "happy cruisers" on the inaugural sailing of SQLCruise. Check out what some of them had to say about the value of this unique venue and approach. Also, note our fall conference schedule: SQLBits 7 – The Seven Wonders of SQL, SQL Server Connections, and PASS Summit 2010. If you attend any of these upcoming events, make sure to visit SQL Sentry's booth to see the latest version of Event Manager and Performance Advisor - the ultimate performance solution.

July 2010

Which SQL Server Tools?

"I use SQL Sentry for a few things," says Mike Walsh, StraightPath Solutions. "First, to quickly see performance alerts/issues (Performance Advisor). Second, to view the status of all jobs, report server reports, maintenance plans, etc. in the calendar view (Event Manager). Third, to help prioritize which servers need my help the fastest (if the trending in the PA dashboard looks bad,or I see a lot of errors/TOP SQL/Blocking SQL in the calendar the instance gets prioritized). Fourth, I get lonely - I like the servers to talk to me and tell me how they are doing. If a job takes longer than it has every other execution or less time than normal there may be an issue and I want to know. I want to know (at first anyway) about every time long blocks happen or queries over an hour. I want to know when a job fails. The tool does that."

June 2010

SSMS : Which parts do you love? Which parts do you hate?

"I get more complete and consumable information, and more immediately, from SQL Sentry's Event Manager - which also has the ability to store more history in the repository without bogging down production instances of msdb... If I want a good look at what is going on in my server, I will use SQL Sentry's Performance Advisor - which does a great job of warning me about issues even when I'm not paying attention," says Aaron Bertrand, SQL Server MVP.

June 2010

eNews, SQL Sentry Version 5.5 and SQLCruise Update

SQL Sentry version 5.5 was officially released on May 21, 2010. We think you’ll be excited about many of the new features for both Performance Advisor and Event Manager, which include several of the most heavily requested enterprise features. SQL Sentry recently announced four winners of "Why I need to go on the SQLCruise" contest. The submissions were shared via the entrant’s favorite social media outlet.

June 2010

SQL Sentry Truth-Telling and Disk Configuration

"When I took over as DBA, I inherited a SQL 2000 server with about 30 databases on it supporting our main systems, and a SQL 2005 server with multiple instances...Then one day, I’m poking around inside SQL Sentry Performance Advisor...I was stunned...Here was something that I thought was such a basic truth that was turned upside down," says Mark Caldwell, Professional IT Solutions Provider.

May 2010

SQL Sentry Announces SQLCruise Sponsorship

"The SQLCruise 2010 is a unique opportunity to receive technical training from noted SQL Server experts in a comfortable, refreshing environment. A small group of students, exploring in-depth advanced technical topics and closely interacting with their instructors, all while enjoying the world-class accommodations of the Carnival Imagination, what could be better," said Tim Ford, Microsoft SQL Server MVP and SQLCruise Trainer. "We are thrilled to have the support of SQL Sentry as their first-class products and their knowledgeable staff make a valuable difference in the SQL Server community every day."

May 2010

SQL Sentry First Impressions

"After struggling to defend my SQL Servers from a political attack recently, I realized that I needed better tools to back me up, and SQL Sentry is the leading candidate...Great Support...Chaining and Queueing...Calendar View...Performance Advisor Dashboard History View...Reporting Services Subscription Jobs with Report Name...The combination of Event Manager and Performance Advisor working together have really made me a fan," says Mark Caldwell, Professional IT Solutions Provider.

April 2010

SQL Sentry 5.5 And Letting Reports Save You

"I downloaded their (SQL Sentry's) new version 5.5 when it was in Beta and I have loved their reports, even saved my bacon a couple of times... As fun as it is when first starting out to build your own reports and monitoring processes, there is something nice about having everything you need a few clicks away," say Mike Walsh, StraightPath Solutions.

February 2010

eNews, SQLSaturday in Charlotte, and SQL Sentry on Twitter!

SQL Sentry is pleased to be a Platinum Sponsor for the upcoming SQLSaturday #33 in Charlotte, NC! Featuring 9 tracks and 54 sessions, there hasn't been a SQL Server event like this on the East Coast in over 5 years, and never in the Carolinas! SQL Sentry recently launched our official Twitter account, twitter.com/SQL_Sentry, and Greg Gonzalez, President and CEO, launched his account, twitter.com/SQLsensei.

February 2010

Performance Advisor for Analysis Services...is hands down the best SSAS monitoring tool available

"Well, as with most things in SSAS, its not AS EASY when compared to the server's relational sibling. I begin with the easiest approach: tools. There are a few available tools that one can use to view and manage SSAS activity. First and foremost is that of SQLSentry's Performance Advisor for Analysis Services. This tool is hands down the best SSAS monitoring tool available. SQLSentry clearly filled a large void in the SSAS world," says Derek Comingore, SQL Server MVP, B.I. Voyage.

December 2009

eNews, Performance Advisor for Analysis Services Wins 2009 Editors' Best Award

On November 19, 2009, SQL Sentry Performance Advisor for Analysis Services was named the 2009 Editors’ Best Database Monitoring and Performance Product by SQL Server Magazine. We're honored to not only receive the award but to receive it within six months of the product launch. A special thanks to all that have supported the launch of Performance Advisor for Analysis Services through your insight and feedback.

November 2009

SQL Sentry Performance Advisor for Analysis Services Named 2009 Editors’ Best Award Winner

"We are honored to have Performance Advisor for Analysis Services recognized so quickly by the editorial experts of these industry leading publications," said Greg Gonzalez, President and CEO of SQL Sentry. "Since the launch of this product less than six months ago, we’ve received many accolades from customers and industry experts for delivering new capabilities to manage and tune Microsoft SQL Server Analysis Services."

October 2009

eNews, Still Challenged by Reporting Services

As more and more companies are deploying this functionality, there is an increase in the desire for information on how to best implement Reporting Services for their specific needs... SQL Sentry Event Manager provides complete scheduling, monitoring and notification features for SQL Server Reporting Services. This enables a DBA to view all Reporting Services events on the Event Manager calendar, monitor their impact on performance and set notifications, ensuring awareness of any issue.

September 2009

eNews, See SQL Sentry at SSWUG's Ultimate Virtual Conference

As a special incentive, come and visit SQL Sentry in the Exhibitor Hall, and we'll enter you into a drawing to win your choice of (1) Power Suite for SQL Server ($2,394 value) OR (1) Performance Advisor for Analysis Services ($2,994 value). The prize includes the license cost and first year annual software maintenance. Our virtual booth will have current demos available for all products and we'll be available to answer any questions.

July 2009

SQL Sentry Announces Performance Optimization Software for SQL Server Analysis Services

SQL Sentry Performance Advisor for Analysis Services provides unparalleled insight into Analysis Services performance, including bottlenecks related to memory and storage systems, aggregation usage, unoptimized queries, and query and processing tasks competing for the same resources. And when combined with SQL Sentry Performance Advisor for SQL Server and Event Manager, provides the only solution in the market covering Microsoft’s entire BI platform, including the relational data warehouse (SQL Server), Analysis Services (SSAS), Integration Services (SSIS), and Reporting Services (SSRS).

July 2009

eNews, Introducing SQL Sentry Performance Advisor for Analysis Services

Building on the success of the award-winning SQL Sentry Event Manager and Performance Advisor for SQL Server, we are proud to announce another industry first – performance monitoring and optimization software for Microsoft SQL Server Analysis Services (SSAS).

April 2009

SQL Sentry Introduces First Analysis Services Monitoring Solution

"I’m currently in Germany at the PASS European Conference....for the last few months I’ve also been talking to the guys at SQL Sentry – who are also here exhibiting – about their new product called Performance Advisor for Analysis Services which has just been made public. I’ve had an in-depth demo and my first impression is that this is the first Analysis Services monitoring solution that I would actually want to use; it looks really, really good. I believe SQL Sentry has the first solution that will monitor the SQL Server relational engine, Analysis Services, SSIS and SSRS as well," says Chris Webb, IT Consultant, UK.

March 2009

Monitoring Your Servers: Data Collection vs. Performance Advisor

"In SQL Server 2008 we get Data Collection, a built-in framework for collecting and analyzing performance and other metrics from multiple servers...I thought it would be useful to compare some of the features with a 3rd party tool that I use in my environment, Performance Advisor from SQL Sentry....Performance Advisor goes above and beyond in the disk usage report category, providing disk capacity statistics like Data Collection does, and adding real-time disk activity views that show exactly where the I/Os are coming and going," says Aaron Bertrand, SQL Server MVP.

March 2009

eNews, Complete Deadlock Analysis

SQL Sentry Performance Advisor provides complete details on any deadlock that occurs on your SQL Server 2005 and 2008 instances in one view with no additional configuration required! Instead of hours of research and effort assembling bits and pieces of the problem, instantly get all the details with a single click.

January 2009

Are You Using Your 3rd Party Tools?

"There are a number of reasons why I like Performance Advisor, the cool dashboard, the ease of being able to see the history and change back to what is going on right now, and the ability to see if you have a bottle neck on your disk drives. I thought that I knew all there was to know about the tool. Then I discovered the Quick Trace...I have to admit that Quick Trace is now my favorite part of Performance Advisor," says Chris Shaw, SQLonCall.

October 2008

So, What WAS That Tool?

"I wrote about some performance issues we were chasing. The issues were revolving around a symptom of disk queues growing, system performance lagging in spurts, etc. The folks over at SQL Sentry jumped on that and helped us out - they helped show off their new performance dashboard and at the same time shine some serious light on our server and the issues we were seeing," says Stephen Wynkoop, SQL Server Worldwide User Group.

July 2008

Performance Advisor: A Quick "Two Thumbs Up"

"I have been playing with Performance Advisor, the new companion to the very popular Event Manager software from SQL Sentry. Right off the bat, I can tell you that this tool should have [the competition] shaking in their boots, as it is really going to give them a run for their money. While a late comer to this segment of the market, Performance Advisor has definitely been worth the wait," says Aaron Bertrand, SQL Server MVP.

June 2008

SQL Sentry Announces New Performance Monitoring and Optimization Tool

SQL Sentry Performance Advisor is packed with many ground-breaking features, not found in any other software, all designed to simplify the process of optimizing SQL Server performance. Performance Advisor represents over two years of research and development by the same team that brought you the innovative, award-winning SQL Sentry Event Manager.

May 2008

SQL Sentry "Best Of Tech•Ed 2008 IT Professional Awards Finalist"

SQL Sentry Event Manager was named as a finalist of the "Best of Tech•Ed 2008 IT Professional Awards" in the Database Administration category by Penton Media’s Windows IT Pro® and SQL Server Magazine®. The Best of Tech•Ed 2008 Awards recognize companies who offer innovative products in the industry. The judges reviewed over 220 products and services submitted for the contest and chose 29 finalists.

March 2008

Manage SQL Databases

"The larger and more complex your infrastructure, the more you need to be concerned with maintenance and operational tasks interfering with each other. This can lead to process flow havoc for your end users. Fortunately, there are a few tools available for the database and system administrator to help coordinate a complex environment's schedules. One tool that you may want to consider is SQL Sentry Event Manager," says Greg Steen, TechNet Magazine.

December 2007

SQL Sentry Event Manager Product Review

"As a DBA in today's 24x7 world, managing multiple SQL Servers can be quite a challenge. Having an arsenal of tools by your side that can help you save time is a must. Fortunately, a tool is available on the market to help take some of the stress out of your life. SQL Sentry Event Manager provides you with a tool that enables you to manage all of your SQL Server jobs across your entire infrastructure from one single point of entry," says Steve Warren, Database Journal.

September 2007

Pragmatic Works Joins SQL Sentry Partner Program

"SQL Sentry Event Manager is the one tool that can really change an organization and simplify the DBA’s daily life. If you're concerned about the bottom-line support costs of your servers, this is a must-have tool," said Brian Knight, Founder and Managing Partner of Pragmatic Works. "You'll never know how you lived without Event Manager. It's truly a required tool in the effective DBA's arsenal."

September 2007

Professional Association for SQL Server Selects SQL Sentry Event Manager

"The growth of our organization’s membership and several new technology initiatives have placed large demands on our underlying enterprise. SQL Sentry Event Manager allows our DBA team at MaximumASP to see, understand and manage SQL Server more efficiently than the native tools" said Rushabh Mehta, Director of Technology for PASS.

September 2007

Know What's Happening: Keep Tabs on your SQL Server Jobs

"We've all been in situations where we spend a great deal of time navigating the complicated Web of inter-server SQL Agent jobs to find resource contention and scheduling problems. When you add the layer of complexity that many SQL Agent jobs simply run DTS or SSIS packages, the problem becomes even greater. One of the few third-party devices available to help with this task is SQL Sentry Event Manager," says Joshua Jones, Redmond Magazine.

July 2007

SharePointHosting.com Leads with SQL Sentry Event Manager

Leading Microsoft SharePoint Host Leverages Event Manager to Optimize SQL Server. "SQL Sentry Event Manager allows our DBA team to monitor and maintain SQL Server in a fraction of the usual time and focus on the more strategic tasks of balancing our dynamic growth while keeping our recognized quality of service standards high," said Larry Strange, CEO of SharePointHosting.com.

July 2007

SQL Sentry Event Manager Earns Platinum Award, SQL Server Magazine

SQL Sentry Event Manager earns platinum award in the Database Management Tools category. "The 2007 Editor’s Choice Awards utilize our editors' product knowledge and subject matter expertise to identify exceptional products that have been covered in the pages of SQL Server Magazine and its online newsletters, and which benefit the SQL Server Magazine reader community," said Kim Paulsen, group publisher.

July 2007

MaximumASP Raises the Bar on SQL Server Hosting with SQL Sentry Event Manager

"Before Event Manager, we used the burdensome process of specialized scripts and manual documentation to manage our job schedules. We also tried a collection of different third-party products, but nothing exhibited a true understanding of what DBAs really need. I can't imagine going back to the old methods or using some of the less comprehensive competing products in an attempt to tackle the same problems," says Sarah Barela, DM Review Magazine.

May 2007

SQL Sentry Announces Competitive Upgrade Promotion

Database administrators can trade in any job scheduling, alerting or automation software tool and receive SQL Sentry Event Manager for free. "This is an opportunity for organizations to upgrade from tools that may no longer be satisfying their needs, to the award winning and proven power of SQL Sentry Event Manager." said Nick Harshbarger, Director of Sales and Marketing at SQL Sentry.

April 2007

SQL Sentry Announces New Partner in South Africa

"SQL Sentry Event Manager enables our clients to maximize the return on their investment in SQL Server and Oracle," said Dereck Ramsay, Managing Director of Irridium. "Event Manager allows their DBAs to strategically manage their job schedules in a fraction of the time that the native tools require. Plus Event Manager enables them to better schedule, manage and monitor their critical backups."

April 2007

Save Time (and Money) With SQL Sentry Event Manager

"As a DBA, the first thing you do in your database environment is check the jobs that ran the previous day. Just imagine the trouble this can cause in multi-server environments. Things become frustrating when your servers are located around the globe. From the (Event Manager) calendar view, you can visualize all the jobs on all the servers in your enterprise at once, which helps you uncover conflicts. I highly recommend Event Manager," says Dinesh Asanka, SQL Server Performance.com

March 2007

Event Manager for SQL Server Product Review

"You could think of Event Manager for SQL Server as SQL Agent on steroids, but its functionally actually goes far beyond SQL Agent. One of SQL Sentry's most valuable features for the DBA is the all-devices global calendar view, which gives you a big picture of your enterprise job execution schedule. Event Manager is a must-have product for DBAs who need to manage a large number of jobs across multiple systems," says Michael Otey, SQL Server Magazine

January 2007

Event Manager, SQL Server Performance and Tuning ‘Product of the Year’

"The product's display is the key to its success," according to SearchSQLServer.com. "Its customizable interface allows simultaneous display of calendars, graphs and controls to fit the users' needs. In a large enterprise SQL Server quickly becomes difficult to manage -- especially the SQL Server jobs. Event Manager is indispensable for managing jobs and for providing alerting."

December 2006

SQL Sentry Enables Remote DBA Services

SQL on Call delivers DBA expertise to remote clients using SQL Sentry Event Manager.

November 2006

SQL Sentry Event Manager Adds Support for Oracle

SQL Sentry, Inc., the developer of award-winning management solutions for Microsoft SQL Server, announced today the availability of SQL Sentry Event Manager for Oracle. Selected as the 2006 SQL Server Magazine Editors’ Choice for Database Management, SQL Sentry Event Manager allows Database Administrators (DBA) to efficiently manage SQL Server, Windows Task Scheduler and now Oracle in today’s increasingly complex environments.

October 2006

SQL Sentry Announces New European Union Partners

Skilled Software based in Poland and BTSoftware based in the Netherlands will represent SQL Sentry to clients throughout the European Union.

September 2006

MaximumASP Leads with SQL Sentry Promotion

MaximumASP, a leading provider of Microsoft Windows-based hosting, is making a special offer on SQL Sentry to their dedicated server clients.

September 2006

SQL Sentry Expands with New Partners in New Zealand and Hong Kong

eGlobal, based in New Zealand and Idynamic Media based in Hong Kong will represent SQL Sentry to their clients and respective regions.

July 2006

SQL Sentry Named 2006 Editors’ Choice for Database Management

SQL Sentry honored as a Gold Winner in the Database Management category of the 2006 SQL Server Magazine Editors’ Choice Awards.

July 2006

MaximumASP Teams with SQL Sentry

MaximumASP, a leading provider of Microsoft Windows-based hosting, has joined the SQL Sentry Hosting Partner Program.

July 2006

MFG.com Buys Time with SQL Sentry

SQL Sentry immediately allows MGF.com to see multiple SQL Server job schedules and interactions on multiple systems, giving a clear picture of the timing and sequencing involved in the overnight processing and data transfer.

June 2006

SQL Sentry Standard Edition Releases

SQL Sentry Standard Edition Delivers Award-winning Functionality to SQL Server DBAs within Small- to Medium-Sized Organizations.

June 2006

SQL Sentry v2.7 Earns High Honor

Brad McGehee, SQL Server Expert, reviews new version and honors SQL Sentry as “Recommended by SQL-Server-Performance.com.

June 2006

Power, Productivity, and Performance

SQL Sentry is an enterprise-level SQL Server job automation/scheduling and monitoring tool that makes it easy to manage and monitor SQL Server jobs and Windows Task Scheduler events, from a single console. Take an in-depth look at how well SQL Sentry meets its stated goals.

May 2006

SQL Sentry Rewards Those with Busy Schedules

Participants submitted screenshots showing their SQL Server schedules for potential selection as the busiest SQL Server schedule.

April 2006

SQL Server Performance Optimization

SQL Sentry is one tool that you really need to try out - put it through its paces on your servers. See what it exposes and see the time it can save you by helping fine tune your scheduling and server management.

March 2006

Hidden Jobs, Hidden Schedules and the Impact on your Server

Take a look at the real-world impact of your SQL Server Agent job subsystem and the not-so-obvious loads it can place on your system.

March 2006

SQL Sentry Relieves Your SQL Server Job Headaches

SQL Sentry is a tool that can help alleviate you of the headache associated with managing multiple SQL Server jobs on multiple SQL Servers. The benefit of a powerful job-monitoring tool for SQL Server is enormous.

January 2006

Interview with Brooke Philpott of SQL Sentry

"I had a chance to meet Brooke Philpott, the lead developer of sqlSentry, at TechEd 2005 in Orlando this year and discuss a few technical points about the product. It's always interesting to hear about the development of a product, so we decided to continue the discussion via email and with Brooke's permission, the result has been written up in an interview format," says Andy Warren, SQLServerCentral.com

January 2006

A Review of SQL Sentry v2.5

"In early December, InterCerve released sqlSentry 2.5. Amongst other things, the tool is primarily known for giving the DBA an easy way to manage his or her production jobs. It also has a very robust job alerting system. sqlSentry 2.5 is unlike any tool on the market for the SQL Server DBA and I could not find a competitor. I can not think of any way for a DBA to save more time than with a job management system like sqlSentry," says Brian Knight, SQLServerCentral.com

January 2006

64-bit SQL Sentry Enhances Performance & Scalability of SQL Server

New 64-bit version of SQL Sentry releases for SQL Server 2005, supporting both x64 and Itanium based systems.

September 2005

SQL Sentry Announces New Vice President of Sales and Marketing

Nick Harshbarger brings sales and marketing experience to rapidly growing SQL Server management application company.

August 2005

SQL Sentry Wins Two SQL Server Magazine Readers' Choice Awards

Readers Honor SQL Sentry as the Best Job Automation and Scheduling Tool and Best Alerting/Notification Software

August 2005

Administrative Tools Keep SQL Server Running Smoothly

SqlSentry's alerting capability lets DBAs eliminate SQL Mail, receive more-detailed messages, and even vary responses by condition. The tool also offers graph and chart reporting of performance statistics and information about possible conflicts. sqlSentry does it again in job automation, this time winning by a 500 percent margin over its next-closest competitor. sqlSentry lets users schedule jobs efficiently through its Outlook-style calendar view of the job scheduler, then use Windows performance counters to monitor the jobs as they run. One voter called sqlSentry the "best on the market."

June 2005

SQL Sentry Supports Microsoft SQL Server 2005

New Version 2.5 Integrates with SQL Server 2005 to Support the Most Complex and Voluminous Environments.

February 2005

SQL Server Job Performance Checklist

Virtually every SQL Server runs one or more daily jobs. And most likely, runs many weekly jobs. Unfortunately, most DBAs set up jobs, and then forget about them, unless of course they break. But if they run day after day without any problems, most jobs are forgotten about.