SQL Server Administration | Remote SQL Server DBA Technical Support Services

SQL Server Performance Tuning

SQL Server Performance Tuning provides early detection and identification of hardware (incorrectly configured or inadequate hardware subsystems), inproperly configured SQL Server environments and (most commonly) poorly designed SQL Server databases. Each of these factors impacts upon your SQL Server's ability to perform optimally and can also place additional overhead onto the SQL Server's resources. Unfortunately SQL Server's performance decay curve is also exponential, meaning that once a certain performance impact threshold is acheived, the SQL Server will quickly grind to a halt.


UniverSQL's SQL Server Performance Tuning service thoroughly investigates all aspects of your SQL Server environment (hardware, SQL Server, Databases) via a comprehensive 5 stage analysis process;


Information Discovery

UniverSQL employs a variety of SQL Server, Microsoft Windows and custom diagnostics information gathering utilities to collate the information required to perform an analysis of your SQL Server performance tuning efforts over a period of time.


SQL Server Performance Analysis

After collecting the necessary Operating System and SQL counters, we perform a detailed analysis of hardware performance and throughput, memory and cache utilisation, partitioning of datasets, disk I/O and SAN utilisation as well as database query execution paths in order to ascertain where system performance issues lie.


Assessment of Viable Solutions

Against each identified SQL Server performance problem, we then assess possible solutions for the problem in order to identify the optimal fix to resolve the issue. Often more than one solution is identified against each issue.


Reporting

From there, a detailed report of the findings is collated which you will receive for review. This report will contain details of all the findings and proposed solutions inherent to the SQL Server Performance Tuning exercise.


Implementation

UniverSQL provides an end-to-end solution in the implementation of it's SQL Server Performance Tuning service. We'll liaise directly with application developers to address poor performing queries, hardware vendors to persue necessary upgrades or hardware reconfigurations.



SQL Server Performance Dashboard


SQL Server 2005 Performance Dashboard Reports is an additional download / addon which leverages SQL Server 2005's DML and DDL quries, opening up the black box which used to be SQL Server. These reports assist in the monitoring and identification of SQL performance problems on within your SQL Server 2005 database server. Note; Performance Dashboard requires SQL Server 2005 with SP2 or later.


Download Performance Dashhboard


SQL Server 2005 Performance Dashboard Reports

[Fixed] Performance Dashboard Setup Script

SQL Server DBA Dashboard