 |
» |
|
|
|
|
|
 |
|
|
Business Value |
|
|
|
Reduce costs and optimize the availability and performance of SQL® Servers |
|
|
|
1-800-786-7967 - US only
1-800-474-6836 - Canada only |
|
|
|
|
|
|
Overview |
|
|
|
HP SQL Server Viewer extends the HP Storage Essentials Suite with application-to-spindle management of
SQL Server. With its powerful capacity, performance, and dependency management capabilities, this integrated Application
plug-in helps ensure the availability and performance of SQL
Server and applications in Storage Area Network (SAN)
environments.
HP SQL Server Viewer automatically discovers SQL Server , tablespaces, files and graphically depicts
their dependencies on the SAN. The path that each SQL Server element takes through host mount points, servers, volume
management software, HBAs, fabric switches, and storage systems is represented in a single, integrated view. These
powerful path management capabilities, combined with real-time performance monitoring features, enable you to predict
the impact of planned and unplanned SAN downtime on SQL
Server applications and determine the root cause of SQL
Server performance
problems. HP SQL Server Viewer also extends the full range of capacity management, role-based security, event
management, reporting, and policy-based automation capabilities of HP Storage Essentials Suite to
SQL Server environments.
|
|
Features |
|
|
|
Discovery and SAN dependency management |
- Discovers SQL Server instances, devices, and files
- Correlates dependencies on host mount points, volume managers, servers, HBAs, fabric switches,
and storage systems
Application Explorer with topology visualization |
- Renders the storage topology from the perspective of
SQL Server, and shows all of the SAN resources in
the SQL Server "supply chain" (e.g. SQL tablespaces,
SQL database files, host mount points, volume management
software, host, HBA port, switch port from host, ISLs, switch port to storage system, and storage system
volumes and disks).
- Identifies failover and load balancing relationships and redundant paths
- View Total Capacity, Total Used, Percent Used, and Available for all
SQL Server instances, devices,
and database files
- "In context" capacity views for all dependent SAN resources (host servers, fabric switches,
storage systems)
- Historical trend charts with customizable start and end dates and hourly, daily, weekly, and monthly
snapshots
- Trend extrapolation for capacity planning
Performance monitoring with SmartGuideTM technology |
- Real-time monitoring of key SQL Server counters, including Buffer Hit Ratio; Parse CPU to Total
CPU Ratio; Dictionary Hit Ratio; In Memory Sort Ratio; File Write, Read, and Total I/O Percent;
Library Cache Hit Ratio; Redo Buffer Allocation Retries Ratio; Redo Logspace Request Ratio; System
Event Time Waited; Tablespace Write, Read, and Total I/O Percent
- Real-time monitoring of dependent SAN resources; SmartGuide technology filters out hosts, HBA
ports, switch ports, and storage system ports that are not relevant to the selected
SQL Server path
- Performance measurement views enable administrators to simultaneously display traffic and
utilization charts that monitor individual statistics for every element in the
SQL Server path
- Historical trending and trend extrapolation of all
SQL Server and SAN resource counters
- Out-of-the-box and customizable reports on SQL
Server and SAN elements
- Export to PDF, XML, Excel, HTML
- Built-in auto-email and e-mail scheduling functions
Event and policy management |
- Free Space and Percentage Storage Used triggers for all
SQL Server instances to proactively avoid
out-of-space problems
- Actions for sending email, generating events, or running custom scripts or programs
Role-based Security and Organizational Groupings |
- Grant read-only, asset record, and provisioning permissions to different administrators
- Block specific SQL Server instances, hosts, switches and arrays from different administrators’ views
|
|
|
