Intermittent SQL Server errors are among the most difficult problems to troubleshoot. A job can run successfully hundreds of times and then suddenly start failing. The same error may return days or weeks later, with no obvious change in the code.
Read moreHow a global watermark silently excluded historical data in a multi-company environment, while a missing index turned a simple SELECT into a minutes-long operation.
Read moreThis story follows the investigation from recurring symptoms through failed conventional fixes to the storage-level change that finally stabilized the affected table.
Read moreRecently, we found an interesting pattern during exploring one of our SMT graphs while doing a health check of a SQL server. The following graph shows us the Load Factor attribute. The value came from system table sys.dm_os_schedulers, which the SMT tool
Read moreThis is one of our tuning successes, particularly for the nightly process of loading data into a report server from the main database.
Read moreRecently we had a request to optimize LATCH_EX waits on one of the production servers for our customer. Today I would like to share with you our apporach and how we handled the situation.
Read more