Viewing 15 posts - 7,831 through 7,845 (of 9,253 total)
Bringing the SQL Server agent online first will automatically bring SQL Server up due to the dependencies between these resources 😉
August 5, 2010 at 7:53 am
That's an excellent link. IMHO anybody who hooks a SQL Server system up to a storage system without completing IO tests needs their brain looked at 😀
August 4, 2010 at 3:09 pm
Thank you, I could possibly add the witness setup to the VMWare based doc but I don't have or use Hyper-V.
Its very easy, just configure the cluster as usual using...
August 4, 2010 at 2:29 pm
neither, in my opinion RAID group 2 is the weak point. I would opt for multiple smaller arrays!
August 4, 2010 at 2:21 pm
Robert
remember as you are implementing a cluster you will inherently have more than 2 machines on the network (a cluster is dependant upon DNS and AD).
You cluster the 2...
August 4, 2010 at 1:49 pm
OK, taking RAID group2 from your diagram link above you have 1 RAID 10 group carved up to service
TEMPDB data
user DB data
Backup data
Sharing storage amongst 3 LUNs will likely not...
August 4, 2010 at 1:43 pm
sivaprasad (7/28/2010)
Single Node cluster
SQL Server 2005 with default instance
O.S: Windows 2003 with KB937444, Microsoft .NET Framework 3.5 Service Pack 1 & Windows Installer 4.5
The upgrade of SQL 2005 cluster...
August 4, 2010 at 12:04 pm
Jamie Wormald (8/3/2010)
The way I understand it only one server if live at any one time and this server is the one with access to the quorum drive.
is this...
August 4, 2010 at 12:02 pm
for an OLTP system shared storage is a bad idea!
August 4, 2010 at 12:00 pm
Windows 2008 now offers the ability to create multiple clustered DTC resources, you could have one for each instance or just use the one
August 4, 2010 at 11:55 am
keep the locked pages but you will need to review your MAX Memory settings!
August 4, 2010 at 11:54 am
more importantly, SQL Server does not care whether the quorum is an MNS or a disk!
August 4, 2010 at 11:48 am
rdecker (8/4/2010)
If we used a witness then it would be a 2 node cluster anymore. Unless I'm mistaken a majority node set with a witness would require at...
August 4, 2010 at 11:32 am
WayneS (8/4/2010)
Perry Whittle (8/4/2010)
August 4, 2010 at 10:17 am
you're wlecome.
you would need to either move the group via cluster administrator or pull the public network connection on the active node for the service to fail over!
August 4, 2010 at 9:12 am
Viewing 15 posts - 7,831 through 7,845 (of 9,253 total)