3 Spindle sets for install

myITforum.com Community Forum

Home Forums Blogs Live Support chat Search Articles Wiki FAQ Email Lists Register Login My Profile Inbox Address Book My Subscription My Forums

Photo Gallery Member List Search Calendars FAQ Ticket List Log Out

All Forums RSS Feed Subscription:

3 Spindle sets for install

View related threads: (in this forum | in all forums)

Logged in as: Guest

Printable Version

All Forums >> [Management Products] >> System Center Products >> System Center Configuration Manager >> 3 Spindle sets for install

Page: [1]

Message

<< Older Topic Newer Topic >>

3 Spindle sets for install - 8/11/2008 7:56:18 AM

cjones464

Posts: 69
Score: 0
Joined: 7/23/2004
From: UK at the moment
Status: offline

Good Morning.
Back in the old days I used to adhere to a three spindle set approach to installing SMS & SQL on a single server
One spindle set for the op system
One spindle set for SQL
And One Spindle set for SMS

This was QED from the initial setup screen.

I am now installing SCCM in my Lab and I don’t see an easy way to control the different locations. Am I missing something obvious

Is this three spindle set still best practice or now that we all run on superior hardware is it somewhat unnecessary?

Ta

Post #: 1

RE: 3 Spindle sets for install - 8/11/2008 9:13:20 AM

wbracken

Posts: 1043
Score: 22
Joined: 4/12/2002
From: St. Louis
Status: offline

I think the biggest thing is keeping your SQL logs and your SQL data on seperate spindles. Not sure having the OS on a seperate spindle is going to help performance, but if you have the option it can help keep things more organized.

_____________________________

William Bracken

Visit my new Blog
http://wbracken.wordpress.com/

(in reply to cjones464)

Post #: 2

RE: 3 Spindle sets for install - 8/11/2008 11:15:16 AM

jnelson993

Posts: 959
Score: 132
Joined: 2/18/2005
From: Minneapolis, MN
Status: offline

I don't quite understand why you can't control the locations...when you install the OS, you create the partitions/volumes and install Winders to the partition of your choice...I'm assuming you've got that down :)

When you install SQL you can specify during the setup where you want it to go, and when you install CM you tell IT where to install.

Now, if you want to change the location of the DB after it's all set up, you can stop CM,detach the SMS DB using SQL Management Studio, move it to a new location and re-attach it from the new location.

If you just want to move the log, you can detach the DB, move the log, and when you reattach, use the SP_ATTACH_DP command from SQL to tell it where the log is.

EXEC sp_attach_db 'SMS_DB', 'd:\path\to\smsdb.mdf', 'd:\path\to\sms_log.ldf'

_____________________________

Number2 (John Nelson)
MyITForum - Blog
MyITForum - Forum Posts

(in reply to cjones464)