Data centre management for database servers

19 August,2011 by Jack Vamvas

Setting up a new database server environment in a new data centre requires testing.  It’s a mix of benchmarking and stress testing .  Unless you can recreate the underlying traffic and recreate a “realistic” production environment , then it’s not strict benchmarking . The main purpose is to validate the  storage and server layer.

Another purpose is to test upgraded software and hardware.

I specify more complicated tests  if there is a requirement . In very large migrations , I take a risk based approach – which means I’ll identify a selection of database servers to test.

The basic approach I take is as follows.

1)   Establish performance baseline for servers

a)       The storage team provide IOmeter figures to DBAs.  These figures are based on an initial IO profile provided by the DBA.  The storage team should test and ensure adequate throughput is achieved. As the DBA , I’m interested in the IOPs and whether the IOPS can be achieved in the optimal timeframe

b)       User load and Stress test. Using Database server tools. I compare these figures to existing environments.

2)   Application level database server testing

a)       Work with application owners to identify busy periods in the production. I record the workload

b)       Take snapshots of the databases and transfer to the new environment.

c)       Rerun the workload on the new environment and compare the figures.

d)       Record the metrics and compare the two environments

Author: Jack Vamvas(http://www.dba-db2.com)
Author: Jack Vamvas(http://www.dba-db2.com)

Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been saved. Comments are moderated and will not appear until approved by the author. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on Data centre management for database servers

Comments are moderated, and will not appear until the author has approved them.


dba-db2.com | DB2 Performance Tuning | DBA DB2:Everything | FAQ | Contact | Copyright