Slow query response time in SQL Server 2005

Tags:
Query
Slow SQL Query
Why is their a slow query response time in my SQL Server 2005?

Software/Hardware used:
sql server 2005

Answer Wiki

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

The first place to look would be the execution plans for your long running queries. From there you can figure out the indexes which need to be adjusted or created so that the queries will speed up. If you have all the indexes in place this white paper will explain what database maintenance needs to be setup and why.

Once all tables are properly tuned you may need to update your statistics if you aren’t doing that already.

Next check your RAM configuration to make sure that you have enough RAM to hold the data in the buffer cache that you need. If your buffer hit ratio is to low you may need more RAM.

After that you may need to look at your storage subsystem to ensure that it is powerful enough.

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