PostsCommon settingsCommon settings – Max Degree of Parallelism and Cost Threshold for ParallelismIndexesFill FactorHeaps 101Index Fragmentation (rowstore)Indexes (rowstore) 101 information: clustered, non-clustered and heapsLast page contention and primary key considerationsLocking and blockingLocks vs Latches, a short comparisonTroubleshooting blocking using sp_whoisactiveMonitoring MetricsMonitoring Metrics – AOAG specific monitoring metricsMonitoring Metrics – Page Life Expectancy (PLE) and associated metricsMonitoring Metrics – PAGEIOLATCH_XX and associated metricsSQLAntivirus and MSSQL – what to doThe BasicsTransactions basics – part 1: Transaction ModesTransactions basics – part 2: Isolation levels Share this:FacebookX