facing serious performance issues, please see the scenario below need urgent help

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » facing serious performance issues, please see...

12 posts, Page 2 of 2

««1 2

facing serious performance issues, please see the scenario below need urgent help - Please chk the code below

Rate Topic

Display Mode

Topic Options

Author

Message

Lowell

Posted Sunday, January 27, 2013 12:19 PM

SSChampion

Group: General Forum Members
Last Login: Today @ 6:12 AM
Points: 11,645, Visits: 27,741

chris@home gave you teh best advice so far: if you can rewrite teh query, redo it so that it is 5 unions, using the agregate example he already put to gether for you;

you are looking at at least an order of magnitude improvement doing it that way(ie 6 seconds instead of 60)

Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son

Post #1412143

ALZDBA

Posted Sunday, January 27, 2013 1:29 PM

SSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 2:17 AM
Points: 6,862, Visits: 8,049

just my 2ct, to add to previous responders replies:

In your sproc, chances are filter arguments aren't sniffed to your advantage at query plan generation time.
Reason for that is you are parsing and completing the filter arguments within the sproc itself.
Try handing there parameters over as needed by the sproc itself.
i.s. try writing your sproc so it accepts the needed filter data as input paramters and see how that influences the query plan.
It may even be enough to add 'with recompile' to the detail query ( please implement the grouping and union all advice )

Johan

     Jul 13

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

- 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" BigGrin

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me Hehe

Post #1412147

« Prev Topic | Next Topic »

12 posts, Page 2 of 2

««1 2

Permissions