One of the requests I get on a regular basis is to capture the performance of statement level events. The latest beta has this feature available. If you’re interested in this I’d like to get some feedback. I handle the SP:StmtCompleted and the SQL:StmtCompleted events. These…
At 1:10AM Sunday morning the main SAN at one of my clients suffered a “partial” failure. Partial means that the SAN was still online and functioning but the LUNs attached to our two main SQL Servers “failed”. Failed means that SQL Server wouldn’t start and the MDF and…
Peter Larsson recently scrubbed his laptop but didn’t bring over his favorites and made a plea for interesting SQL Server related blogs. My reading list of SQL Server blogs and sites is up to 83 sites in Google Reader and I thought I’d share my list in hopes…
The Bit Bucket (Greg Low): IDisposable : Stored Procedures - Time for a real contract? [sqlblog.com/blogs/greg_low/] Interesting case of watching log file growth during a perf test [www.sqlskills.com/BLOGS/PAUL/] Improvement in minimizing lockhash key collisions in SQL Server 2008R2 and its impact on concurrency…