Posted by: Colin Smith
70-443, Certification, Education, Training
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.