Quest shows off Change Director to TechEd 2007 attendees
I spoke with Quest Software during TechEd this month for a briefing on Change Director, Performance Analysis, and the latest release of Toad. I reviewed Change Director as part of the judging for Best of TechEd. Change Director for SQL Server gives DBAs an integrated tool to control and track most changes within the database. Change Director supports real-time or scheduled database changes, and includes change monitoring and reporting capabilities for unscheduled (or unauthorized) changes as well as planned changes. However, if someone initiates a change outside of Change Director and the server is registered with Change Director, the software will also track changes and log who made the change. Another useful feature allows the DBA to perform an impact analysis on a target database before actually deploying the changes to the target database. This analysis provides a report listing all the SQL calls in the script and flags ones that may potentially fail on the target database. From this point, you can actually drill down into the code to see what’s going with this change. Change Director also flags transactions in the SQL logs identifying them with a particular transaction, allowing for recovery at the transaction level regardless of what order the transactions were written to the log. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />
The product we discussed in depth is Performance Analysis for SQL Server. This deep-dive analysis tool sports a new advisory engine offering both real-time and historical monitoring and problem resolution features. The IntelliProfile™ software included with the package learns the database’s signature behavior for the hour of the day, day of the week, etc. to determine acceptable/normal ranges of activity so you can compare current to normal behavior in your particular environment. A dashboard interface highlights deviations from the baseline and then allows you to drill down into the problem and view suggested advice for improving the problem. Since your organization is unique to any other, being able to define normal for your organization is a distinguishing feature of this software. This software has a very broad feature set that allows the DBA to really monitor across the database and application environment.
The final product we covered is the Quest Management Suite for SQL Server. This is actually a bundle of four products in the Quest product line, Capacity Manager, SQL Watch, LiteSpeed and Spotlight on SQL Server. Capacity Manager solves the problems associated with managing disk space and server resources. SQL Watch identifies, tracks and notifies SQL Server administrators of database changes that occur at any given time. The features of SQL Watch seem very similar to the Change Director product. Quest confirmed this and said that new releases of Change Director will include all the current functionality of SQL Watch. The other product in the suite is the familiar LiteSpeed for high performance compression software. The final product in the suite is Spotlight that monitors performance from the disk to the end user and supports problem resolution by providing an interface to identify the problem and then enables a drill-down feature for viewing the low lever processes causing the performance issue. The Spotlight software is designed to feed a database repository of all the alerts issued out of this suite of products.
I also learned LiteSpeed is being used for recovery in SharePoint and a LiteSpeed beta is actually running in production area of Microsoft that have gone live with Longhorn.
Quest has a very diverse set of products with all the development and acquisitions they’ve done in the last few years. So asked about plans to start integrating these different tool sets to provide more holistic management tools. They said they’re actually working on providing a common protocols that can be imbedded to share data between applications and having a shared data repository.