Query perfomance Issue

Question

Post reply

Query perfomance Issue

imran_ghainsh

SSC Rookie

Points: 47
More actions
May 14, 2010 at 12:47 am

#221482

I made a Stored Procedure as Process with Table Index 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 ?
can anybody help me .
Thanks in Advance.

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

krayknot SSCertifiable Points: 7998 More actions · Answer 1

system configuration?

kshitij kumar
kshitij@krayknot.com
www.krayknot.com

Dave Ballantyne SSC-Dedicated Points: 33556 More actions · Answer 2

Please see this article

http://qa.sqlservercentral.com/articles/SQLServerCentral/66909/

Clear Sky SQL
My Blog[/url]

Nagesh S-432384 SSCrazy Points: 2231 More actions · Answer 3

Check the indexes and their fragmentation levels. if they are identical then there should not me more difference.

Nag

Nag
------------------------------------------------
How to get the best help on a forum

http://www.sqlservercentral.com/articles/Best+Practices/61537

Dave Ballantyne SSC-Dedicated Points: 33556 More actions · Answer 4

Nagesh S-432384 (5/14/2010)
Check the indexes and their fragmentation levels. if they are identical then there should not me more difference.
Nag

Could be a hundred other things. Need DDL and execution plans to provide any advice.

Clear Sky SQL
My Blog[/url]

Paresh Prajapati SSCertifiable Points: 7567 More actions · Answer 5

imran_ghainsh (5/14/2010)
I made a Stored Procedure as Process with Table Index 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 ?
can anybody help me .
Thanks in Advance.

You need to optimize ur stored procedure as 50 seconds is longer.

check the logic where you are using in join or in where condition.

Please see the execution plan for that and find the fragmentation for the indexs ,

and do the necessary step to reorganize/rebuild indexs.

Update statistics as well check the database configuration.

_____________________________________________________________________________________________________________
Paresh Prajapati
➡ +919924626601
http://paresh-sqldba.blogspot.com/[/url]
LinkedIn | Tweet Me | FaceBook | Brijj

imran_ghainsh SSC Rookie Points: 47 More actions · Answer 6

Dear but I have Made already Index on Database Server.

Same structure is working Fine on Local PC except Database Server.

Thanks

Nagesh S-432384 SSCrazy Points: 2231 More actions · Answer 7

As Dave Ballantyne said, if you can provide sql query and execution plans from both the servers then it will be helpful provide any advice.

Nag

Nag
------------------------------------------------
How to get the best help on a forum

http://www.sqlservercentral.com/articles/Best+Practices/61537