StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>Once you get around the profiler timeout issue you should look at tuning your database (if you havent already, although it doesnt sound like it).</p> <p>I have had a similar issue recently and it turned out to be IO blocking due to high reads on certain querys/statements. Getting the profiler to run on top of an already sluggish database was difficult. We had to run the profiler in ten minute sections at quieter times, although this does not help to identify the biggest issues with the heaviest loads.</p> <p>Once we got the profiler to capture data (on sql server 2005) and implemented the indexes and statistics recommeneded by the Database Tuning Advisor (DTA) the database was running at expected peformance levels again.</p> <p>I would recommend you read this free ebook on sql server profiler....</p> <p><a href="http://www.red-gate.com/products/SQL_Response/offers/mastering_sql_profiler_ebook.htm" rel="nofollow noreferrer">http://www.red-gate.com/products/SQL_Response/offers/mastering_sql_profiler_ebook.htm</a></p> <p>It details how to run lightweight traces that will help the DTA recommend indexes and statistics that will improve the performance of your database and also identify some slow running queries that could be located in your code.</p> <p>The trace you are running could be tipping your database over the edge, so running it in 10-20 minute sections might be more feasable.</p> <p>If you have IO blocking issues this affects the overall sql server in general and management studio will seem non responsive at times.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload