Opinions, tips, and news orbiting Microsoft
First published on MSDN on May 24, 2017 AlwaysOn has become a major SQL Server technology. In my own process of learning it, I have often wondered what this mysterious message means. DbMgrPartnerCommitPolicy::SetSyncState: 00000026BD96D330:4 Decoding… Continue reading DbMgrPartnerCommitPolicy::SetSyncState May Seem More Mysterious than It Actually Is
First published on MSDN on May 26, 2017 There are times when you just run into something and you can deem less important and continue. And there are times, where you have to stop and deal with it. In the past few weeks this wait type has simply come … Continue reading DBMIRROR_DBM_MUTEX: The world of Redo Operations
First published on MSDN on Aug 18, 2017 In a customer scenario we saw a query against system views related to AlwaysOn taking a fairly long time. SELECT * FROM sys.availability_databases_cluster adc INNER JOIN&nbs… Continue reading What really happens when HADR_CLUSAPI_CALL wait type is set?
First published on MSDN on Dec 07, 2017 Customer was receiving the following error:
Msg 8169, Level 16, State 2, Line 1 Conversion failed when converting from a character string to uniqueidentifier.
Here are all the ways that you can recreate this e… Continue reading Dealing with error 8169 “Conversion failed when converting from a character string to uniqueidentifier. “
First published on MSDN on Dec 07, 2017 A customer approached us asking for help on automatic a monitoring process. The goal was to send some type of notification when a particular threshold was reached. He had already discovered this blog but still … Continue reading Create a monitoring and notification mechanism for HADR worker thread Pool
First published on MSDN on Jan 12, 2018 Recently, we have observed a number of cases where DBAs or application developers are complaining about out-of-memory errors or even machine not responding (hangs) despite the fact that there is plenty of … Continue reading OS Hang or Out of Memory due to SQL Ser… No Wait, it’s SQL Analysis Services (SSAS)
First published on MSDN on Dec 16, 2012 Have you wondered if there is a simple way to find out if a query is slowed down by bottlenecks? Looking at the Duration (Elapsed Time) and CPU (Worker Time) reported by a completed query can reveal the answer…. Continue reading SQL Performance Meditation: Duration and CPU Reveal a Profound Truth
“Why is this value changing unexpectedly and where or when is this occurring?!” This is a question many of us dread asking ourselves, knowing that we’ll have to do some tedious trial-and-error debugging to locate the source of this issue. For C++ developers, the exclusive solution to this problem has been the data breakpoint, a… Continue reading Break When Value Changes: Data Breakpoints for .NET Core in Visual Studio 2019