Here’s an interesting issue that surfaced recently while troubleshooting a database performance slowness issue. Here, we were trying tune the performance of database for SCOM (System Center Operations Manager). While, we started with regular tuning...

SQL Server 2008 RTM finally reaches it’s end of support tomorrow i.e. April 13, 2010. Here’s snippet from SQL Release Services team blog : Product: SQL Server 2008 RTM Mainstream Support End Date: 4/13/2010 Extended Support End Date: Not Applicable...

Recently, while working on a SQL Performance issue, I encountered a blocking scenario, causing the query timeout and application hang. I worked on this issue along with my colleague Suhas . We started with some vanilla testing and eventually were able...