Production Database Administration

Home
Production Database Administration

SQL Server Inventory Checklist

May 15, 2009

Richard Jones, a DBA in the UK, asked in with a question, and rather than giving my own opinion, I thought it’d be better to ask it here to get everybody’s opinion in the comments: The DB team that I am a member of are about to take control of a number of SQL Server…

SQL Server Perfmon (Performance Monitor) Best Practices

December 30, 2006

Brent Ozar

Monitoring, SQL Server

Database administrators need to know each SQL Server’s weakest link so we know where to focus their hardware budgets and time. On any given server, we need to know what the slowest component is, and where it’ll pay off to invest hours and dollars. This is performance tuning, and the first place to start is…