Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 1234»»»

Creating a 2 Node SQL Server 2008 Virtual Cluster Part 2 Expand / Collapse
Author
Message
Posted Tuesday, July 12, 2011 12:04 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 10:09 AM
Points: 6,518, Visits: 14,037
Comments posted to this topic are about the item Creating a 2 Node SQL Server 2008 Virtual Cluster Part 2

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1140139
Posted Tuesday, July 12, 2011 5:14 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, January 19, 2014 7:35 AM
Points: 5, Visits: 50
Hi Perry,

can you explain the calculation for:

CREATE PARTITION PRIMARY ALIGN = 256

IMHO W2k8 chose the right alignment self?

Thanks



Post #1140215
Posted Tuesday, July 12, 2011 5:51 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 10:09 AM
Points: 6,518, Visits: 14,037
Thomas

it's not a given or set in stone or a recommendation, it's just an example i used for the diskpart tutorial. Windows 2008 applies a one size fits all and this is itself configurable through the Windows registry. Of course all this depends an other factors such a stripe size and NTFS cluster size. Did you like the article?


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1140230
Posted Tuesday, July 12, 2011 6:15 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, January 19, 2014 7:35 AM
Points: 5, Visits: 50
Hi Perry

your article is very profound and I love step by step tutorials with screenshots. I am using a similar configuration (StarWind free Target and VMWare Server) W2k8/W2k8R2 and MSSQL2k8/MSSQL2k8R2.

I have forgotten where to add the vmswitch in vmware an found your tutorial to solve the problem .


We are waiting for the next parts ..



Post #1140245
Posted Tuesday, July 12, 2011 6:20 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: 2 days ago @ 4:50 PM
Points: 73, Visits: 198
Hi, very nice article. I am currently - enough spare time permitted - experimenting on a similar setup, just using Hyper-V and a Synology NAS System (DS1511).

Just a few comments/questions:

- the screenshots could be bigger, at the current size they are a bit difficult to decipher
- are you saying that you add the iSCSI targets (quorum, sqldata, logs and back) to both installed server clusters?
- would you need to enable iSCSI MCS (multiple connections to same target/lun?)

With VMWare I recently made an interesting observation. If you do not presize your virtual disk and attempt to create a 10GB LDF (MS SQL Log File) on such a virtual hard disk performance will be very high and on the host system the VMDK will not really consume the 10GB. When using a preallocated VMDK disk performance will be considerably slow/normal.

Best,
Frank
Post #1140249
Posted Tuesday, July 12, 2011 6:39 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 10:09 AM
Points: 6,518, Visits: 14,037
ffoerster (7/12/2011)
- the screenshots could be bigger, at the current size they are a bit difficult to decipher

thank you for that feedback


ffoerster (7/12/2011)
- are you saying that you add the iSCSI targets (quorum, sqldata, logs and back) to both installed server clusters?

The targets need to be added to all nodes that will use them. In this case the 2 node cluster will support failover for a SQL Server instance, so both nodes need to have the LUNs unmasked


ffoerster (7/12/2011)
- would you need to enable iSCSI MCS (multiple connections to same target/lun?)

MPIO may be a better option, i didnt go into this fully as this tutuorial is designed to ease the reader in to clustering gradually

ffoerster (7/12/2011)
with VMWare I recently made an interesting observation. If you do not presize your virtual disk and attempt to create a 10GB LDF (MS SQL Log File) on such a virtual hard disk performance will be very high and on the host system the VMDK will not really consume the 10GB. When using a preallocated VMDK disk performance will be considerably slow/normal.

Best,
Frank

For the NAS data drives i use pre allocated virtual disks. LUNs are then created on the pre allocated drives.
Glad you enjoyed the article


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1140261
Posted Tuesday, July 12, 2011 8:58 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, January 19, 2014 7:35 AM
Points: 5, Visits: 50
Perry, how did you change/modify the names of the of the Networkadapter in Virtual Network Editor?

OK its clear. Its an after screenshot. You did it in the network connection from windows ..



Post #1140390
Posted Tuesday, July 12, 2011 9:17 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, October 3, 2014 1:21 PM
Points: 4, Visits: 41
Hi, the tutorial is interesting, I have a question, must I repeat the step "Attach the iSCSI" in the second node?

thanks
Post #1140409
Posted Tuesday, July 12, 2011 9:40 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 10:09 AM
Points: 6,518, Visits: 14,037
Thomas-105733 (7/12/2011)
Perry, how did you change/modify the names of the of the Networkadapter in Virtual Network Editor?

OK its clear. Its an after screenshot. You did it in the network connection from windows ..

Yes, rename the virtual adapters in windows network connections, then in VMWare server console click refresh networks list



MasterShion (7/12/2011)
Hi, the tutorial is interesting, I have a question, must I repeat the step "Attach the iSCSI" in the second node?

thanks

That is exactly what you must do for each cluster node that will participate in the failover of those resources


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1140439
Posted Tuesday, July 12, 2011 9:53 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, October 3, 2014 1:21 PM
Points: 4, Visits: 41
Thanks for your fast reply, I'll be testing your tutorial in a VM
Post #1140460
« Prev Topic | Next Topic »

Add to briefcase 1234»»»

Permissions Expand / Collapse