Survey: transaction log files per database (code to run)

In this survey I'd like to see what the distribution of the number of log files per database is for your servers. I'm planning to do similar surveys through the rest of the year around data files and filegroups too. Please run the following code (with example output): SELECT     DISTINCT [LogFiles],     COUNT (*) […]

Most common latch classes and what they mean

(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.) Back in May I kicked off a survey about prevalent latches on SQL Server instances across the world (see here). It’s taken me quite a while to get around to collating and […]

SQLskills at SQL Connections in October

The SQL Connections Fall show will be in Las Vegas again this year, October 28th through November 2nd. We’ve put together another great show (Kimberly and I are the Conference Co-Chairs), and Kimberly, Jonathan, and I will be there. Here’s the line-up of SQLskills workshops and sessions: Full-day workshops 10/28: SPR201: Leveraging SQL Server 2012 […]

Back to business as summer heats up

You may have noticed that my blog’s been pretty quiet in June and empty in July. May and June were frenetic travel and work months for me, with two two-week teaching trips to the UK and producing two training courses for Pluralsight. Then at the end of June, Kimberly and I took the kids to […]