Category Archive

SQL Server

Server with a download arrow, a maintenance calendar and a padlock representing planned Windows updates

Windows Automatic Updates on SQL Server: Control Them Instead of Turning Them Off

Why default Windows Update settings are risky on SQL Server, why turning updates off is worse, how to check your...

Stacked storage drives, a database cylinder and a stopwatch, representing SQL Server disk layout and storage latency

SQL Server Disk Storage Best Practices: Layout, Formatting, File Settings and Latency

How to lay out SQL Server data, log, tempdb and backup files, format volumes with 64 KB clusters, configure storage...

SQL Server transaction log with hundreds of small virtual log files compared to a healthy log with a few evenly sized VLFs

SQL Server VLF Count: Why Too Many VLFs Hurt and How to Fix Them

What virtual log files are, why too many VLFs slow down startup, restores and replication, how to measure your VLF...

SQL Server high availability: two connected servers sharing a replicated database, with a monitoring dashboard

SQL Server High Availability Options: FCI, Availability Groups and Log Shipping Compared

Compare SQL Server high availability options (FCI, availability groups, basic AGs, log shipping and mirroring) and learn which one fits...

Padlock on a memory module with the path to disk blocked, representing Lock Pages in Memory for SQL Server

SQL Server Lock Pages in Memory: When to Enable It, How to Grant It and How to Verify It

What Lock Pages in Memory does for SQL Server, when it's worth enabling, how to grant it without losing it...

Monitor with a chart, an alert bell and a calendar, representing SQL Server monitoring routines

SQL Server Monitoring: A Daily, Weekly and Monthly DBA Checklist

What to alert on in real time and what to check daily, weekly and monthly in SQL Server, with ready...

Memory modules with a limit line next to a server, representing the SQL Server max server memory setting

SQL Server Max Server Memory: How to Calculate It, Set It and Check It

What SQL Server max server memory really limits, how to calculate a starting value, when to use min server memory...

SQL Server Agent alert firing on a database server and sending an email notification

SQL Server Alerts: Which Ones to Enable and How to Set Them Up Right

Which SQL Server Agent alerts every production server needs, a ready-to-run script for severities 17–25 and errors 823–825, the mail...

A tall stack of pages next to a small one, representing reducing logical reads in SQL Server query tuning

Why Reads Matter Most When Tuning T-SQL: Logical Reads, STATISTICS IO and Indexes

Why logical reads are the most reliable measure for T-SQL tuning, how to read STATISTICS IO output, the difference from...

Two SQL Server nodes with a failover arrow, an update symbol and a wrench representing a rolling update

Patching SQL Server and Windows on Always On: A Rolling Update Guide

How to apply SQL Server CUs and Windows updates on Always On availability groups and failover cluster instances with a...

Prev 1 … 7 8 9 10 Next