Recently I received an email from user that he tried to search for solution on SQLAuthority.com for how to enable lock pages in memory but could not find a solution for it.
Grouping by query_hash to Find Cheap Queries That Cost the Most
Group cached statements by query_hash to find high total CPU and reads, compare plan hashes, and account for missing cache history.
Finding Which Indexes Use a Custom Fill Factor Setting
Find indexes with a custom fill factor, compare their page counts, and review one rebuild without changing the server-wide setting.
SQL SERVER – sp_readrequest – Long Running Process
sp_readrequest kept showing up as a long running procedure. It is Database Mail waiting on its queue with a 600 second timeout, usually nothing to worry about.
SQL SERVER – Troubleshooting: When Database Creation Takes Long Time
Is database creation taking a long time? Start with the size of the model database. Simple troubleshooting steps for a slow CREATE DATABASE.
SQL SERVER – TDE Effects on TempDB’s Slow Performance
A client had slow performance out of nowhere. The cause was TDE effects on TempDB after someone tested encryption on production. Here is what I learned.
SQL SERVER – CLONEDATABASE: Generate Statistics and Schema Only Copy of the Database
Use DBCC CLONEDATABASE to generate statistics and schema copies, choose clone options, and diagnose plans without copying table data.