|
|
|
 |
|
What is SQLBenchmarkPro?
SQLBenchmarkPro enables users of SQL Server-based products to quickly and pro-actively identify database performance bottlenecks. SQLBenchmarkPro is a powerful product which is used to monitor, identify and analyse complex application and database performance problems (including long running and inefficient queries) across one or hundreds of database servers concurrently.
Used as both a pro-active and reactive performance management solution, SQLBenchmarkPro is a powerful and empowering necessity for SQL Server based systems. Rather than having to wait for problems to re-occur, or going through the burden of reproducing the problem, SQLBenchmarkPro enables users to retrospectively identify issues instantly. With any modern DBMS it’s virtually impossible to stop bottlenecks before they happen, although pro-actively using SQLBenchmarkPro can help to identify and avoid performance issues before they become debilitating.
SQLBenchmarkPro can even be used to monitor multiple database environments from a centralised control point to:
- identify and analyse database related system performance problems including
- long running and inefficient queries
- poor performing stored procedures
- quickly create, configure, deploy, manage, store and analyse SQL Server Profiler server side traces
- audit user activity (often for SOX compliance)
- identify and monitor system database errors
SQLBenchmarkPro’s repository database stores historic trace information which enables users to study and benchmark system performance over a period of time. This data can also be used to conduct trend analysis and capacity planning for database applications and systems.
|
| Key Benefits |
 |
Provides insight to Database performance bottlenecks
SQLBenchmarkPro enables DBAs, Developers and IT Professionals to quickly and easily identify key performance bottlenecks related to database systems and applications.
|
|
|
Centralised management
Using SQLBenchmarkPro’s management console, users can create, configure, deploy and monitor SQL Server performance traces across an entire enterprise, or even multiple environments, concurrently. Traces can be instantly configured and deployed to the entire enterprise in minutes with a few short mouse clicks, without the need for complex scripting.
|
|
|
Powerful analysis of performance problems
SQLBenchmarkPro’s built-in analysis tool suite provides users with a powerful and instant means of analysing performance data over specified periods of time using the graphing and events analysis tools. Users can instantly run an analysis to show them the most active and longest running queries, or even highlight the worst-performing stored procedures.
|
|
|
Virtually no impact on target server performance
Thanks to SQLBenchmarkPro’s service architecture, SQLBenchmarkPro can be deployed to multiple servers with virtually no performance impact to the target server. This powerful feature means that even during extremely poor performance problems, SQLBenchmarkPro can still be used to diagnose the issue.
|
|
|
Simple, graphical diagnosis of performance bottlenecks
SQLBenchmarkPro’s graphical interface provides means drill-down graphical viewing of performance data, making it a simple task to instantly identify performance spikes. Drilling into these spikes provides finer and finer viewing detail. At any of these points users can run an instant analysis of the results.
|
|  |
|
|
SOX compliance auditing
SOX compliance for many companies is a necessary requirement. SQLBenchmarkPro is an essential part of SOX compliance, enabling centralised collection and auditing of database security activities.
|
|
|
| |
| Deployment Options
Flexibility and scalability are made simple with the deployment options available for SQLBenchmarkPro. SQLBenchmarkPro has 3 main components that can all be installed on one server or alternatively deployed on different servers in a distributed manner depending upon your needs.
SQLBenchmarkPro provides either a row-by-row or bulk load option allows you to compress and or move trace files before they are bulk-loaded to the Repository Database. This design is intended to allow implementation scenarios where you might separate the Trace Service from the Repository Database over low-bandwidth networks such as the internet.
|
Key components of a SQLBenchmarkPro solution include:
- SQLBenchmarkPro Management Console
- the repository database
- the target database server
- the SQLBenchmarkPro Service
|
|
|
SQLBenchmarkPro Management Console (Browser)
Users create trace templates, schedule them to run against target database servers, drill into & analyse output from traces and view reports in the SQLBenchmarkPro user interface.
Repository database
The repository database stores trace templates, schedules, target server locations and reports as defined by users via the user interface. Events collected by the Trace Controller Service are also stored in the Repository Database for viewing by users (using the SQLBenchmarkPro user interface).
Trace Reader Agent
The Trace Controller Service connects to target database servers on a regular basis, ensures that traces are running according to their schedules, collects log files from target servers and stores events collected in the repository database.
The Trace Controller Service can be installed on any machine provided it can connect to target database servers and issue TSQL commands. You might chose to install the Trace Controller Service directly onto a production database server, or alternatively you can install it anywhere else within your network.
Note SQLBenchmarkPro does not install any components on the target server/s being monitored.
|
|
 |
|
|
|