How did Notes from the Field start? Here is the story behind the series and a roundup of the 2013 episodes on performance tuning and database health.
SQL SERVER – Overall SQL Server Performance – Not Just Query Performance – Notes from the Field #008
Tuned every query and SQL Server is still slow? David Klee shows a systematic way to improve overall SQL Server performance, not just query performance.
SQL SERVER – SQL Server Alerts and How to Use Them – Notes from the Field #007
Want to know about a problem before your users do? Mike Walsh explains SQL Server alerts, why they matter for server health and how to use them.
SQL SERVER – Optimal Memory Settings for SQL Server – Notes from the Field #006
No amount of memory is ever enough. Tim Radney explains the optimal memory settings for SQL Server, the setting people most often miss on a new server.
SQL SERVER – Finding Frequently Running Query and Elapsed Time – Notes from the Field #005
When the server is slow, first see what is running. Brian Kelley shows how to find a frequently running query and its elapsed time, two key facts for tuning.
SQL SERVER – SQL Server Configuration Checking – A Must Do for Every DBA – Notes from the Field #004
Still running on default settings? Mike Walsh explains why configuration checking is a must do for every DBA and how to fit SQL Server to your business.
SQL SERVER – vCPUs – How Many Are Too Many CPU for SQL Server Virtualization ? – Notes from the Field #003
Do not blame virtualization for slow servers. David Klee explains how many vCPUs are too many for SQL Server virtualization and how to set them up right.