SQL Server NUMA

SQL Server NUMA (Non-Uniform Memory Access)

資料庫連線暫時性問題(暫時性錯誤)與Retry機制

 資料庫連線暫時性問題(暫時性錯誤)與Retry機制

偶爾出現的問題(暫時性錯誤)，可能是網路短暫的通訊問題，建議在程式端先設計retry機制來自動解決，避免花費大量時間調查原因

1. 在程式端設計retry機制來自動解決此問題 (建議)

相較於在SQL query設計retry機制，在程式端設計retry比較好控制處理流程

 Retry寫法可以參考以下連結

針對 SQL Database 和 SQL 受控執行個體中的暫時性連接錯誤進行疑難排解

https://docs.microsoft.com/zh-tw/azure/azure-sql/database/troubleshoot-common-connectivity-issues

 

2. 在SQL query設計retry機制 (比較不建議)

開發改寫比較複雜，疑難排解也比較困難

TRY...CATCH (Transact-SQL)

https://docs.microsoft.com/zh-tw/sql/t-sql/language-elements/try-catch-transact-sql?view=sql-server-ver15

https://www.mssqltips.com/sqlservertip/3188/implementing-sql-server-transaction-retry-logic-for-failed-transactions/

Service Principal Name (SPN) 服務主體名稱

Service Principal Name (SPN) 服務主體名稱

Pssdiag

 

Pssdiag/Sqldiag Manager

https://github.com/microsoft/DiagManager

Getting Started

https://github.com/Microsoft/DiagManager/wiki/Getting-Started

Step by Step tasks

1. Installation of pssdiag/sqldiag manager
2. Creating a pssdiag package
3. [Running Pssdiag an SQL Server instance](Running PSSDiag)
4. [Running pssdiag on a cluster](Running Pssdiag on a Cluster)
5. [Creating your own custom collectors](Custom collector)
6. Frequently Asked Questions

Reference:

SQL Server: How to Configure pssdiag utility for SQL Server 2016

https://social.technet.microsoft.com/wiki/contents/articles/51504.sql-server-how-to-configure-pssdiag-utility-for-sql-server-2016.aspx

Using PSSDiag and SQL Nexus to monitor SQL Server performance (Youtube Video) 

https://www.youtube.com/watch?v=5xo_S1nx_nA

Azure Virtual Network

Azure Virtual Network

SQL Server Learning Resources (SQL Server 學習資源) 2020

SQL Server Installation安裝