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 …
SQL Server on Linux: Scatter/Gather == Vectored I/O
Moved from: bobsql.com Scatter/gather capabilities allow more efficient memory to disk transfers reducing redundant memory copies, sorting and other activities applications may require to gain improved I/O performance. If my memory serves …
SQL Server On Linux: Core-minidumps and Breakpad
Moved from: bobsql.com As pointed out in my previous post, debugging on Linux brings a few new twists to those of us used to the Windows debugging landscape. One of these twists is the need to produce a core dump. On Linux a comm …
How It Works: SQL Server Deadlock Trace Flag 1222 Output
Moved from: bobsql.com The trace flag 1222 can be very powerful and helpful in tracking down the cause of a deadlock when used correctly. This week I was tracking down a blocking situation, which I expected the lock monitor to resolve …
SQL Server Mysteries: The Case of the Suspended, Awaiting Command, and Blocked Session
Moved from: bobsql.com I ran into a scenario showing my session as suspended, awaiting command and blocked! My first thought was that this had to a bug. As many of us have documented, for years, a sleeping, awaitin …
SQL Server Management Studio Provides–“XE Profiler”
Moved from: bobsql.com Bob Ward and I worked with our SQL Server Tool developers (thanks David) to enable ‘Quick XE Trace’ capabilities. The feature is available in the latest SQL Server Management Studio (SSMS) releas …
How It Works: SQL Server DTC (MSDTC and XA Transactions)
Moved from: bobsql.com I have found the term DTC is used in many ways so for the purposes of the discussion here are a few terms. When talking DTC, I am talking about the feature set, MSDTC as the OLE-TX implementation and XA for the X/Ope …
SQL Server on Linux: Kerberos Troubleshooting, Hints and Tips and Hard Code Debugging
Moved from: bobsql.com SQL Server on Linux uses the GSSAPI and SSSD service for Active Directory (AD) authentication activities. Thus, Kerberos is the path for success for AD authentication and just in case you ha …
SQL Server on Linux: CU4 – NewSequentialId() – Uuid
Moved from: bobsql.com Prior to SQL Server 2017 CU4 for Linux (Linux only) the generation of a sequential UUID may not function as expected. SQL Server’s NewSequentialId() calls the Windows API UuidCreateSequentia …