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 RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
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.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply