October 22, 2013 at 9:06 am
Hi ALL,
I am running a querie that pulls the data from few tables and insert the data into another table, it usually took 45m to run but from past few days it is taking 6 hours, I am new to querie optimization and Google is over whelming and I need some basic steps to advanced steps or what to look for remember I am completely new to this stuff.
Thanks all
October 22, 2013 at 11:15 am
first thing is to get sp_whoisactive (v11.11 I think is latest version. see sqlblog.com for it and also a 30 day blog post series by Adam Machanic on it's awesomeness).
look for blocking and various waits.
The problem is that being new to perf monitoring and tuning it may not do you any good to FIND a problem (which you might no even recognize due to lack of knowledge) because you may well not know what to DO about said issue. :w00t:
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
October 22, 2013 at 11:42 am
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply