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.
Benefits
of using Periscope for SQL Server
>> Improve
end-user response time
Quickly identify and resolve
costly queries or blocking scenarios
>> Increase
existing hardware utilization and ROI
Better forecast
future hardware needs through trend analysis
>>
Improve issue response and resolution time
Receive alerts based on
configurable performance thresholds.
>>
Eliminate
finger pointing and blame-storming
Did your application receive time-out
errors at 3am? See exactly what was happening
in your
database, including any extended blocking
>>
Speed
up time to deployment for new applications
Easily monitor and resolve potential bottlenecks prior to production
rollouts
>>
Generate
easily readable graphical reports
Share with management or other
departments
