SQL Server According to Bob

Come here for knowledge about SQL Server uniquely provided by the two Bobs at Microsoft

SQL Server Log Writer Workers

SQL Server 2017 leverages up to 4 log writer workers, on hidden schedulers, to assist in transaction...

Author: RDORR Date: 02/11/2019

SQL Mysteries: SQL Server Login Timeouts – A Debugging Story

This blog takes you through the debugging journey, refreshing us on old concepts and introducing...

Author: RDORR Date: 02/10/2019

SQL Server Worker Thread Default Calculation

SQL Server 2017 introduced a small change to SQL Server’s default worker thread calculation,...

Author: RDORR Date: 02/10/2019

Viewing and Sorting XEvents Efficiently (Code Samples) - XEProfiler

I was doing backups and clean-ups and ran across a couple of sample projects for XEvent and...

Author: RDORR Date: 12/31/2018

SQL Server Linux: Directory fsync Activities

When Creating, Renaming or Deleting (remove/unlinking) a file, Linux requires the direct parent...

Author: RDORR Date: 12/18/2018

SQL Server Linux: fsync and Buffered I/O

I was asked to validate the SQL Server behavior in light of the error condition involving...

Author: RDORR Date: 12/18/2018

SQL Server On Linux: Forced Unit Access (Fua) Internals

Overview SQL Server relies on Forced-Unit-Access (Fua) I/O subsystem capabilities to provide data...

Author: RDORR Date: 12/18/2018

SQL Server Instant File Initialization: SetFileValidData (Windows) vs fallocate (Linux)

SQL Server Books Online documents Instant File Initialization and the associated security...

Author: RDORR Date: 12/10/2018

SQL MYSTERIES: Tracing BCP Might Fool You

Today I was tracking a large BCP.exe ‘IN’ operation and monitoring the sys.dm_exec_requests entries....

Author: RDORR Date: 08/07/2018

SQL Server Mysteries: The Case of the Dropped AD Group Login

Dylan (who kindly wrote up the contents of this blog for me) was modifying the tests for Active...

Author: RDORR Date: 08/03/2018

SQL Server on Linux: How is Delete-On-Close Handled

Windows provides an option for CreateFile to delete a file when the file is closed...

Author: RDORR Date: 07/31/2018

SQL Server on Linux: Why Do I Have Two SQL Server Processes

When starting SQL Server on Linux why are there two (2) sqlservr processes? systemctl status...

Author: RDORR Date: 07/18/2018

SQL Server on Linux: Quick Performance Monitoring

I have been asked several times about how to get a Performance Monitor like view on Linux. There are...

Author: RDORR Date: 05/20/2018

Take the SQL Server Mac challenge

When I graduated from college, one of the first computers I ever used was a MacIntosh. I loved the...

Author: Bob Ward (Microsoft) Date: 04/24/2018

SQL Server 2017 Improved Resource Usage On Smaller Machines

What does improving resource usage on smaller machines really mean?...

Author: RDORR Date: 03/18/2018

SQL Server on Linux: CU4 - NewSequentialId() – Uuid

Prior to SQL Server 2017 CU4 for Linux (Linux only) the generation of a sequential UUID may not...

Author: RDORR Date: 02/22/2018

Microsoft Engineering loves SQLBits

I have the blessed opportunity to speak at many customer events. SQLBits is always one of my...

Author: Bob Ward (Microsoft) Date: 02/15/2018

SQL Server on Linux: Kerberos Troubleshooting, Hints and Tips and Hard Code Debugging

SQL Server on Linux uses the GSSAPI and SSSD service for Active Directory (AD) authentication...

Author: RDORR Date: 02/05/2018

How It Works: SQL Server DTC (MSDTC and XA Transactions)

I have found the term DTC is used in many ways so for the purposes of the discussion here are a few...

Author: RDORR Date: 01/28/2018

Let's talk SQL Server to kick off the PASS Facebook Live series

I've had such a long, great history with the PASS Summit, Community, and all the great people that...

Author: Bob Ward (Microsoft) Date: 01/12/2018

SQL Server Management Studio Provides–“XE Profiler”

Bob Ward and I worked with our SQL Server Tool developers (thanks David) to enable ‘Quick XE Trace’...

Author: RDORR Date: 12/26/2017

SQL Server Linux: Distributed transactions requiring the Microsoft Distributed Transaction Coordinator service are not supported on SQL Server running on Linux. SQL Server to SQL Server distributed transactions are supported. – CLARIFIED!!!

