Tag: SQL Doctor
The right tool for the job
I read a blog post from Brent Ozar (blog|twitter) explaining recent encounters he had with a plumber and an exterminator. In this post he shows the great service provided by both professionals and that he was happy to pay each professional a prorated rate of about $1,000 dollars per hour. Wow! How do they make [...]
Posted: July 14th, 2011 under General.
Tags: SQL Doctor, SQL Server 2005, SQL Server 2008, SQL Server Performance
Comments: none
Parallelism: Stop waiting!
In my previous blog post ‘Parallelism: Hurry up and wait’ I discussed how parallel queries cause CXPACKET waits. I also covered the common causes for these waits to be high on an OLTP server. Today I want to finish up my thoughts on the subject and hopefully round out the discussion for both OLTP and [...]
Posted: January 25th, 2011 under Wait Stats.
Tags: cost threshold for parallelism, CXPACKET, Parallelism, Query Optimization, Query Performance, Query Tuning, SQL Doctor, SQL Server 2005, SQL Server 2008, SQL Server Performance, Wait Stats
Comments: none
Parallelism: Hurry up and wait
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
Comments: 2
SQL Doctor encounters ‘The Scary DBA’
Earlier this week a colleague of mine frantically ran up to my desk asking if I had read the SQL Doctor review by ‘The Scary DBA’. For some reason my initial reaction was to fall backwards out of my chair (almost falling out of the window and squashing the painter that happened to be outside [...]
Posted: December 9th, 2010 under General.
Tags: Grant Fritchey, SQL Doctor, The Scary DBA
Comments: none
