Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Query very slow Expand / Collapse
Posted Saturday, April 19, 2014 4:06 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, November 29, 2016 9:38 PM
Points: 93, Visits: 628
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



Group: General Forum Members
Last Login: Wednesday, February 10, 2016 11:50 AM
Points: 6,897, Visits: 13,559
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.

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 Wednesday, December 17, 2014 4:17 AM


Group: General Forum Members
Last Login: Thursday, October 20, 2016 4:03 AM
Points: 180, Visits: 200
Can we have a look at the logic?

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

Add to briefcase

Permissions Expand / Collapse