We provide thorough analysis of your database load. We use embedded tools to gather statistics like perfmon, Profiler, dynamic management views and third party solutions if needed. We tune instance of sql server 7, sql server 2000, ms sql server 2005, sql server 2008 versions. General solution to resolve an issue of server extreme load is to add resources or upgrade the server's hardware. But it happens that changes of only 30 lines of sql application code may free up up to 90% of overall server load.

Optimization of the most expensive and frequently executed queries will save you at least 50% of your CPU, IO and memory resources. As a result you will get 

• increased system throughput, system capacity and responce times
• enhance usage of your CPU, disk subsystem and memory