December 6, 2012 at 10:34 pm
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
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
Have a read of this article --> http://www.sqlservercentral.com/articles/SQLServerCentral/66909/%5B/url%5D, about how to post performance problems.
December 7, 2012 at 7:36 am
Cadavre (12/7/2012)
Have a read of this article --> http://www.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
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