SQL 2008 High Level Design

Question

Post reply

SQL 2008 High Level Design

DucSTA

Old Hand

Points: 339
More actions
August 24, 2010 at 5:11 pm

#226505

Hi All,
Looking for templates on SQL 2008 High Level Design? Has anyone got a TOC 'Table of Contents' on a similar document.
The design I'm looking for is based around Infrastructure. Database files, disk I/O, HA, etc.
Cheers,

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 736455 More actions · Answer 1

What do you mean? How to design the hardware for a server? Or set it up?

DucSTA Old Hand Points: 339 More actions · Answer 2

Hi,

I guess i'm looking for a design document which has the following points

1. hardware spec

2. disk partitions/ RAID 1+0, RAID 5 configuration

3. Database file placement

4. Security

5. backup and recovery strategy

6. High Availability

7. monitoring

8. replication

Jorge Segarra SSCrazy Points: 2571 More actions · Answer 3

DucSTA (8/24/2010)
Hi,
I guess i'm looking for a design document which has the following points
1. hardware spec
2. disk partitions/ RAID 1+0, RAID 5 configuration
3. Database file placement
4. Security
5. backup and recovery strategy
6. High Availability
7. monitoring
8. replication

1. It Depends (get used to hearing that one a LOT)

For the rest if you want to learn it check out my SQL University and read up on all the great stuff the professors have put together on those topics: http://sqlchicken.com/sql-university

Or check out the great series of articles by Brent Ozar (which I name only because I know google is going to alert him on this 😀 ) - http://www.brentozar.com/archive/2008/03/sql-server-2005-setup-checklist-part-1-before-the-install/[/url]

=============================================================
/* Backups are worthless, Restores are priceless */

Get your learn on at SQL University!
Follow me on Twitter | Connect on LinkedIn
My blog: http://sqlchicken.com
My book: Pro Server 2008 Policy-Based Management

Steve Jones - SSC Editor SSC Guru Points: 736455 More actions · Answer 4

I'd agree with Jorge that it's worth checking out those articles. You're asking for a lot of documentation there, and so much if it might vary depending on your environment that it's hard to get it in one shot.

Here's another series of checklists that might help: http://www.bradmcgehee.com/2010/07/database-configuration-checklist/

DucSTA Old Hand Points: 339 More actions · Answer 5

thanks sqlchicken.

I see very interesting topics which I will dive deeper ..

Jorge Segarra SSCrazy Points: 2571 More actions · Answer 6

You're very welcome! If you ever need any help myself and pretty much every professor from SQLU is on Twitter (including Steve!)

=============================================================
/* Backups are worthless, Restores are priceless */

Get your learn on at SQL University!
Follow me on Twitter | Connect on LinkedIn
My blog: http://sqlchicken.com
My book: Pro Server 2008 Policy-Based Management