Opinions, tips, and news orbiting Microsoft
Moved from: bobsql.com
When executing a query to enumerate the locks, such as select * from sys.dm_tran_locks, how does SQL Server scan the locks and avoid impacting the overall concurrency?
I recently posted on aspects of the SQL Server Lock Ma… Continue reading How It Works: SQL Server Lock Iteration / Enumeration
Moved from: bobsql.com
I was reviewing a test run this week that had more SQL 17830 (TCP 10054 / 0x2746) errors than I could explain from just kills or login timeouts.
I started looking at the output in the connectivity ring buffer and th… Continue reading SQL Mysteries: Why is my SQL Server experiencing lots of 17830 (TCP 10054) errors?
Moved from: bobsql.com
I have previously tested and blogged about the NTFS, sparse, file system limitation error 665: https://blogs.msdn.microsoft.com/psssql/2015/06/10/operating-system-error-665-file-system-limitation-not-just-for-dbcc-any… Continue reading SQL Server: OS Error 665 (File System Limitation) and Linux
Moved from: bobsql.com
I was looking at a SQL Server which had generated ten(10) SQLDump####.txt files but only a single(1) SQLDump####.mdmp file. We introduced a new feature in SQL Server 2019 to save disk space for mini/crash dumps which… Continue reading SQL Server 2019 Many No Longer Capture Mini-Dump (SQLDump####.mdmp)
Moved from: bobsql.com
SQL Server Bulk Copy operations (BCP.exe, OpenRowset BULK, …) have specific abilities depending on the data file format specified.
Native (-n) or Format (-f) Files
The data file storage is binary allowing cha… Continue reading Using SQLBCP Native/Format File vs Text File and the BOM
Moved from: bobsql.com
Introduction
Because new devices and storage solutions continue to appear in the marketplace, the environments in which Microsoft® SQL Server™ runs have become extremely diverse. To ensure data integrity for our customers who are… Continue reading SQL Server I/O Basics Chapter #1
Move from: bobsql.com
Introduction
Microsoft® SQL Server™ 2005 continues to innovate and extend I/O performance and reliability. With new innovations come new terms, designs, and algorithms.
The SQL Server 2000 I/O Basics document is a… Continue reading SQL Server I/O Basics Chapter #2
Final Update: Monday, 21 February 2022 14:42 UTCWe’ve confirmed that all systems are back to normal with no customer impact as of 02/21, 14:30 UTC. Our logs show the incident started on 02/21, 12:50 UTC and that during the 1 hours and 40 Minutes that i… Continue reading Experiencing Data Latency issue in Azure Portal for Many Data Types – 02/21 – Resolved