A customer’s InMemory OLTP tables ran slowly because of a very low hash bucket count. Here is the hash collisions performance overhead and how to avoid it.
SQL SERVER – Identify Table Where Clustered Index is Not a Primary Key – DMV
Let us first see script which will return us tablename with schema where clustered index is not a primary key.
SQL SERVER – ShowPlan XML Additions for ColumnStore Indexes
How can you tell if a query used a columnstore index and batch processing? Here are the properties SQL Server adds to the ShowPlan XML for ColumnStore indexes.
SQL SERVER InMemory OLTP: Understanding Optimistic Multi-Version Concurrency Concepts
A reader asked what Optimistic Multi-Version Concurrency in InMemory OLTP really means. It sounds simple but is a loaded question, so here is a plain answer.
SQL SERVER – Performance counter missing! DMV sys.dm_os_performance_counters is Empty
Performance counters missing? Here is why sys.dm_os_performance_counters can return no rows and how to bring the counters back.
A Performance Counter Baseline Saved to a Table Every 15 Minutes
Save a performance counter baseline every 15 minutes, calculate interval rates, detect resets, and compare a defined week with last month.
SQL Server 2016 – Enhancements with TempDB
SQL Server 2016 makes TempDB more scalable out of the box. Here are the enhancements with TempDB, from setup options to less contention under load.