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…
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…
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…