Improve or create more Best Practices Rules: loaded modules, spinlocks, optimizer timeout, deadlock TF, trace warning, huge grant

microsoft / SqlNexus

SQL Nexus is a tool that helps you identify the root cause of SQL Server performance issues. It loads and analyzes performance data collected by SQL LogScout, SQLDiag or PSSDiag. It can dramatically reduce the amount of time you spend manually analyzing data.

MIT License

348 stars 99 forks source link

Improve or create more Best Practices Rules: loaded modules, spinlocks, optimizer timeout, deadlock TF, trace warning, huge grant #215

Closed PiJoCoder closed 1 year ago

PiJoCoder commented 1 year ago

usp_HugeGrant usp_ExcessiveTrace_Warning usp_WarnmissingIndex usp_DeadlockTraceFlag usp_OptimizerTimeout usp_Spinlock_HighCPU usp_NonMS_LoadedModules

PiJoCoder commented 1 year ago

Also this commit bffaf12d28df1665f1cf6031f92cda161424f810

PiJoCoder commented 1 year ago