Updated sys.dm_os_waiting_tasks script
Edit 10/30/19: the latest version of this script, with additions and adapted for newer versions is here. Over the holidays I was playing around with parallelism
Menu
Edit 10/30/19: the latest version of this script, with additions and adapted for newer versions is here. Over the holidays I was playing around with parallelism
The last post of the year! It’s been a really excellent year all round and time for my traditional post counting down some of the
Back in 2009 I started posting a summary at the end of the year of what I read during the year (see my posts from 2009, 2010, 2011,
Last week we joined our wonderful friend (he MC’d our wedding in 2007) Richard Campbell for RunAs Radio show #400, where we jet-laggedly discuss all kinds
It’s hiring time again, as our consulting volume has reached the point where we need more help on our close-knit, expert team! Specifically, we’ve asked
As we all wind down for the 2014 holiday season, we want to give the SQL Server community a holiday gift to say ‘thank you’
A month ago I kicked off a survey asking how much memory is installed on your largest server that’s running SQL Server. Thank you to
My friend Wayne Sheffield (b|t)is hosting T-SQL Tuesday this month and it’s been a long time since I’ve taken part
Through popular demand we’ve managed to juggle a bit more of our schedule around and found space to fit in another European class in 2015, and it’s
On Friday I made my signature pork ribs for our good friend Bob Ward (along with Kimberly’s truffled cauliflower mash and caramelized broccoli) and I promised
One of the cool new features in SQL Server 2014 is delayed durability (available in all Editions), which is described in detail in Books Online here.
This is a quick post to let you know about a bug that a few people are hitting when running DBCC CHECKDB. The symptoms are
Starting in 2015 we at SQLskills would love to present remotely for your user group, anywhere in the world. Kimberly and I recently did a
In both my wait statistics pre-conference workshops at the PASS Summit and SQLintersection I promised to do a bunch of blog posts. The second one
[Edit 12/10/14: Survey is closed see the editorial here.] One of the trends I’m seeing this year is a slow increase in the number of
[Edit 2016: Check out my new resource – a comprehensive library of all wait types and latch classes – see here.] (Script last updated June
Through popular demand we’ve managed to juggle some of our schedule around and found space to fit in our only class of 2015 in the UK, and
Back in August I wrote a long post about how to ask questions politely and correctly to address what I see as a growing volume
We’ve managed to juggle some of our schedule around and found space to fit in our only class of 2015 in Australia, and it’s open for registration!
It’s well known that one of the common performance issues that can affect tempdb is allocation bitmap contention. I discuss this, and ways to alleviate
I’ve just released our first sets of US classes for 2015 for registration! Our classes in April/May will be in Chicago, IL: IE0: Immersion Event
The two major Fall conferences are 3-4 weeks away so I wanted to give you a heads-up about my new pre-con workshop that I’ve just
(Check out my Pluralsight online training course: SQL Server: Detecting and Correcting Database Corruption.) This is a question that I was sent over email that
Very short blog post to let you all know that I’ve updated my wait stats script so that it works on 2014 and also now
It’s been a bit light on technical posts here over the last few months but now that summer’s over I’ll be ramping up again with
We’ve just released two new courses on Pluralsight: The first new course is the conclusion of Joe Sack’s query-tuning course: SQL Server: Common Query Tuning Problems and
This post is a much-expanded version of the editorial in my last bi-weekly SQLskills Insider newsletter, including a bunch of the feedback I got. (Also see
SQL Server 2005 will end Extended Support on 4/12/2016 (see the Support Lifecyle page for details) and the SQL Server Team in Microsoft is conducting
I’ve just released our final classes of the year for registration! We will be coming to Sydney and Canberra in Australia and teaching our new IEPTO1:
To celebrate our newly revamped IE1 and IE2 classes becoming IEPTO1 and IEPTO2, through the month of July you can register for either October class
I’ve just released our final US classes this year for registration! We’ve revamped our IE1 and IE2 classes so they’re now both focused on performance
This is a question that came up this morning during our IE1 class that I thought would make an interesting blog post as there are
This is a quick blog post to let you know about a bug in SQL Server 2012 SP1 that can cause data loss when performing index maintenance.
Exactly five years ago I published survey results showing target uptime SLAs and actual uptime measurements. I re-ran the survey a few weeks ago to
[Edit 2016: Check out my new resource – a comprehensive library of all wait types and latch classes – see here.] Back in February I
It’s been five years(!) since the last time I asked about your target uptimes for your critical SQL Server instances and I think we’d all
(Check out my Pluralsight online training course: SQL Server: Performance Troubleshooting Using Wait Statistics and my comprehensive library of all wait types and latch classes.) In many
We’ve had a mentoring program here at SQLskills for a few years (the brainchild of Jonathan), where each of us can pick someone who’s attended
For the longest time the guidance around tempdb is that if you shrink it on a live system then it could cause tempdb corruption. A
Over the last few weeks I’ve been investigating a series of customer corruption issues (on one customer’s system) where it appears that the page checksum
[Edit 2016: Check out my new resource – a comprehensive library of all wait types and latch classes – see here.] In some of the
[Edit 2016: Check out my new resource – a comprehensive library of all wait types and latch classes – see here.] Wait statistics, as you
Two weeks ago I kicked off a survey that presented a scenario and asked you to vote for the log_reuse_wait_desc value you’d be most worried to
The Simple Talk folks from Red Gate have been running a Geek of the Week interview series over the last few months and this week
Time for another fun survey, this time around factors causing the transaction log to grow. Imagine you’re the DBA for a company and you come
(Check out my Pluralsight online training course: SQL Server: Performance Troubleshooting Using Wait Statistics and my comprehensive library of all wait types and latch classes.) Two weeks
[Edit: 3/25/14 No more codes left – thanks for all the data! – please don’t send any more.] Yes, you read that correctly. Call me
As we draw close to our IE1 Immersion Events in Sydney and Melbourne, we have a few seats still available so we’re offering a special
With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.