Why and how to performance tune SQL Server 2005

Tags:
SQL Server 2000
SQL Server 2005
SQL Server performance tuning
Why do you have to tune SQL Server 2005 for performance, how do you go about tuning it, and, for tuning purposes, which is better - SQL Server 2000 or SQL Server 2005?

Answer Wiki

Thanks. We'll let you know when a new response is added.

Hello,

SQL Server is the engine for databases, which live on an Operating System, which interfaces the Server’s hardware. Each of these components (SQL, OS, Hardware) are highly configurable, but this flexibility can lead to incorrect, or inappropriate choices. Imagine you have a car with a fast engine and aerodynamic body, but doesn’t have any tyres on its wheels – it’s not going to work too well.

A good DBA would have the experience to be able to advise you of the appropriate architecture and configuration of your current and future environment needs. She may use tools to benchmark and find bottle necks in the component parts.

It’s probably beyond the scope of a forum post to cover all aspects of performance tuning.

Here’s a good book on the subject (specifically SQL2005) :

http://www.amazon.com/gp/product/0470176393?ie=UTF8&tag=brozsqseex-20&linkCode=as2&camp=1789&creative=390957&creativeASIN=0470176393

If you have a specific problem – post the details.

Regards,

SCM.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following