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 Performance Stack: Look Beyond the Query
Tuned every query and SQL Server is still slow? David Klee looks at the SQL Server performance stack, from storage and virtualization to the network. He also explains why a baseline matters.
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.