in my opinion and experience, management who are lacking the key understandings are the real issue. They dont necessarily need to be a DBA themselves but they should have a...

wow this is really going off topic now, the OP only asked about cluster resources failing over from node to node 😀

Mike Hinds (8/6/2010)

---

Thanks for...

then you do not have your dependencies set correctly!

see my attached screenshot for details

Even with locked pages the OS can still ask ever so nicely for SQL to free some memory it just can't force it to as the buffer pool pages are...

With locked pages in memory sql server will never release below the min memory setting. It is important to set both the min and max memory when using locked pages.

Bringing the SQL Server agent online first will automatically bring SQL Server up due to the dependencies between these resources 😉

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 😀

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...

neither, in my opinion RAID group 2 is the weak point. I would opt for multiple smaller arrays!

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...

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...

sivaprasad (7/28/2010)

---

Environment:

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...

is this...

for an OLTP system shared storage is a bad idea!