Yeah a third party has built an execution plan so complex it makes a fusion reactor feel inadequate. Wonder why it's running slow?
You have to watch those queries....
a poorly written application!
Thanks to SQL sentry and DPA we have leveraged the tools to clean up the database as much as possible. When there are issues, we can now drill down to the user running what I call an "inappropriate" query. Amazing tools that totally hit the mark! I LOVE my database administrator! We have a mutual admiration society here, no finger pointing anymore!!! I love my job!
ALL OF THE ABOVE... Oh, add locked records to the list..
\m/
all of the above
ghosts in the machine duh
DNS is always the problem....
