Opinions, tips, and news orbiting Microsoft
Moved from: bobsql.com
There are a variety of posts talking about the black box recorder (XEL Health Session) explaining what the recorder is and does: https://blogs.msdn.microsoft.com/psssql/2012/03/08/sql-server-2012-true-black-box-record… Continue reading How it Works: XEL Health Session and Shutdown
Moved from: bobsql.com
Erin Stellato and Jonathan Kehayias from sqlskills reached out asking for clarification of trace flags 2562 and 2549 behavior. Trace flags 2562 and 2549 are documented in knowledgebase article: https://support.m… Continue reading DBCC Trace Flags 2562 and 2549
Moved from: bobsql.com
This post is not about a specific SQL Server object but instead outlines a technique used in various locations to reduce contention while still providing thread synchronization. There are hundreds of locations throug… Continue reading How It Works: Reader / Writer Synchronization
Moved from: bobsql.com
I have written on this subject before but it seems to come up from time to time, as it did again this week. The Session (SPID) = –2 is just a place holder used by SQL Server to indicate that the DTC transac… Continue reading How It Works: Session/SPID (–2) for DTC Transactions
Moved from: bobsql.com
I was asked about these terms from a blog reader. As I thought about these terms and how to blog about them I became concerned that I might just be as clear as mud, but I will do my best.
Each of the terms mea… Continue reading COLD, WARM, HOT … CLEAN, DIRTY, FREE … What Does All This Mean?
We often receive service requests where our customers asked about how to improve/measure the connection between my application and Azure SQL Database and/or Azure SQL Managed Instance, in this new post, I would like to share with you some of them. … Continue reading Lesson Learned #187: How to measure the connection latency in Azure SQL DB/Managed Instance
Moved from: bobsql.com
Have you encountered the following in your SQL Server error log?
Long Sync IO: Scheduler 95 had 1 Sync IOs in nonpreemptive mode longer than 1000 ms
There are two general types … Continue reading How It Works: Sync IOs in nonpreemptive mode longer than 1000 ms
Moved from: bobsql.com
I had an interesting e-mail discussion related to the performance of create table. The test being executed was a tight loop of create table statements. The assumption put forth was in-memory optimized table cre… Continue reading Create Table – Disk vs In-Memory Optimized