DPA Datasheet Sql Server
User Manual:
Open the PDF directly: View PDF 
.
Page Count: 4
Database Performance Analyzer
for SQL Server
page 1
SolarWinds® Database Performance Analyzer for SQL Server is a comprehensive database
performance monitoring and analysis solution for DBAs, IT managers, and application
developers. Database Performance Analyzer eliminates performance bottlenecks, improves
application service, and reduces overall cost of SQL Server operations.
FOCUS ON RESPONSE TIME
Database Performance Analyzer is different because it focuses on instance response time,
nding the root causes of delays inside of SQL Server®. Database Performance Analyzer tracks
every query in every active session, and captures the SQL Server® wait types that impose delays
on the query.
DATASHEET
TRY IT FREE
30 days, full version
Database Performance Analyzer helps you quickly pinpoint the issues that have the greatest
impact on response time.
page 2
DATASHEE T: DATABASE PERFORMANCE ANALYZER FOR SQL SERVER
SUPPORTS SQL SERVER DEPLOYMENT OPTIONS
Monitor and optimize SQL Server from a single view, whether that’s on-premise, virtualized,
or in the Cloud.
HISTORICAL TREND ANALYSIS
Database Performance Analyzer captures multiple dimensions of response time and server
statistics in the data warehouse repository. While many tools focus only on the current situation,
Database Performance Analyzer is unique because it analyzes repetitive clues that explain why
SQL Server response is slow. The graphical display makes it easy for anyone – DBAs, managers,
and developers – to see the trends and patterns that tell the complete performance story.
TRY IT FREE
30 days, full version
Historical analysis exposes the root cause of problems.
page 2
DATASHEE T: DATABASE PERFORMANCE ANALYZER FOR SQL SERVER
AGENTLESS ARCHITECTURE
Database Performance Analyzer installs no software or agent on the monitored server, placing
less than 1% load on the monitored database instance. Database Performance Analyzer
server software is installed on a separate system, which can be any Windows®, UNIX®, or Linux®
server, typically a test system under control of the DBA. Database Performance Analyzer data
warehouse repository is congured on any Oracle®, SQL Server® or MySQL instance, either on
the same or different server as Database Performance Analyzer software. In multi-vendor
environments, Oracle®, DB2, SAP® ASE, and MySQL® databases can also be monitored from the
same Database Performance Analyzer server.
KEY ADVANTAGES
»Four Clicks to Resolution. Alarm trail leads DBAs directly to the root cause of the problem
in 3-4 clicks.
»No Agents. No Tracing. Less than 1% load on monitored servers makes Database Performance
Analyzer the lightest high performance monitoring tool available.
»Multi-Dimensional Performance Analysis™. Simplies root cause analysis by correlating SQL
statements, context, system and storage health, wait types, and response time.
»Resource baselines, alerts, and reports. Proactively monitor system health, identifying trends
before they become problems.
»Show the complete picture. DPA for SQL Server® correlates essential statistics to give an
understanding of query bottlenecks, server health, and how session statistics interact—
providing a complete performance picture.
TRY IT FREE
30 days, full version
Database Performance Analyzer Agentless Architecture
page 3
DATASHEET: DATABASE PERFORMANCE ANALYZER FOR SQL SERVER
»Reduce blocking and deadlocks. Identify the cumulative waits caused by root or lead blocker
as well as total victim impact in deadlocks to focus tuning efforts on the critical queries.
FEATURES
»Identify SQL blocks and corresponding locks.
»View response time delays in real time, or the history up to weeks and months.
»Automatically schedule graphical performance reports for delivery to any email address.
»
TECHNICAL SPECIFICATIONS
»Monitored Instances: SQL Server 2008, 2012, 2014 and 2016. Database Performance Analyzer
also monitors Oracle®, SAP® ASE, DB2, and MySQL® from a single installation.
»No client software required, supported browsers include IE, Chrome, and Firefox.
»Database Performance Analyzer runs on Windows and UNIX/Linux servers. Highly
recommended that Database Performance Analyzer system be “always on”, not a laptop that
is removed from the network or turned off.
»Database Performance Analyzer repository: SQL Server 2008, 2012, 2014, 2016 or Oracle 11g,
12c or MySQL 5.6, 5.7. Repository can be on the same or a different server than Database
Performance Analyzer software.
© 2017 SolarWinds Worldwide, LLC. All rights reserved.
trademarks, service marks, and logos may be common law marks or are registered or pending registration. All other trademarks mentioned
LEARN MORE
To find out more:
Visit: www.DimensionSystems.com
Guam Office
643 Chalan San Antonio STE 107
DFS Pacific Plaza,
Tamuning, Guam 96913-3644
Phone: (671) 646-2007 | Fax: (671) 646-2006
Email us at: sales@DimensionSystems.com
Philippine Office
Suite 3004, 30/F Antel Global Corporate Center
Julia Vargas Ave., Ortigas Center
Pasig City, Philippines 1603
Phone: (632) 900-0198
Email us at: salesph@DimensionSystems.com