SQL Server 2019 CTP2 SQL Server 2019 adds broad support for distributed transactions (both...

Author: RDORR Date: 12/11/2017

Experience SQL Server 2017: Start your journey here

Updated Content! Please check out these new resources for SQL Server 2017 and SQL Server on Linux...

Author: Bob Ward (Microsoft) Date: 10/26/2017

Experience SQL Server 2017: The Fast and the Furious

Please check out a new blog post I created detailing how SQL Server 2017 is Fast, Built-In. Faster...

Author: Bob Ward (Microsoft) Date: 09/27/2017

SQL Server 2017 generally available on October 2nd...

Scott Guthrie and Rohan Kumar officially made the announcement today at Ignite that SQL Server 2017...

Author: Bob Ward (Microsoft) Date: 09/25/2017

SQL Server Mysteries: The Case of the Suspended, Awaiting Command, and Blocked Session

I ran into a scenario showing my session as suspended, awaiting command and blocked! My first...

Author: RDORR Date: 06/09/2017

How It Works: SQL Server Deadlock Trace Flag 1222 Output

The trace flag 1222 can be very powerful and helpful in tracking down the cause of a deadlock when...

Author: RDORR Date: 05/23/2017

SQL Server Mysteries: The Case of the Not 100% RESTORE…

I recently visited a customer onsite and presented to them topics on SQL Server 2016. After the...

Author: Bob Ward (Microsoft) Date: 04/25/2017

SQL Server Mysteries: The Case of the Not 100% RESTORE…

I recently visited a customer onsite and presented to them topics on SQL Server 2016. After the...

Author: Bob Ward (Microsoft) Date: 04/21/2017

SQL Server On Linux: Core-minidumps and Breakpad

As pointed out in my previous post, debugging on Linux brings a few new twists to those of us used...

Author: RDORR Date: 03/27/2017

SQL Server on Linux: Scatter/Gather == Vectored I/O

Scatter/gather capabilities allow more efficient memory to disk transfers reducing redundant memory...

Author: RDORR Date: 01/31/2017

SQL Server on Linux: An LLDB Debugging Tale

You are aware of our statements indicating “Microsoft Loves Linux.” Over the last couple of years...

Author: RDORR Date: 01/29/2017

SQL Server Mysteries: The Case of TDE and Permanent Tempdb Encryption

I’m a huge Sherlock Holmes fan (I’ve read all the books, watch Elementary on CBS every week, and...

Author: Bob Ward (Microsoft) Date: 01/26/2017

SQL Server on Linux: Debugging ELF and PE Images (dbgbridge)

In my last post I highlighted the marriage of PE and ELF images within the same process space to...

Author: RDORR Date: 01/24/2017

SQL Server on Linux: ELF and PE Images Just Work

Last March I moved from 22 years in SQL Server support to the SQL Server development team, working...

Author: RDORR Date: 01/05/2017

How It Works (It Just Runs Faster): Auto Soft NUMA…

Back in June, Bob Dorr gave you the thinking behind why SQL Server 2016 It Just Runs Faster due to...

Author: Bob Ward (Microsoft) Date: 11/29/2016

How It Works (It Just Runs Faster): Non-Volatile Memory SQL Server Tail Of Log Caching on NVDIMM

Note: We received feedback that there was some confusion on us calling this functionality "tail of...

Author: RDORR Date: 11/08/2016

The SQL Server Installer Version 2: Just Install It!

Back in July, I told you about a new installation experience for SQL Server. One of our goals from...

Author: Bob Ward (Microsoft) Date: 10/03/2016

SQL Server 2016 - It Just Runs Faster: Always On Availability Groups Turbocharged

When we released Always On Availability Groups in SQL Server 2012 as a new and powerful way to...

Author: Bob Ward (Microsoft) Date: 09/26/2016

How It Works: BULK INSERT (BCP) TDS Traffic

Yesterday I had a discussion with a customer and realized that the BCP, TDS pattern could use a bit...

Author: RDORR Date: 09/16/2016

How It Works: How is SQL Server Error 833, 15 Sec I/O Detected

I was approached to revisit the details of how Error Message 833 is detected and reported. SQL...

Author: RDORR Date: 09/01/2016

Create Table – Disk vs In-Memory Optimized

I had an interesting e-mail discussion related to the performance of create table. The test being...

Author: RDORR Date: 08/23/2016

How It Works: Sync IOs in nonpreemptive mode longer than 1000 ms

Have you encountered the following in your SQL Server error log? Long Sync IO: Scheduler 95 had 1...

Author: RDORR Date: 08/17/2016

COLD, WARM, HOT … CLEAN, DIRTY, FREE … What Does All This Mean?

I was asked about these terms from a blog reader. As I thought about these terms and how to blog...

Author: RDORR Date: 08/08/2016

How It Works: Session/SPID (–2) for DTC Transactions

I have written on this subject before but it seems to come up from time to time, as it did again...

Author: RDORR Date: 08/04/2016

How It Works: Reader / Writer Synchronization

This post is not about a specific SQL Server object but instead outlines a technique used in various...

Author: RDORR Date: 07/23/2016

The SQL Server Basic Installer: Just Install It!

20+ years ago when I joined Microsoft I was handed a diskette (maybe it was two), and was told “Here...

Author: Bob Ward (Microsoft) Date: 07/13/2016

DBCC Trace Flags 2562 and 2549

Erin Stellato and Jonathan Kehayias from sqlskills reached out asking for clarification of trace...

Author: RDORR Date: 07/12/2016

How it Works: XEL Health Session and Shutdown

There are a variety of posts talking about the black box recorder (XEL Health Session) explaining...

Author: RDORR Date: 07/04/2016

What Am I Working On (RDORR): SQL Server On Linux

To some of you SQL Server On Linux is old news from various announcements made a couple of months...

Author: RDORR Date: 06/27/2016

Next>