How It Works: SQL Server Lock Partitioning
Moved from: bobsql.com Previous posts have discussed partitioning, for example, a partitioned memory object https://blogs.msdn.microsoft.com/psssql/2011/09/01/sql-server-20082008-r2-on-newer-machines-with-more-than-8-cpus-presented-per-numa-node-m …
How It Works: SQL Server LOGIN_STATS (sys.dm_exec_sessions)
Moved from: bobsql.com To track the login statistical information, enable the sp_configure value ‘common criteria compliance enabled‘ setting and restart SQL Server. The sys.dm_exec_sessions DMV is one way to query the st …
How It Works: SQL Server Lock Iteration / Enumeration
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 …
SQL Mysteries: Why is my SQL Server experiencing lots of 17830 (TCP 10054) errors?
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 …
SQL Server: OS Error 665 (File System Limitation) and Linux
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 …
SQL Server 2019 Many No Longer Capture Mini-Dump (SQLDump####.mdmp)
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 …
Using SQLBCP Native/Format File vs Text File and the BOM
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 …
SQL Server I/O Basics Chapter #1
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 custome …
SQL Server I/O Basics Chapter #2
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 doc …
OLE DB Driver 19.0 for SQL Server Released
Version 19.0 of the Microsoft OLE DB Driver for SQL Server has been released. Version 19.0 includes changes and new features that improve security in the driver. Features Support for TDS 8.0 Support for the Host Name In Certificate con …
ODBC Driver 18.0 for SQL Server Released
Version 18.0 of the Microsoft ODBC Driver 18 for SQL Server has been released. Version 18.0 brings several changes, new features, and fixes to the driver. Features Added compatibility with OpenSSL 3.0 Ability to send long types as max types …
Meet us at SQLBits 2022 and level up as a data professional
It has been over two years since we have had the opportunity to meet face-to-face with our data community at a large event and we miss it. From hallway conversations to the energy that comes from solving problems and helping people understand complex c …
フェールオーバークラスターマネージャーでSQL Server Always On 可用性グループのリソースを操作する際の注意事項
こんにちは、 SQL Server サポートチームです。 本記事では SQL Server Always On 可用 …
Using SQL Server’s SNITrace to Troubleshoot Networking Issues
Moved from: bobsql.com SNITrace, formally BIDTrace, is an deeper level of tracing for the Microsoft SQL Server TDS consumers and providers. Terms and Brief History Before I dive into the details here is a brief history and related termino …
SQL Server BDC Hints and Tips: The node’s Journal can be your best friend
Move from: bobsql.com If you are new to Kubernetes (K8’s), like I am, you quickly learn that the servicing node’s journal holds a wealth of information. In the lab I was encountering evictions due to memory, disk space and other reso …