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 …
SQL Server 2017 Improved Resource Usage On Smaller Machines
Moved from: bobsql.com What does improving resource usage on smaller machines really mean? https://support.microsoft.com/en-us/help/4078095 SQL Server is designed to scale across the spectrum of small machines to enterprise class servers. …
SQL Server on Linux: Why Do I Have Two SQL Server Processes?
Moved from: bobsql.com When starting SQL Server on Linux why are there two (2) sqlservr processes? systemctl status mssql-servermssql-server.service – Microsoft SQL Server Database Engine… CGroup: /system.slice/ms …
SQL Server on Linux: How is Delete-On-Close Handled
Moved from: bobsql.com Windows provides an option for CreateFile to delete a file when the file is closed (FILE_FLAG_DELETE_ON_CLOSE.) Host Extension Handling Linux does not expose such an option as part of the …
SQL Server Mysteries: The Case of the Dropped AD Group Login
Moved from: bobsql.com Dylan (who kindly wrote up the contents of this blog for me) was modifying the tests for Active Directory Login activities. As Dylan and I reviewed the changes a specific behavior involving Active Directory Group Log …
SQL MYSTERIES: Tracing BCP Might Fool You
Moved from bobsql.com Today I was tracking a large BCP.exe ‘IN’ operation and monitoring the sys.dm_exec_requests entries. The ‘BULK INSERT’ command entry appeared, showing the CPU, reads, writes, … …
SQL Server Instant File Initialization: SetFileValidData (Windows) vs fallocate (Linux
Moved from: bobsql.com SQL Server Books Online documents Instant File Initialization and the associated security considerations. This blog highlights the underlying file system implementations and differences in behavior be …
SQL Server On Linux: Forced Unit Access (Fua) Internals
Moved from: bobsql.com Overview SQL Server relies on Forced-Unit-Access (Fua) I/O subsystem capabilities to provide data durability, detailed in the following documents: SQL Server 2000 I/O Basic and SQL Server I/O Basics, Chapter 2 …
SQL Server Linux: fsync and Buffered I/O
Moved from: bobsql.com I was asked to validate the SQL Server behavior in light of the error condition involving fsync/fdatasync outlined in this article. An example of the error: The application does …
SQL Server Linux: Directory fsync Activities
Moved from: bobsql.com When Creating, Renaming or Deleting (remove/unlinking) a file, Linux requires the direct parent directory to be synchronized. As documented in the manpage for fsync core changes to the directory require the …
Viewing and Sorting XEvents Efficiently (Code Samples) – XEProfiler
Moved from: bobsql.com I was doing backups and clean-ups and ran across a couple of sample projects for XEvent and event_sequence processing I thought others might find helpful. – Enjoy! The sample code is provided “ …
SQL Server Log Writer Workers
Moved from: bobsql.com SQL Server 2017 leverages up to 4 log writer workers, on hidden schedulers, to assist in transaction log processing activities. You may find the number of log write workers has been increased to 8 when running …
SQL Mysteries: Causality tracking vs Event Sequence for XEvent Sessions
Moved from: bobsql.com You need to make sure to order the events by event_sequence when doing analytics on the XEvent data. It has been proposed to me that you can use the causality tracking sequence as a sort target, which may work as long as y …
Released: SCOM Management Pack for SQL Server (7.0.36.0)
An update to SQL Server Management Pack is available (7.0.36.0). You can download the MP from the link below. Download Microsoft System Center Management Pack for SQL Server from Official Microsoft Download Cen… What’s New U …
SQL Server on IoT Edge and Developer Machines – Smaller Footprint
Moved from: bobsql.com SQL Server will ship Azure SQL Database Edge:https://azure.microsoft.com/en-us/services/sql-database-edge With the announcement I can tell you more about one of the things we have been working on; SQL Server running on IoT …