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: Tuesday, December 16, 2014 8:25 PM
Points: 63, Visits: 419
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: 2 days ago @ 9:40 AM
Points: 6,842, Visits: 13,372
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
Posted 2 days ago @ 4:17 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Yesterday @ 4:40 AM
Points: 8, Visits: 36
Can we have a look at the logic?

With Thanks,
Satnam
Post #1644651
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse