Recently my customer reported they were seeing intermittent server hangs, connection timeouts and slow performance on their SQL Server instance. The first question I had, do we have PSSDIAG running on the SQL Instance for me to be able to understand the cause of the hang. However since we won’t be running PSSDIAG proactively on… Continue reading Troubleshooting SQL Server Hang using system_health Xevents
Tag: blocking
Long Blocking Chain Caused due to Compile Locks
Recently one of my customers were not able to achieve the desired throughput (transactions per sec) from their Java based OLTP application which is used to pump the data load in sql database To identify the performance issue, we had setup a stress testing environment to simulate a user workload with think time of 2… Continue reading Long Blocking Chain Caused due to Compile Locks
Will NoLock Hint allow you to query a table which undergoing offline reindexing?
Recently I was delivering a workshop and this question came from one of the participants Will NoLock Hint allow me to query a table which is undergoing offline reindexing? My instant answer to that was NO, we cannot query a table with or without NOLOCK hint while we are performing Offline reindexing but I… Continue reading Will NoLock Hint allow you to query a table which undergoing offline reindexing?