|    Register
 

 

Satisfaction is measured in crucial milliseconds
Performance at the VELOCITY of business
Sunday, October 12, 2008
 

SQL Server 2005 Performance Tuning
SQL Server Performance Tuning

Why use SQL Velocity?

When it comes to data driven web applications, speed is king. Your business loses customers when they have to wait on your application. Let us focus on the speed of SQL Server so you can focus on your core business. SQL Server 2005 performance tuning is all we do.

SQL Velocity can provide gains at an extremely low price with a turnaround time that is second to none. We can do this due to our results driven, experience built processes and software run by our people.

The process is designed to identify and resolve the low hanging fruit which accounts for 75-95% of the possible performance gains in most cases. We can do this within 24 hours. We deliver or your money back. You have nothing to lose.

Order SQL performance tuning now

How it works?

  • Download the SQL velocity collector utilities
  • Upload the data to us or provide us access to the collected data.
  • We will analyze the data, provide recommendations and a detailed report

Our base tuning engagement is designed to target the areas that will provide the greatest gains as fast as possible. This is done with the following methodology:

  • Identify performance bottlenecks and usage patterns
  • Verify the server is configured optimally at the hardware, OS, and SQL Server service level to minimize the bottlenecks
  • Identify and tune the most intensive queries
  • Add supporting indexes as needed
  • Remove unused indexes
  • Implement intelligent maintenance scripts customized for the environment
  • Implement a SQL Server performance dashboard

Feel free to ask a question below or check our FAQ.

All recommendations are based on experience and are tested in our test environment before we would recommend deploying to your development or production environments

Order SQL performance tuning now

The SQL Server performance tuning process and software that we have developed allows us to tune most servers in about six to eight hours. The results are the same as those that would previously take one to two weeks on SQL Server 2000. This allows us to provide those same results in a fraction of the time and cost.

The base price for the performance tuning engagement is only $475. We encourage you to shop around and then come back to us. The pricing model even allows you to submit a well tuned application just for performance and design validation. If this offering is more than what you require, we suggest you check out our sister site, http://tunemyquery.com, which focuses on tuning single queries for optimal performance.

This is included in the base price of $475:

  • Server, OS, SQL Server service, database, index and query analysis from the data gathered with our collector
  • Detailed recommendations at the hardware,OS, SQL Server service, database, index and query levels within 24 hours.
  • A custom report will be delivered in executive summary format

Available and free upon request:

  • Custom intelligent index and statistics maintenance procedures with documentation

  • SQL Server 2005 Reporting Services server dashboard reports to monitor performance on your SQL Server.

These options are extra and complement the base tuning engagement:

  • Data collection and before and after report - We do the data collection for you and we do it twice to compare and contrast the baselines to provide a deeper report. This report provides detail level analysis to show the gains that were realized from the engagement.
  • Recommendation implementation

Please contact us before ordering if your database is over 100GB, you have over 10 db's needing tuning or you are running SQL 2000.

Order SQL performance tuning now

Contact us with a custom request
Your Name
Your Email
Subject
Your Request
SubmitCancel
People

The owner and DBA doing the work will be Jason Massie. He has 8 years experience as a DBA and has specialized in performance tuning for the last five. Jason has spoken at the Professional Association of SQL Server Conference, the North Texas SQL Server Users Group, SQL Connections and TechED. He has a technical blog at http://statisticsio.com

Jason has the following certifications:

  • Microsoft Certified IT Professional Database Administrator (early adopter)
  • Microsoft Certified IT Professional Database Developer
  • MCDBA (7.0 and 2000)
  • MCSE
  • MCSD

Copyright 2007 by SQL Velocity - SQL Server 2005 Performance Tuning     |    Privacy Statement    |    Terms Of Use