Monitoring Free Space for SQL Server In-Memory Checkpoint Files
In this tip we cover why and how you should monitor free space for SQL Server in-memory checkpoint files.
Robert L Davis is a Microsoft Certified Master in SQL Server and a Data Platform MVP. He is a Senior SQL Server Developer by day who spends his time performance tuning queries and fine tuning the SQL architecture for performance at Global Relay. He is passionate about disaster recovery, availability, performance tuning, and security. He is co-leader of the PASS Security Virtual Chapter. He founded SQL Server Best Practices website www.sqlbp.com and blogs at www.SQLSoldier.com.
Find SQL Server Query Plans with Scans on Nonclustered Hash Indexes
Hash indexes, used for SQL Server in-memory OLTP, are not ordered by the index keys and scans on hash indexes can significantly hinder performance. In this tip we will look at how to find these issues and also walk through an example.