Troubleshooting blocking issues in SQL Server 2000 and 2005

Most of my work is supporting and troubleshooting production environments and very often developers I work with say   “We are having some performance issues in our website and we believe the bottleneck is in SQL Server. We have collected some profilers and some queries take a long time to finish. But if we execute…

3

Biztalk Server 2004 – Mixed Dll loading problem

Sometime ago I had to troubleshoot a problem in Biztalk Server 2004. I was told that Biztalk Server 2004 apparently stopped working and the only way to get it back on track would be to restart the instances and we didn´t had errors reported. After that everything would run smoothly. The worst part was that…

8