Query optimization

If you would like to Optimize your SQL Server Query, Tune slow queries in SQL Server and make them run faster  follow the steps in below blog A query in considered to be slow when it is executing for longer duration than expected. Total duration of the query can be broken in to compile time,…

0

Non-yielding IOCP Listener, Non-yielding Scheduler and non-yielding resource monitor known issues and fixes

  Do you see below errors in SQL error along with dumps and stuck? New version of this post in available in This Link   Non-yielding IOCP Listener * BEGIN STACK DUMP: *   05/06/12 03:54:59 spid 0 * Non-yielding IOCP Listener Non-yielding Scheduler * BEGIN STACK DUMP: *   04/16/12 10:09:58 spid 6256 * Non-yielding Scheduler…

10

Unable to open large profiler trace files

Profiler filling up space of my system drive……. When you run the profiler trace (GUI) or open the saved profiler trace file your System Drive gets out of space SQL Server profile uses ‘TMP’ Environment variable for storing the .Trc and trace replay files   By default TMP directory points to your system drive, so…

1