Search
Blog Series
-
Popular Posts
-
Recent Posts
- “Thou Shall Not Shrink the Database” #TSQL2sDay
- May 2012 – Monthly SQL Server Checklist
- Can You Dig It? – Determining Index Plan Usage
- Changing Priorities
- SQLFriends in Minneapolis
- April 2012 – Monthly SQL Server Checklist
- SQLCLR: Good? Or Evil? #MemeMonday
- April #Meme15 Assignment
- Re-blog – March 23 – March 29
- Re-blog – March 16 – March 22
-
Tag Archives: Wait Stat
Webcast: What Are You Waiting For?
What was the number one question from today’s webcast on wait statistics? Where can the slides and sample code be downloaded. To answer this question of the ages, click on the download link below. Thank you to everyone that attended. … Continue reading
Posted in Performance Tuning, SQL Server, SQLServerSyndication, Wait Stat
Tagged Performance Tuning, SQL Server, Wait Stat, Webcast
Leave a comment
TSQL Tuesday #005 – Wait Stat Report – #TSQL2sDay
I’ve been meaning to join in on the T-SQL Tuesday event for the last couple months and let the time opportunity slip by. This month’s topic is reporting and its seems like a good time to get in on the … Continue reading
Wait Stat Categories
A few weeks ago I posted a job that I use to track wait stats in the DBA database that I bring to a number of clients. I had promised to follow-up with a couple or three reports that could … Continue reading
If You Don’t Know Where You’ve Been
If you don’t know where you’ve been, how can you expect to know where you are going. Seems like such a simple little line and I’m sure many of us can look at history, politicians, and maybe that restaurant review … Continue reading
September PASSMN Meeting Tonight
The Minnesota SQL Server user group (PASSMN) meeting is tonight at the Microsoft offices. Come check us out to network and mingle with your peers and also for the opportunity to learn some new things. Tonight’s topics are: SQL Server … Continue reading
Checkout PASSMN Meeting Next Week
Just one week until the next PASSMN meeting. As I mentioned last week, this month we’ll be focusing a bit on performance. And yeah, guys with lights coming out of his body means performance… or it might be just a … Continue reading
PASSMN September Meeting
Just two weeks away is the next PASSMN meeting. This month we’ll be focusing a bit on performance and to emphasis this point I found a picture of someone moving so fast that light emanates from their body. SQL Server … Continue reading
Find Query Plans That May Utilize Parallelism
When ever I go to a new client to assist with performance issues, I inevitably download the Troubleshooting Performance Problems in SLQ Server 2005 white paper. In my opinion and many others, it is one of those documents that should … Continue reading
Posted in DMO, Performance Tuning, SQL Server, SQL Server 2005, SQL Server 2008, Wait Stat
Tagged DMO, Performance Tuning, SQL Server, SQL Server 2005, SQL Server 2008, Wait Stat
1 Comment
Tonight April PASSMN Meeting (04/21/2009)
Looking for something fun to do? Trying to get your SQL Server to perform a little better? There is a PASSMN (Minnesota SQL Server User Group) meeting tonight. We are meeting a little later than usual because of a room … Continue reading
Posted in DMO, PASSMN, Performance Tuning, SQL Server 2005, SQL Server 2008, Wait Stat
Tagged DMO, PASSMN, Performance Tuning, SQL Server 2005, SQL Server 2008, Wait Stat
Leave a comment
April PASSMN Meeting (04/21/2009)
Drive Your Way to the DMV & Performance Troubleshooting with Wait Statistics April 21, 2009 3:00 PM – 5:15 PM Drive Your Way to the DMV Speaker: Jason Strate, Digineer Dynamic Management Views (DMVs) and Dynamic Management Functions (DMF) have … Continue reading
Posted in DMO, PASSMN, Performance Tuning, SQL Server 2005, SQL Server 2008, Wait Stat
Tagged DMO, PASSMN, Performance Tuning, SQL Server 2005, SQL Server 2008, Wait Stat
Leave a comment
