Database Server Health Check

Josh Berkus (PostgreSQL Experts, Inc.)
Databases
Location: Portland 252
Please note: to attend, your registration must include Tutorials.
Average rating: ***..
(3.75, 8 ratings)

Just as regular doctor’s checkups help spot disease and chronic health problems in people before they become acute, a “health check” of your database servers will uncover and sometimes prevent database server problems before your website goes down. Vetran database server medic Josh Berkus will go through the various steps his company normally takes to make sure customer database servers are “healthy”.

A regular health check generally includes:
  • Configuration checkup
  • Hardware checkup
  • Resource usage checkup
  • OS Checkup
  • Application checkup
  • Slow query checkup

While the examples and demos in the tutorial will focus on PostgreSQL, they should be applicable to other DBMSes.

Photo of Josh Berkus

Josh Berkus

PostgreSQL Experts, Inc.

Josh Berkus is primarily known as one of the Core Team of the world-spanning open source database project PostgreSQL. As CEO of PostgreSQL Experts, Inc., he speaks on database and open source topics all over the world, and consults on database design, performance, and open source community building. He also makes pottery and is a darned good cook.

Comments on this page are now closed.

Comments

Picture of Shengqiong Hu
Shengqiong Hu
07/30/2010 2:59pm PDT

Is there any ppt or pdf?

Picture of Tarus Balog
Tarus Balog
07/21/2010 7:52am PDT

I enjoyed this tutorial. Since our product relies on a database it was great to get some understanding of the tools available to insure it was running optimally.

Picture of Ken Eshelby
Ken Eshelby
07/20/2010 9:17am PDT

Very good overview. I am an app admin/reluctant developer (opennms) and took a bunch of great approaches away for tuning my deployed db to match the app’s needs. I’m curious why so many low ratings?

  • Intel
  • Microsoft
  • Google
  • Facebook
  • Rackspace Hosting
  • (mt) Media Temple, Inc.
  • ActiveState
  • CommonPlaces
  • DB Relay
  • FireHost
  • GoDaddy
  • HP
  • HTSQL by Prometheus Research
  • Impetus Technologies Inc.
  • Infobright, Inc
  • JasperSoft
  • Kaltura
  • Marvell
  • Mashery
  • NorthScale, Inc.
  • Open Invention Network
  • OpSource
  • Oracle
  • Parallels
  • PayPal
  • Percona
  • Qualcomm Innovation Center, Inc.
  • Rhomobile
  • Schooner Information Technology
  • Silicon Mechanics
  • SourceGear
  • Symbian
  • VoltDB
  • WSO2
  • Linux Pro Magazine

Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact Sharon Cordesse at scordesse@oreilly.com

Download the OSCON Sponsor/Exhibitor Prospectus

Media Partner Opportunities

Download the Media & Promotional Partner Brochure (PDF) for information on trade opportunities with O'Reilly conferences or contact mediapartners@ oreilly.com

Press and Media

For media-related inquiries, contact Maureen Jennings at maureen@oreilly.com

OSCON Newsletter

To stay abreast of conference news and to receive email notification when registration opens, please sign up for the OSCON Newsletter (login required)

OSCON 2.0 Ideas

Have an idea for OSCON to share? oscon-idea@oreilly.com

Contact Us

View a complete list of OSCON contacts