Written by Mohit Gupta, Microsoft Premier Field Engineer. Every now and then we have deadlocks taking place in SQL Server.  Most go unnoticed, either because the frontend application handles it gracefully.  Or no error is not reported out to...

Written by Mohit Gupta, Microsoft Premier Field Engineer. In my last post I talked about how to get the list connections (e.g. who is connected and requests are they running on SQL Server). I talked about how to use dm_exec_connections, dm_exec_sessions...

Article by Danijel Klaric, Premier Field Engineer. One of my customers came to me with the following issue and asked if there were “better” solutions available than they found using their own Internet research. They use a mix of Outlook 2007 and Outlook...

I highly recommend giving this a read so you are ready for Windows Server 2012.  The dude had a hand in proofing the book and even has a sidebar on page 25 on performance monitoring.  Give it a read, rumor has it there may be some floating around...( read more ) ...read more