Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cottage125
Starting Member
32 Posts |
 Posted - 2008-07-14 : 19:15:58
|
| Hi all, In my new environment right now we are facing performance related issue.We have one import job runs 4 times a day usually takes 10 minutes. but according to this guys since last 1 month the same job takes longer like 25 minutes for one particular time. this is very random behaviour.It runs long at any time at any day sometimes even on saturday or sunday when end users are not connected What areas should I check on primary basis? and if its blocking but then on sunday no end users are retriving anything then also it takes longer.We have enough disk space and memory on SQL 2005 SP2. Any suggestions will be appreciated. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
cottage125
Starting Member
32 Posts |
Posted - 2008-07-14 : 19:29:53
|
| I put some templates on profiler and found some SPs which are taking longer than usual.But i couldnt find any process due to which they are taking longer. I am not sure what counters to put in perfmon I put avg queue lengh,%processor time,memory pages\sec but got normal results.I know its very broad question but i m not getting any hint |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
cottage125
Starting Member
32 Posts |
Posted - 2008-07-14 : 19:39:56
|
| Ya I have all these maintainance plans set up and they runs once in a day at off peak period.My first import runs early morning at 3 o'clock which creates fragmentation for3 particular indexes but we are defragmenting them right after the import job. |
|
|
|
SCHEMA
Posting Yak Master
192 Posts |
Posted - 2008-07-14 : 19:46:20
|
| I guess see in Profiler if stored procedures are getting recompiled everytime they run. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-14 : 22:35:49
|
| Did you check disk i/o? Did db files grow during data loading? Did you see blocking in trace? |
|
|
|
|
|
|
same job takes longer than usual