RE: Clustering 2005 SQL server using hyper v

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

What you NEED is to expose two LUNs (disks), quorum and "database", to both
nodes, however I do recommend a better configuration, in which you use
dedicated LUNs for database files, log files, tempdb and backups. And before
someone kills me, I know there is no perforamance or security benefit from
this configuration, but I still want the flexibility it offers to for
instance move log files to another SAN or disk set on the SAN. I also preffer
to have both tempdb and backup files on separate LUNs, so that they don't
cause trouble for database files or log files in case the disk should happen
to run out of space.

So, in your active/passive configuraiton I would suggest five LUNs, namely:
quorum, database, log, backup and tempdb, although you can run it with just
two LUNs if you want.

"Bartek" wrote:

Hi guys,
I am wondering if someone could clear up some information for me.
I am in the midst of changing our network environment to virtual and have
setup a cluster with 2 poweredge nodes and iSCSI SAN. I would like to have 2
sql servers in passive\active configuration for fault tolerance, so that if
the first one fails, second one kicks in soon after. I have exposed qourum
and virtual disk to both servers. Do i have to expose one more virtual disk
and have one sql server on 1LUN and second sql on 2LUN? I am in the midst of
testing this out and would appreciate any help in regards to that.
.

Relevant Pages

  • Re: Please help me understand disk manager
    ... configuration database isn't stored in a raw disk slice (e.g. the ... It's not stored in a raw disk slice? ... Correct (although generally VxVM manages that setup for you). ... Just like VxVM its database is also stored on raw disk. ...
    (comp.unix.solaris)
  • Re: HP EVA4000 / IBM DS4300 / EMC CX3-20/40
    ... disk array with the virtual raidsets on top. ... So, the system admin, and the DBAs had to create and manage lots of ... separate LUNs and *manually* manage the performance among them to ... applications on the SAN. ...
    (comp.arch.storage)
  • SUMMARY: sd_max_throttle settings in /etc/system and in jni configuration file
    ... The original posting is shown at the end of this mail for reference. ... The box itself is now under low stress but the throughput has not increased. ... XP512 disk array is also connected to this dedicated disk SAN. ... LUNS presented to each port of the first card (i.e.., ...
    (SunManagers)
  • Re: High Avg. Disk Queue Length When Opening Shared Calendars
    ... Let's assume 10K spindles, a 3:1 read/write ratio, and IOPS/user of 1. ... Now let's look at the logs. ... the database LUN would become a bottleneck prior to the log LUN. ... A disk bottleneck on the database LUN. ...
    (microsoft.public.exchange.admin)
  • Re: Oracle Performance -- Possible Disk Bottleneck
    ... I've read that 15k drives can perform 180 IO's per second. ... confirm this is a disk bottle neck. ... so I'm hoping someone here has experience with SANs and ORACLE to help ... this is a disk bottleneck and that giving the database more spindles ...
    (comp.databases.oracle.server)