Performance Tuning and System Health Audit

We work quickly and efficiently to get results. Generally, it takes from a few hours to a few days to diagnose and correct most performance problems. Following a set of best practices based on years of performance tuning and troubleshooting experience, we begin by developing an understanding of your needs and system issues. We then identify performance bottlenecks and wasted resources and recommend changes to improve performance. These recommendations are tested and a deployment plan is developed. Changes are implemented, and we work with you to monitor performance gains and continue to tune until your scalability and performance goals are met.

The goal of this System Health Audit is to help you identify any performance problems with your SQL Server, its environment or its structure. Using our Performance/Health Checklist, we can determine the bottlenecks, give recommendations and provide solutions. Our unique checklist covers these areas:

	Hardware
	Operating System (Windows 2000 and 2003
	SQL Server Configuration and Settings
	Application and SQL Code
	Proper File Locations
	Index Tuning and Defragmentation
	Locking (Table, Extent, Page, and/or Record