One of the requests I get on a regular basis is to capture the performance of statement level events. The latest beta [http://www.scalesql.com/cleartrace/ClearTrace.2008.35.zip] has this feature available. If you’re interested in this I’d like to get some feedback. * I handle…
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 [http://weblogs.sqlteam.com/peterl/] recently scrubbed his laptop but didn’t bring over his favorites and made a plea for interesting SQL Server related blogs [http://weblogs.sqlteam.com/peterl/archive/2010/02/03/The-impossible-thing-happened.aspx] . My reading list of SQL Server blogs and…
The Bit Bucket (Greg Low): IDisposable : Stored Procedures - Time for a real contract? [http://sqlblog.com/blogs/greg_low/archive/2010/01/19/stored-procedures-time-for-a-real-contract.aspx] [sqlblog.com/blogs/greg_low/] Interesting case of watching log file growth during a perf test [http://www.sqlskills.…