The Multifunctioning DBA

Feb 9 2010   12:13AM GMT

70-443 Chapter 1

Colin Smith Colin Smith Profile: Colin Smith

I will be giving a summary of most of the sections of each chapter. Not all information will be in the summary but the things that I think are most important will be included in my summary. Keep in mind that if you are studing for these certificates that you should go get the book and do the work. It will pay off for you. These are just some of the highlights.

Planning a database server infrastructure

Server sizing can be done in a couple of ways and it really depends on the situation that you are in. Server Sizing refers to more than just the size of the database. This includes the hardware of the server. Procs, Network, Disk, Memory…etc. If you are lucky and you are looking to replace an existing server, or you have the money to build a full test server and perform realistic load tests, then you can gather performance data and baselines to help make your decisions. If you are not so lucky then you will want to do interviews with Management and perhaps the support team of the app that the database server will be supporting. If this is a third party application then hopefully they have done the due diligence and can give good guidelines on what hardware you will need and what type of load and growth to expect out of an organization of your size.

I think that I liked the section on disk the most. It talks about different types of disk, SCSI, SATA, and so forth. It also talks about disk configuration and describes why certain raid levels are better than others depending on what your database transactions look like. I found it very interesting that a RAID 10 was the best for writes and reads and that a RAID 5 was so bad for reads. That is going to make me re-think the way that just about all my servers are set up.

 Comment on this Post

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when other members comment.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: