Sql Power Tools Releases the Zero Impact Baseline Analysis Monitor -- A Predictive Solution for Early Warning of Microsoft SQL Server Performance Slowdowns
New product offers early warning of deteriorating performance in Microsoft SQL Server database server farms. Allows trending performance issues to be identified and corrected before the database operations are impacted. A free trial version is immediately available for download.
Cheyenne, Wyoming - - Sql Power Tools (SPT), the world leader in Zero Impact database monitoring, today announced the release of the Zero Impact Baseline Analysis Monitor, a new predictive database monitor for early warning of deteriorating performance in Microsoft SQL Server database server farms.
PDM can also compare the performance of any database server to another and is an invaluable tool for database migrations such as Microsoft SQL Server 2000 and Microsoft SQL Server 2005 to Microsoft SQL Server 2008.
Featuring a 100% web-enabled console with 3D views of database server farm health, the PDM analyzes performance trends and deviations from historical baselines to identify which performance metrics and SQL statements are deteriorating from a prior rolling time period or historical baseline. With powerful built-in reporting, users receive a daily report of the SQL statements and performance counters that exhibited deteriorating performance for the server farm.
“We are extremely excited about the release of the PDM in the marketplace. Sql Power Tools will alert DBA’s to deteriorating database server farm performance prior to end-users experiencing it!” said Randall Reiter, CEO,
Sql Power Tools. “PDM pushes the envelope in early warning of database server farm performance issues."
Key benefits and features:
Ability to identify for every database server in the server farm:
• Servers that are having deteriorating performance. E.g. a trending percentage increase in performance metrics such as CPU usage, disk I/O, table scans, blocking, deadlocks, lock waits, disk space and more.
• The 25 SQL statements out of the 4,000 unique SQL statements running on a database server that have a trending percentage increase in end-user response time when compared to yesterday, the prior rolling week, the prior rolling month or a historical baseline.
• The Windows performance counters and SQL statements that have a poorer performance percentage than the prior business day, week, month, quarter or year.
• 100% web-enabled console with 3D views of database server farm health, performance trends and deviations in performance from historical baselines. One picture tells it all.
• Compares the performance counters and 100% SQL performanceof database servers in the server farm over any time period.
• Microsoft SQL Server 2008 migration tool. Compares the performance counters and 100% of the SQL performance for any Microsoft SQL Server 2000 or Microsoft SQL Server 2005 server to Microsoft SQL Server 2008.
• Supports server farm capacity planning activities.
• Emails a daily report of the specific 4,000 SQL statements and Windows performance counters in the server farm that exhibited deteriorating performance. Allows hundreds of database servers to be monitored with minimal staff resources. Reported server farm performance issues may be immediately viewed in 3D in a web browser.
Powered by the Zero Impact Enterprise Monitor
The Zero Impact Enterprise Monitor non-intrusively captures 100% of the SQL activity 24x7. No intrusive server profiles or traces that degrade server performance by 30% to 60% are used. When a performance counter such as CPU usage, disk usage, SQL table scans or lock waits occur; the exact SQL that ran may be immediately viewed from a web browser. Note: 80% of most performance issues are due to SQL rather than the server configuration.
Pricing and Availability
PDM is now available for Microsoft SQL Server and will be released shortly for other database technologies. Introductory pricing begins at $1,200 per monitored database server instance. Free trial version is available at www.sqlpower.com.
About Sql Power Tools
Sql Power Tools, the world leader in Zero Impact database monitoring, provides innovative software solutions for data monitoring and performance tuning. Privately held, Sql Power Tools is based in Cheyenne, Wyoming. For more information please visit http:///www.sqlpower.com, or call (307) 433-8039.
Copyright (c) 2008 Sql Power Tools, Inc. All rights reserved.