Having gone through it and the crushing affects that we eventually ran into on our production boxes, my first step is now to check if the connection strings are MARS enabled. The documentation, for example, for Entity Framework states that it's off by default. I have anecdotal evidence that it actually defaults to on. MARS is for very special, tightly controlled, very well written specialty code. Since most people's code meets none of those requirements, you need to make sure that it's turned off.
Also anecdotally, all of those 15 second warnings seem to have simply disappeared after we turned off MARS on all connection strings for all applications.
is pronounced ree-bar and is a Modenism for R
First step towards the paradigm shift of writing Set Based code: Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair
How to post code problemsHow to post performance problemsForum FAQs