Browse by Tags

Webcast Now On Demand: The 5-Minute SQL Server Healthcheck
16 November 09 08:59 PM | Christian | 1 comment(s)

I joined Kevin Kline from Quest on Thursday for a webcast on "The 5-minute SQL Server Healthcheck" which is now available online. I hope you find it useful! http://www.quest.com/events/listdetails.aspx?contentid=10581&technology=34&prod...

Filed under: SQL Server 2005, SQL Server 2008, SQL Server waits, Troubleshooting

FREE one-day seminar on Optimising SQL Server Performance
08 March 09 01:54 PM | Christian | with no comments

I’m going to be joining Quest Software on 24th March for a seminar on Optimising SQL Server Performance at the Quest offices in Maidenhead, Berkshire. Attendance is FREE and you’ll get a chance to try out Quest’s product range with hands-on-labs: BOOK...

Filed under: SQL Server 2005, SQL Server 2008, SQL Server waits

My session at SQLBits II - What Are You Waiting For?
06 March 08 09:05 PM | Christian | with no comments

Thankyou to all those who attended my session "What Are You Waiting For?" last Saturday at SQLBits II in Birmingham. There was some great feedback and constructive comments which I will incorporate when I deliver the session at the European...

Filed under: SQL Server 2005, SQL Server waits, SQLBits

SQL Server: resource waits and signal waits
14 November 07 04:24 PM | Christian | 2 comment(s)

You won't find any resource waits that specifically measure CPU wait time, instead you measure “signal waits” which have been conveniently worked out for you in SQL Server 2005 and exposed in the sys.dm_os_wait_stats dmv. Specifically, a signal wait is...

Filed under: SQL Server 2005, DBCC, SQL Server waits