In-Memory OLTP stores selected tables in memory and uses row versions instead of locks. This post builds a small demo database, compares a disk table with two memory-optimized tables, and tests a natively compiled procedure. It also covers durability, bucket counts and memory use.
SQL SERVER – SSMS: Top Object and Batch Execution Statistics Reports
Just like sports stats, SSMS has head-to-head numbers for your server. Here is a tour of the Top Object and Batch Execution Statistics Reports.
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.
SQL SERVER – SSMS: Top Transaction Reports
A story about my daughter’s school drawing contest leads into the Top Transaction reports in SSMS and what they tell you about your server.
SQL SERVER – SSMS: Transaction Log Shipping Status Report
Like timber floating downstream, log shipping moves logs from one server to another. Here is how to read the Transaction Log Shipping Status report in SSMS.
Top Resource Consumers in Query Store
Top resource consumers in Query Store show CPU, duration, and reads by query and plan, so tuning starts with workload impact.
SQL SERVER – Activity Reports – Dormant Sessions
A parent-teacher meeting tells me more than a report card. In the same way, the SSMS activity report on Dormant Sessions shows idle connections on your server.