SQL Performance Optimization and Monitoring
You Asked - We Listened

You wanted the option of having a Windows based reporting front end with real-time dashboard functionality, in addition to our standard web based reports module.  Now you can have both.  We are pleased to announce our new Periscope Reports for Windows module - free with all the rest of the Periscope for SQL Server family of utilities.

• Display your top 10 (or 50 or 500, etc.) most expensive queries by CPU, disk I/O, memory, duration, etc.

• See which queries are run most often by user, application, host, database, date, etc.

• Associate system performance metrics with the exact SQL statements .  See exactly which SQL query caused the CPU to spike to 100% last night.

• Associate system utilization trends with application utilization trends .  For example, show that a 10% increase in your ECommerce application caused a 25% increase in Disk I/O.  Use this information to forecast future hardware needs.

• Show complete blocking scenarios , including the involved SQL statements, DB objects, host, application, duration, etc.

• Receive alerts based on performance metrics thresholds.

• 24/7 monitoring with virtually zero overhead .  No components installed on target SQL Servers

• Highly configurable monitoring service.  Capture data by statement performance or duration, database, application, host, time of day, etc.

• All data is maintained in the Periscope Repository Database for long term trend analysis.  Has application volume increased since last month?  Have specific queries become more expensive recently?  Find out...

Periscope captures SQL database performance metrics and provides a central repository for analytical data.  You can view detailed information on database access and SQL command metrics, isolate and resolve performance problems - including blocking - and perform long term trend analysis with the supplied HTML based reports.  All this is accomplished with near zero overhead on the target SQL servers.