The Multifunctioning DBA

Aug 24 2010   4:52PM GMT

SQL Server Performance issues

Colin Smith Colin Smith Profile: Colin Smith

I have a newly created SQL Server instance that is hosting one database that is not very large, about 10 gigs, and nothing else. The Server is configured to use 4Gigs or Memory and lock the pages in memory. The server is running SQL Server 2005 and I am seeing a large number of cxpacket waits. I ran a profile and just used the standard profiler template. I then ran that through the Database Tuning Advisor and found 10 indexes and a large number of statistics that are recommended. The Tuning Advisor says that by implementing these changes I will see a 93% improvement in perfomance. I plan on working with the application vendor and hopefully implementing at least some of the suggestions in order to resolve the issue. My hope is that this will succesfully resolve the issue and that the core of the issue is just poor design and planning on the vendors part.

 Comment on this Post

 
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 other members comment.

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: