The Multifunctioning DBA

Jul 29 2010   5:00PM GMT

SQL Query Troubleshooting

Colin Smith Colin Smith Profile: Colin Smith

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.

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:

Share this item with your network: