Opinions, tips, and news orbiting Microsoft
First published on MSDN on Dec 06, 2012
This SQL Meditation contemplates on some common reasons why INSERT statements are taking a long time (slow)
1. Each Insert in a large batch is causing a log flush … Continue reading Meditation: Slow Inserts in SQL Server
First published on MSDN on Dec 10, 2012
“Waits” in SQL Server are often a major source of performance issues. “Waits” as they are known in the SQL Server world essentially indicate that a worker thread inside SQL Server is waiting for a resource to … Continue reading “Waits, Waits, Do Tell Me”* – how to analyze bottlenecks in SQL Server
First published on MSDN on Dec 11, 2012 Question : “If one executes stored procedures using the RPC events mechanism (instead of Language events ), do any additional RPC ports need to be open (as is the case with SSIS )? Configuring the Windows Fir… Continue reading SQL RPC vs. Windows RPC
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