Product Overview
Screenshots for 100% Web Enabled User Interface plus Mobile App - Best viewed with a screen resolution of 1280 x 1024 or higher.
Big Picture View of Server Performance
Big Picture View of Server Performance of SQL
Rolling view of the last one to twelve hours of SQL performance delivered by a database server to end-users. The average end-user response time is summarized every 20, 30, 60 or N seconds. Know immediately when the average end-user response time begins to degrade for the 3,000 users connected to a database server. The lower 3D pie chart is a display of the distribution of client SQL end-user response time since midnight. Product user interface is 100% web enabled for all industry web browsers, mobile phones and mobile tablets. The SQL performance can be saved to an Informix or SQL Server repository and reviewed at any time from a mobile phone, mobile tablet or work station web browser.
Zero Impact SQL Capture
Zero Impact SQL Capture Agent (a Zero Impact SQL Trace)
Capture the performance of every client SQL request with Sql Power Tools Zero Impact Sql Capture Agent. Think of it as a ZERO impact SQL trace facility. Takes a few minutes to install. The Agent never connects to the monitored database instance and has a low 1% overhead. Captures 100% (or any subset) of the SQL activity (with the end-user response time, SQL text and bind parameters, SQL errors) with no impact on the monitored database instance. Identifies all long running SQL within a few milli seconds of its occurrence. Real-time email alerts can be sent for long running SQL; or when a database instance delivers a poor average end-user response time. E.g. when any client SQL runs longer than 100 milli seconds or when average end-user response time being delivered exceeds 250 milli seconds. Product user interface is 100% web enabled for all industry web browsers and mobile devices. Be informed on a mobile phone, mobile tablet or work station web browser within milli seconds of when client SQL runs longer than N seconds (e.g. 150 milli seconds for important applications). The SQL activity can be saved to an Informix or SQL Server repository and reviewed at any time from a mobile phone, mobile tablet or work station web browser. Available for AIX, Linux, Solaris and Windows.
Top N Sql Analysis of 100% of SQL activity
Top N Sql Analysis of 100% of SQL Activity Over any Time Period
Comprehensive Top N Sql Analysis of 100% of SQL activity captured by the Zero Impact SQL Capture Agent. Most servers have 10K+ unique client SQL requests that run millions of times over the business day. The performance of every unique SQL request is tracked by its minimum, average and maximum end-user response time. Both the percentage and cumulative percentage of the SQL activity the SQL request represents is reported with the number of times it ran, average rows returned, bytes sent and packets sent. The Top N Sql Analysis identifies the SQL that ran most frequently (% of activity for the server) with its average end-user response time. By default the Top N Sql Analysis is automatically run at the end of the day for a summary of the days SQL performance by unique SQL request. It can also be used to analyze the SQL performance over important time periods of interest. e.g. between 10:00 am and 10:20 am when end-users reported long response times. Or after any important changes are made such as table indexing, SQL coding, new software releases, hardware or configuration changes. Now changes in SQL performance can easily be pinpointed after any change. Typically changes are made to improve SQL performance. SQL applications are quite complex so if any SQL is running slower after a change it can immediately be identified and the issue resolved prior to end-user experiencing degraded response time.
SQL Baseline Performance
SQL Baseline Analysis of Performance both Daily and Over any Time Periods of Interest
Baseline analysis of the SQL performance for the 10K+ unique SQL requests that run on a server is performed daily. Both degraded and improved SQL performance is reported for every unique SQL request. Know the percentage increase/decrease plus actual increase/decrease in end-user response time (in milli seconds) for every unique SQL request. Ad hoc baseline analysis of SQL performance may be performed at any time. E.g. between 11 am and 11:30 am on Tuesday and Friday when end-user response time was poor on Friday and good on Tuesday. Or after any important changes are made such as table indexing, SQL coding, new software releases, hardware or configuration changes. Now changes in SQL performance can easily be pinpointed after any change with the baseline analysis of SQL performance. Typically changes are made to improve SQL performance. SQL applications are quite complex so if any SQL is running slower after a change it can immediately be identified with the SQL Baseline Analysis. The SQL Baseline Analysis results may be reviewed at any time from the product repository.
End-user Experience Response Time
End-user Experience Response Time
View the average end-user response time delivered by the database server to end-users over any time period. Average end-user response time is summarized every 20, 30, 60 or N seconds. The lower 3D pie chart is a summary of the distribution of end-user response time. The daily baseline analysis automatically identifies servers that delivered a degraded average end-user response time. A daily email summarizes the database server having degraded average end-user response time as well as the number of SQL requests having a degraded response time.
SQL Heat Maps on Mobile App
SQL Heat Maps on Mobile App
A SQL response time Heat Map shows the server farm database instances (200+) delivering a poor end-user response time over the last N minutes (also available in web browser user interface). The larger the red area for a server the more client SQL exceeded the end-user response time alert threshold. Yellow areas show servers being within 75% or more of the end-user response time SQL alert threshold. i.e. about to deliver poor end-user response time. Green servers are delivering good performance. Tap once on a database instance in the Heat Map for a popup recap of current SQL performance. Tap twice on a database instance in the Heat Map to graph SQL performance over any time period in the Graphs view. FREE mobile app with every license.
Server Farm Performance Dashboard on Mobile App
Server Farm Performance Dashboard on Mobile App
Server Farm Performance Dashboard summarizes the performance of 100+ servers. From the dashboard tap on a database instance to drill into SQL performance (Graphs view) or SQL having a response time that exceeded the SQL alert threshold (Alerts view). A responsive design allows the mobile app to dynamically adjust to the size of the mobile phone or tablet. View the servers by best or worst performance. Or specify the servers to view and the order they are displayed in the Dashboard.
Graph SQL Response Time on Mobile App
All Graphs Available with Mobile App
Graph a summary of SQL performance for client SQL activity captured by the Zero Impact SQL Capture Agent, current in progress SQL, Top N SQL Analysis results, SQL Baseline Analysis results and the end-user experience (average end-user response time delivered by the server) over any time period. Tap once on a database instance for a popup recap of current SQL performance.
Graph SQL Response Time on Mobile App
Graph SQL Response Time with Mobile Tablet
Eight graphs graph the end-user response time metrics for all client SQL requests along with the average end-user response time delivered by the database instance. Graph performance over any time period. Scroll down to view eight different graph types. Swipe right or left across a graph to move forward or back in time. Tap once on a graph point for a popup recap of SQL performance for the client SQL request. Tap twice on a graph point for a popup display of SQL text, end-user response time, rows returned, bytes sent, packets sent, client IP/port, login id, application, database and SQL errors for the client SQL request. A responsive design allows the mobile app to dynamically adjust to the size of the eight graphs for mobile phones and tablets. e.g. on a tablet the eight graphs are displayed in 2 rows and 4 columns so that all of the graphs may concurrently be viewed.
Graph SQL Response Time on Mobile App
Graph SQL Response Time on Mobile Phone
Eight graphs graph the end-user response time metrics for all client SQL requests along with the average end-user response time delivered by the database instance. Graph performance over any time period. Scroll down to view eight different graph types. Swipe right or left across a graph to move forward or back in time. Tap once on a graph point for a popup recap of SQL performance for the client SQL request. Tap twice on a graph point for a popup display of SQL text, end-user response time, rows returned, bytes sent, packets sent, client IP/port, login id, application, database and SQL errors for the client SQL request. A responsive design allows the mobile app to dynamically adjust to the size of the eight graphs. e.g. on a tablet the eight graphs are displayed in 2 rows and 4 columns so that all of the graphs may concurrently be viewed.
View SQL Response Time Alerts on Mobile App
View SQL Response Time Alerts on Mobile App
View client SQL response time alerts for a server over any time period. They may also be emailed. Tap once on an alert for a popup display of the alert.
Sql Power Tools awarded Community Choice Best Database Monitoring and Performance Product by SQL Server Magazine Sql Power Tools awarded Best Database Monitoring and Performance Product Community Choice Gold by SQL Server Magazine 2009.
Customers
The Zero Impact Baseline Analysis Monitor is released. Offers early warning of deteriorating performance in SQL Server database server farms. 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. Read more.
" 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. "
Frank LaDue
Advanced Technology Company

Live Support