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 …
SQL Server BDC Hints and Tips: TEMPDB Disk Usage
Move from: bobsql.com I was troubleshooting a master-0 pod eviction due to disk pressure. The pod was shutdown Ephemeral spa …
SQL Server BDC Hints and Tips: Changing Grafana/Kibana Display Time Zone
Moved from: bobsql.com The Grafana and Kibana interfaces default to the local browser time zone on a SQL Server BDC cluster. Some of my machines are in the PST time zone and others the CST time zone and I find myself doing math cali …
SQL Server dbcc clonedatabase - Gotch
Moved from: bobsql.com The dbcc clonedatabase is a handy command to clone metadata and information such as query disk store. Then …
SQL Server BDC Hints and Tips: VDI Seeding for High Availability
Moved from: bobsql.com A high availability SQL Server BDC uses the Virtual Device Interface (VDI) to seed databases to secondary replicas. (https://docs.microsoft.com/en-us/sql/big-data-cluster/ deployment-high-availability? …
SQL Server BDC Hints and Tips: Contained AGs, Ports, containedag_msdb, logs, …
Moved from: bobsql.com This blog post focuses on connecting to the SQL Server BDC, some helpful log files and utility outputs. Understanding a few basics about a SQL Server BDC and the Contained Availability Group (containedag) make …
How It Works: TSQL TRY/CATCH Behavior Fooled Me
Move from: bobsql.com If I would have simply read the documentation (https://docs.microsoft.com/en-us/sql/t-sql/language-elements/try-catch-transact-sql?view=sql-server-ver15) the answer to my problem is answered. Create the following pro …
SQL Server On Linux: Logger.ini Size and Rollover Additions to SQL Server 2019 CU4
Moved from: bobsql.com I can’t take credit for this post as Dylan added the code and provided the write-up to share with you. All I did was a bit of editing and proof reading, enjoy. For SQL Server on Linux, there are a …
How It Works: SQL Server Locking WAIT_WITH_LOW_PRIORITY
Move from: bobsql.com I received a question from Jonathan as he read over prior posts on locking and I cannot take credit for the question nor the answer, just being the middle man for this transaction. Question: “The wa …
How It Works: Bulk Insert (BCP.exe) – Injecting a Sort Operation
Move from: bobsql.com The customer reported that they could not BCP into a table using “keepidentity” and after more debugging I found that “keepidentity” was not the issue but the issue was the addition of a clustered in …
SQL Mysteries: Why am I Still Seeing 17830 Errors?
Moved from: bobsql.com I was recently contacted by Christophe Laporte posing a very interesting question. « This is about the blog post you published a while ago, but I’ have questions regarding the error which is firing an XEvent al …
HOW IT WORKS: SQL Server Scheduler Affinity
Moved from: bobsql.com SQL Server uses 3 types of affinity to control where the SQL Server worker threads execute. Before explaining the different scheduler affinity types let me clarify some terminology. Node Types SQL Server makes …
How It Works: SQL Server Stack Trace – COMDAT Elimination
Moved from: bobsql.com Starting with SQL Server 2019, SQL Server is built with the COMDAT, ICF linker option enabled, reducing size/space usage. …
How It Works: XEvent String Comparison Performance Tip
Moved from: bobsql.com I ran across a check in the XEvent string comparison logic which can b …