RSS Feed

Server Builds

6

January 19, 2010 by Mike Hillwig

I’m building a new server. Actually, I’m building two. We just bought a new pair of SANS (one production, one DR) and are doing a consolidation project with our databases.

Each DB server will live on its own VMWare host. We’re virtualizing so that we can utilize VMWare’s clustering. It also gives us the flexibility to move things around. My two database servers will have identical configurations. One will server internal applications, and the other will host customer-facing applications.

Hardware wise, I’m using IBM HS22 blades with 32 GB of RAM connected to an EMC Clariion CX4-120SAN. Each server has five datastores, each corresponding a LUN on the SAN. Each virtual drive will live in its own storage group. I have a drive for:

  • OS – Aps
  • TempDB
  • Log (LDF) Files
  • Backups
  • Data (MDF/NDF) files

My preference would have been to have the virtual machines use an iSCSI initiator to talk to the SAN, but I got overruled on that one. Still, this is a better configuration than I had before. (We had no SAN at all.)

Everything is 64 bit SQL 2005.  Again, I wanted to use SQL 2008, but that’s the next project.

After installing Windows and SQL, I started putting together a checklist of items to do next. Brent Ozar has a great checklist and has been a great reference. Here is my list:

  1. System Center Operations Manager Agent
  2. Antivirus protection
  3. Quest’s LiteSpeed
  4. Service Packs, Service Packs, Service Packs.
  5. Set default file locations
  6. Move master DB
  7. Move TempDB
  8. Resize TempDB
  9. Move Model
  10. Move MSDB
  11. Load Testing

6 comments »

  1. Hmm it appears like your website ate my first comment (it was super long) so I guess I’ll just sum it up what I had written and say, I’m thoroughly enjoying your blog. I as well am an aspiring blog writer but I’m still new to everything. Do you have any suggestions for rookie blog writers? I’d certainly appreciate it.

  2. erjilopterin says:

    Wow that was odd. I just wrote an really long comment but after I clicked submit my comment didn’t appear. Grrrr… well I’m not writing all that over again. Regardless, just wanted to say great blog!

  3. Hollow Board says:

    I would like to thnkx for the efforts you have put in writing this blog. I am hoping the same high-grade blog post from you in the upcoming as well. In fact your creative writing abilities has inspired me to get my own blog now. Really the blogging is spreading its wings quickly. Your write up is a good example of it.

  4. of course like your web-site but you need to check the spelling on quite a few of your posts. A number of them are rife with spelling problems and I find it very troublesome to tell the truth nevertheless I’ll definitely come back again.

  5. I liked as much as you will obtain carried out right here. The caricature is tasteful, your authored material stylish. nevertheless, you command get got an shakiness over that you wish be handing over the following. ill certainly come more previously once more as precisely the same just about a lot often within case you defend this hike.

  6. Appreciate it for this fantastic post, I am glad I noticed this web site on yahoo.

Leave a Reply

Your email address will not be published. Required fields are marked *

Search

Pages