SQL Server on Linux: How is Delete-On-Close HandledMoved from: bobsql.com Windows provides an option for CreateFile to delete a file when the file is closed (FILE_FLAG_DELETE_ON_CLOSE.) […] 22 février 2022 dans Sites Microsoft par MS Tech Community
SQL Server Mysteries: The Case of the Dropped AD Group ...Moved from: bobsql.com Dylan (who kindly wrote up the contents of this blog for me) was modifying […] 22 février 2022 dans Sites Microsoft par MS Tech Community
SQL MYSTERIES: Tracing BCP Might Fool YouMoved from bobsql.com Today I was tracking a large BCP.exe ‘IN’ operation and monitoring the sys.dm_exec_requests entries. The ‘BULK […] 22 février 2022 dans Sites Microsoft par MS Tech Community
SQL Server Instant File Initialization: SetFileValidData (Windows) vs fallocate (LinuxMoved from: bobsql.com SQL Server Books Online documents Instant File Initialization and the associated security considerations. This blog highlights […] 22 février 2022 dans Sites Microsoft par MS Tech Community
SQL Server On Linux: Forced Unit Access (Fua) InternalsMoved from: bobsql.com Overview SQL Server relies on Forced-Unit-Access (Fua) I/O subsystem capabilities to provide data durability, detailed […] 22 février 2022 dans Sites Microsoft par MS Tech Community
SQL Server Linux: fsync and Buffered I/OMoved from: bobsql.com I was asked to validate the SQL Server behavior in light of the error condition […] 22 février 2022 dans Sites Microsoft par MS Tech Community
SQL Server Linux: Directory fsync ActivitiesMoved from: bobsql.com When Creating, Renaming or Deleting (remove/unlinking) a file, Linux requires the direct parent directory […] 22 février 2022 dans Sites Microsoft par MS Tech Community
Viewing and Sorting XEvents Efficiently (Code Samples) – XEProfilerMoved from: bobsql.com I was doing backups and clean-ups and ran across a couple of sample projects […] 22 février 2022 dans Sites Microsoft par MS Tech Community
SQL Server Log Writer WorkersMoved from: bobsql.com SQL Server 2017 leverages up to 4 log writer workers, on hidden schedulers, to […] 22 février 2022 dans Sites Microsoft par MS Tech Community
SQL Mysteries: Causality tracking vs Event Sequence for XEvent SessionsMoved from: bobsql.com You need to make sure to order the events by event_sequence when doing analytics […] 22 février 2022 dans Sites Microsoft par MS Tech Community
Meme Week: Queue in the DatabaseWhen you have a hammer, everything looks like a nail. Unfortunately, a lot of people don’t even know […] 22 février 2022 dans Sites anglophones étiqueté Architecture par brentozar.com
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 […] 22 février 2022 dans Sites Microsoft par MS Tech Community