Review cost threshold for parallelism with MAXDOP, inspect NUMA layout and settings, then measure plans and waits after changes.
Default Filegroup: Sending New Tables Away From PRIMARY
Changing the default filegroup only affects tables you create later. Here is what moves, what does not, and how a script can quietly ignore the rule.
mssql-conf: Configuring SQL Server on Linux Without a GUI
Use mssql-conf for SQL Server on Linux memory, file defaults, Agent, ports, and trace flags, then verify effective settings after restart.
Target Server Memory vs Total: Is SQL Server Still Growing
A big gap between target and total memory is often just room to grow. Here is how to check it before you call a server starved.
MSDTC and Distributed Transactions Across Linked Servers
Understand MSDTC for linked-server transactions, inspect RPC promotion settings, diagnose coordination errors, and compare simpler designs.
Finding Databases With Auto Shrink or Auto Close Turned On
Find auto shrink and auto close settings, generate reviewed correction commands, inspect model, and check the effects of prior shrink work.
Query Store Capture Modes: ALL, AUTO and CUSTOM
Choose a Query Store capture mode for your workload, inspect ALL, AUTO, CUSTOM and NONE, and tune thresholds without losing useful history.