Post reply

need suggestion on tuning the attached query

  • December 6, 2012 at 10:34 pm

    #271579

    Hello Everyone,

    I need help in tuning a complex EF generated sql query. My developers are completely relying on EF SQL and this is one of the worst SQL queries i have ever seen. The problem is I cant think of where to start. I am not able to see the full execution plan of it. I discussed with higher level dev managers that we shd start using our own stored procs instead of relying on the EF sql queries. Any inputs are highly appreciated.

    Thanks a bunch experts. Here is the query attached to this forum.

    Thanks again.

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

  • December 6, 2012 at 10:37 pm

    #1566440

    I already ran this through the tuning wizard and it suggested few indexes and a bunch of statistics with 9% performance improvement

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

  • December 7, 2012 at 4:07 am

    #1566544

    Have a read of this article --> http://qa.sqlservercentral.com/articles/SQLServerCentral/66909/%5B/url%5D, about how to post performance problems.

    Forever trying to learn
    My blog - http://www.cadavre.co.uk/
    For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
    For better, quicker answers on SQL Server performance related questions, click on the following...http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • December 7, 2012 at 7:36 am

    #1566614

    Cadavre (12/7/2012)

    Have a read of this article --> http://qa.sqlservercentral.com/articles/SQLServerCentral/66909/%5B/url%5D, about how to post performance problems.

    please find attached the query execution plan,query and ddl of tables involved in this sql.

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

  • December 7, 2012 at 9:20 am

    #1566665

    The query execution plan,query and ddl of tables involved in this sql are attached above

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply