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

Query very slow Expand / Collapse
Author
Message
Posted Saturday, April 19, 2014 4:06 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, July 3, 2014 11:46 PM
Points: 61, Visits: 379
Hi All,

one of my production server i am facing following problem.

1) stored procedures very slow some time.i mean the same stored procedure morning time i got a result very fast. same parameter some time very very slow.Database engine tuning adviser tool also recommended zero percent.Log file size also very less .tempdb size also less.Please help what may be a reason .what is the solution?

2) i configured rebuild index job also every alternative days night time.


Post #1563229
Posted Saturday, April 19, 2014 4:38 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 4:39 PM
Points: 7,038, Visits: 12,951
There can be tons of reasons...
Without seeing the code together with the actual execution plan of the code section in question for both cases (fast and slow) it'll be just guessing.
My pot shot would be a locking/blocking condition or bad statistics.




Lutz
A pessimist is an optimist with experience.

How to get fast answers to your question
How to post performance related questions
Links for Tally Table , Cross Tabs and Dynamic Cross Tabs , Delimited Split Function
Post #1563235
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse