Sql Power Tools Releases the Sql Agent Job Baseline Performance Monitor
Cheyenne, Wyoming - - Sql Power Tools (SPT), the world leader in Zero Impact database monitoring, today announced the release of the Sql Agent Job Baseline Performance Monitor.
Offers early warning of SQL Agent jobs in the server farm that begin to run longer than prior baseline periods. Automatically alerts you to jobs and job steps that run X % longer than prior baseline time periods.
View all in progress SQL Agent jobs in your server farm from your web browser. View job and job step historical performance for any subset of the server farm over any prior time period. Be alerted to short and long running jobs plus job failures, cancels and retrys. End of report summarizes job baseline performance issues, failures, cancels and retrys. Product automatically alerts you to server farm jobs and job steps that run 30% longer than their average run time.
Key benefits and features:
• End of day Baseline Analysis provides early warning of jobs and job steps in the server farm that begin to run longer than prior baseline periods. Any number of baseline periods may be defined.
• Ad hoc Baseline Analysis allows job and job step run times to be compared between servers and time periods.
• Server Farm Tree view of all in progress job steps and job alerts.
• Automatically alerts you to jobs that run 30% longer than their average run time. Job and job step alerts are displayed in real-time in the web browser Server Farm Tree, may be emailed, reviewed at any time from the repository history and are summarized in an emailed end of day report.
• Be alerted to short running jobs/job steps and long running jobs/job steps; plus job failures, cancels and retries.
• Automatically calculates minimum and maximum run time alert thresholds for jobs and job steps from the job history in the repository.
• Graphically view in progress jobs for any subset of the server farm, jobs and job steps over any time period.
• Graphically view historical job and job step run times, failures, cancels and retries for any subset of the server farm, jobs and job steps over any time period.
• End of day report is emailed that summarizes jobs and job steps in the server farm that begin to run longer than prior baseline periods. Job failures, cancels and retries are also reported.
• Automatically pushes server farm job and job step history into a database repository for server farm baseline analysis and historical review from 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.
Sql Power Tools awarded Best Database Monitoring and Performance Product Community Choice Gold by SQL Server Magazine 2009. 
After years as a DBA, I can tell you there is absolutely nothing on the market that compares to the Zero Impact Sql Monitor product line...it is the best performance investment you will ever make.
