Does SQL Server 2016 Require Trace Flag -T8048?
Moved from: bobsql.com Various changes from automatic soft NUMA to CMemThread partitioning have muddied the water around the trace flag –T8048 messaging. Prior to SQL Server 2016 the trace flag –T8048 is used to upgrade (only) …
The path forward for SQL Server analytics
Today, we are announcing changes to SQL Server analytics which includes:Customer feedbackRetirement of SQL Server 2019 Big Data ClustersRetirement of PolyBase scale-out groupsPath forwardCustomer feedbackWe continue to see increased migration to the cl …
How it Works: XEL Health Session and Shutdown
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 …
DBCC Trace Flags 2562 and 2549
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 …
How It Works: Reader / Writer Synchronization
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 …
How It Works: Session/SPID (–2) for DTC Transactions
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 t …
COLD, WARM, HOT … CLEAN, DIRTY, FREE … What Does All This Mean?
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 …
How It Works: Sync IOs in nonpreemptive mode longer than 1000 ms
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 …
Create Table – Disk vs In-Memory Optimized
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 …
How It Works: How is SQL Server Error 833, 15 Sec I/O Detected
Moved from: bobsql.com I was approached to revisit the details of how Error Message 833 is detected and reported. SQL Server has encountered %d occurrence(s) of I/O requests taking longer than %d seconds to complete on file [%ls] in datab …
How It Works: BULK INSERT (BCP) TDS Traffic
Moved from: bobsql.com Yesterday I had a discussion with a customer and realized that the BCP, TDS pattern could use a bit of documentation. Customer Scenario/Question: I am using BCP.exe to import a large data set. BCP.e …
How It Works (It Just Runs Faster): Non-Volatile Memory SQL Server Tail Of Log Caching on NVDIMM
Moved from: bobsql.com Note: We received feedback that there was some confusion on us calling this functionality “tail of the log caching” because our documentation and prior history has referred to the tail of the log as the portion …
SQL Server on Linux: ELF and PE Images Just Work
Moved from: bobsql.com Last March I moved from 22 years in SQL Server support to the SQL Server development team, working on SQL Server on Linux project and reporting to Slava Oks. As Slava highlights in his recent blog post, he also …
SQL Server on Linux: Debugging ELF and PE Images (dbgbridge)
Moved from: bobsql.com In my last post I highlighted the marriage of PE and ELF images within the same process space to build SQL Server on Linux. In this post I will expand upon the dbgbridge component, as mentioned by Slav …
SQL Server on Linux: An LLDB Debugging Tale
Moved from: bobsql.com You are aware of our statements indicating “Microsoft Loves Linux.” Over the last couple of years the open source activities at Microsoft have accelerated all around me. Recently I blogged about the …