Windows Clustered MSMQ Service hangs on startup following failover

We were forced to do an unexpected failover on one of our windows 2008 R2 clusters yesterday which hosts a clustered MSMQ service. One of the nodes blue screened following a windows update and so we went over the to the other node. So far so good, but the service didn’t start on the other… Continue reading Windows Clustered MSMQ Service hangs on startup following failover

SQL Server 2008 R2 cluster setup fails on mount points

(Update from Monday morning, the workaround shown below works for me) Another day, another set up problem (sigh) I was installing a second SQL 2008 R2 instance on a new cluster today. The first one had gone well without incident but the second one had a crucial change in that it used mount points. It… Continue reading SQL Server 2008 R2 cluster setup fails on mount points

Tracing select statements on specific objects in SQL Server without using Profiler

I published a blog post with Basefarm last week about tracing select statements in SQL Server without using profiler. It demonstrates how to use SQL Audit (based on extended events) to record any select statements issues on particular tables over a prolonged time period in a scalable lightweight way. Although SQL Audit was designed as… Continue reading Tracing select statements on specific objects in SQL Server without using Profiler