Tag: Wait Stats
We recently released SQL doctor 2.0, which now quickly prioritizes wait statistics and provides expert level advice for alleviating bottlenecks and other performance issues. To create the wait stat recommendations we worked closely with industry experts like SQL Server MVP and SQLAuthority.com founder, Pinal Dave, to help users analyze wait statistics and quickly improve server [...]
You may be inadvertently limiting the number of worker threads available to the SQL Server process. This could be caused from the ‘max worker threads’ option being set to 255 after the upgrade of the SQL Server 2000 instance to a later version of SQL Server. On SQL Server 2000, the default setting for ‘max [...]
Posted: March 23rd, 2011 under SDR-W6, Wait Stats.
Tags: max worker threads, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server Performance, THREADPOOL, Wait Stats
I have spent a significant amount of time researching SQL Server wait stats on the web to find the best information currently available on the subject. There are a myriad of resources on the web discussing wait stats and I quickly found out how time consuming it is to extract the diamonds from the rough. [...]
Earlier this week I was researching a performance issue on a SQL Server instance using the ‘sys.dm_os_waiting_tasks’ and ‘sys.dm_exec_requests’ DMV’s and noticed a ton of page latch and page io latch waits. This is nothing unusual when dealing with performance issues and is normally just one of the signs of poorly written queries, missing indexes, [...]
At the 2010 SQL PASS Summit we had the great pleasure of speaking with the well known SQL Server MVP Pinal Dave (blog). One of the topics that were discussed was the use of wait stats by SQL doctor for generating recommendations and he agreed to spend extra time with us to discuss his [...]
Posted: January 14th, 2011 under Wait Stats.
Tags: cost threshold for parallelism, CXPACKET, max degree of parallelism, Parallelism, Query Optimization, Query Performance, Query Tuning, SQL Doctor, SQL Server 2005, SQL Server 2008, SQL Server Performance, Wait Stats