The Multifunctioning DBA

Jul 29 2010   5:00PM GMT

SQL Query Troubleshooting



Posted by: Colin Smith
Tags:
DMV
Performance Tuning
SQL Server 2008

So I am by no means good at wtiting T-SQL or optimizing the code. But, Yesterday one of our devs called me and said that he had a SSIS job that was running i about 45 minutes start taking 10 hours. Ouch that can not be good I said. I asked him what tables were involved and I opened up my Professioanl SQL Serveer 2008 Internals and Troubleshooting and found a DMV that would show missing indexes. After taking a look at that I found that if I created three indexes on the table that the dev was joining on I might be better off. I created the three indexes and asked him to run the job again. What do you know, the job was back down to the time expected. All I can say is thank you SQL Server for being smart enough to tell me what to do.

 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: