Production Database Administration

Home
Production Database Administration

Even Simple Changes Can Cause Trouble: A Tale of TempDb

August 24, 2011

I recently presented to the Salem Oregon SQL Server user group. During my visit I heard an interesting story: once upon a time in a land not so far way, a high severity production incident was caused by adding an additional data file to the tempdb database. Multiple Tempdb Data Files: Commonly Recommended Each quadrant of…

Lemme borrow your car to get tacos - yeah, of course I'm a good driver.

T-SQL Tuesday: Why Do You Need DBA Skills?

November 2, 2010

Brent Ozar

Production Database Administration

#tsql2sday, t-sql tuesday

This month’s T-SQL Tuesday topic asks why you need DBA skills. Lemme borrow your car to get tacos – yeah, of course I’m a good driver. I say you probably don’t. Every now and then, you just need someone else to have good DBA skills. Most of my clients don’t have full time database administrators. …

Overdriving Your Headlights

September 25, 2009

Brent Ozar

Monitoring, Wait Stats

The strength of your car’s headlights, the speed of your reactions, and the power of your brakes determine how fast you can drive safely at night. Likewise, in SQL Server, we need to see down the road before disaster strikes, and react as quickly as possible.

Stop Shrinking Your Database Files. Seriously. Now.

August 19, 2009

Brent Ozar

Production Database Administration

298

I had sworn to myself that if I saw one more helpful article about how to shrink your SQL Server database files with DBCC SHRINKFILE or how to back up your log with TRUNCATE_ONLY, I was going to write a rant about it. Epic Advice Fail SQL Server Magazine just tweeted about their latest article,…

The Ozar Family Tradition of Performance Monitoring

July 23, 2009

Brent Ozar

Monitoring, Wait Stats

When my Grandpa Ozar wanted to find out if his 10 megabyte 5.25″ hard drive was responding fast enough to handle his database loads, he monitored the Perfmon counter Physical Disk: Disk Queue Length.

Things have changed since Grandpa’s time, though, and now it’s time to learn a new performance tuning trick – SQL Server waits.

SQL Server Inventory Checklist

May 15, 2009

Brent Ozar

Production Database Administration

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…