Database Mirroring Monitor can cause large tempdb growth in SQL Server 2005 – changed behavior in SQL Server 2008

On extremely rare occasions in SQL Server 2005, when the following conditions are true:   1.       You have a database configured for database mirroring 2.       You have replication configured on the same database 3.       You are running the database mirroring monitor 4.       The SQL Agent job created by the database mirroring monitor is enabled  …


Kayaking and tempdb file placement

So, no posts for 10 weeks, but that’s because sometimes there are other things going on in Stockholm as opposed to SQL Server support 🙂 Here’s what I’ve been doing over the summer….   I’ve been fortunate enough to have several weeks paternity leave off to spend with the family and enjoy the Swedish summer….