Microsoft SQL Server Performance Auditing User’s Guide

This manual describes the features of the DB Audit Performance Add-on for Microsoft SQL Server, including how to use the install and configure the add-on, use graphical user interface and performance audit and analysis reports.

When to Use the Performance Auditing Add-on

If you are not satisfied with your SQL Server performance, you can add additional CPU or improve other hardware characteristics to boost overall performance. This seems to be obvious, the more CPUs your server has, the faster it can perform. However, the standard edition of SQL Server can support up to 4 CPUs only. For support for more than 4 CPUs, and up to 32 CPUs when using Windows 2000 or 2003 Datacenter Server, you will need to run SQL Server 2000 or 2005 Enterprise Edition.

A cheaper alternative to purchasing expensive hardware and software upgrades is tuning SQL Server configuration and applications and making them run more efficient.

DB Audit’s Performance Auditing Add-on is designed to help database administrators and developers configure Microsoft SQL Server for maximum performance and help determine the cause of poor performance in a SQL Server environment. It also provides over 40 performance-focused reports for analyzing the CPU usage, input/output (I/O) and performance efficiency of SQL queries and the entire SQL Server environment.

DB Audit’s Performance Auditing Add-on can collect and analyze statistical performance data that you cannot normally get from the Windows Performance Monitor. You can use the Windows Performance Monitor to monitor and analyze server activity on the top level, monitor hardware usage and bottlenecks. You can use DB Audit’s Performance Auditing Add-on to X-ray the internal database activities and figure out which SQL queries and database operations create performance bottlenecks. You can then change the SQL Server configuration for maximum performance and tune poorly performed database queries and operations.

Download Microsoft SQL Server Performance Auditing User’s Guide

Related PDF Manuals Guide:
Guide to Auditing in Oracle Applications
SQL Server 2005 Installation and Configuration Guide
Oracle Database Performance Tuning Guide
Scalable Network Programming
Deployment Guide: Oracle on Microsoft Windows and Dell PowerEdge Servers
Sophos NAC Advanced SQL Server Database Administrator’s Guide
Dyno-Scan for Palm OS User Guide
HP SmartStart Scripting Toolkit Windows Edition User Guide