May 17, 2010 at 6:33 am
I made a Stored Procedure as Process with Indexes but when I Executed it on my Local PC it takes 50 Second for 27000 Records Process but while execute on Database Server it takes 18 Minutes. why ?
Note: same structure and Data of Database Server is working fine On local PC .
can anybody help me .
Thanks in Advance.
May 17, 2010 at 6:52 am
Look at the actual execution plans on your local box and on the server. There should be a clear difference.
This will probably tell you what the problem is.
If you want you can post the plans here so we can have a look. Just right-click the plan and select "Save execution plan as..."
/SG
May 17, 2010 at 9:17 am
There must be differences, index fragmentation, statistics age, contention for resources, available memory, connection settings, lots of these things can cause differences in performance.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 17, 2010 at 12:02 pm
Have you been testing it on your machine? Maybe the cache is primed and none of it is loaded on the server?
Likely there are a few things different. I'd check what Grant and Stephan have mentioned.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply