Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Stored Procedure Performance Expand / Collapse
Author
Message
Posted Thursday, June 27, 2013 6:27 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, May 26, 2014 8:19 AM
Points: 3, Visits: 33
I have one Stored procedure That takes around 2 hour to execute.

it runs in 2 hours on server with 8 processors.
and it runs in same time on server with 32 processors.

is there any way we can make it utilize all the processors.
or can we apply multi-threading so it can get executed faster.

Post #1468108
Posted Thursday, June 27, 2013 6:45 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 8:09 AM
Points: 6,735, Visits: 8,495
hard to say.
I can drive from here to Rome in my 2CV in 5 days.
I can do the same with my Porshe in 5 days if its engine isn't allowed full throtle.

Maybe it would be better to just post your issue according to the guidelines provided by Gail :

How to Post Performance Problems (By Gail Shaw)


Johan


Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere

- How to post Performance Problems
- How to post data/code to get the best help


- How to prevent a sore throat after hours of presenting ppt ?


"press F1 for solution", "press shift+F1 for urgent solution"


Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me
Post #1468115
Posted Thursday, June 27, 2013 6:56 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 10:52 AM
Points: 6,826, Visits: 14,062
amardesai89 (6/27/2013)
I have one Stored procedure That takes around 2 hour to execute.

it runs in 2 hours on server with 8 processors.
and it runs in same time on server with 32 processors.

is there any way we can make it utilize all the processors.
or can we apply multi-threading so it can get executed faster.



My car's broken - can you please fix it?
Without any idea of the tables you are working with and the content of the stored procedure, it's impossible to say for sure. Read the link provided by Johan. At the very least, you could post the whole stored procedure and the batch of execution plans it generates.


“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
Exploring Recursive CTEs by Example Dwain Camps
Post #1468124
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse