Re: SQL transaction logs on iSCSI

So AJ / Rodney ,

Did it work properly I was using same setup long time back and had to
ultimately switch to SAN Solution with Fibre Optic ... Please share your
results...


"AJ" wrote:

I was looking at putting in the new HP StorageWorks 1510i as it is exactly
the level of kit that we want, priced at the right level for us.

Plenty of people have set up SQL SANs with the HP 1500 with fibre channel;
it's tried and tested kit. I can't see that it is going to be any different
with iSCSI over Ethernet. The only thing that is changing is the transport
mechanism.

I appreciate that there are differences between the physical and data link
mechanisms of fibre channel and Ethernet, not least being that if iSCSI if
run over Ethernet there is more chance of misconfiguring devices. Fibre
channel switches tend to be less configurable that their Ethernet
counterparts.

Given that we will be using iSCSI adapters, Cisco switches with a 32Gbps
swicth fabric, all in a single VLAN in a single location and that iSCSI and
fibre channel compare on data throughput, I tend to lean towards the idea
that it should work fine.

The supplier we are using have offered to test the setup before we buy it so
we don't have to comit blindly, although there is always the uncertainty of
production levels of traffic. We can simulate load with SQL I/O and compare
this to the benchmark figures gained from the same set up with fibre channel.
I guess this is as much of a pre-production stress test as it can be given.

AJ.


"Rodney R. Fournier [MVP]" wrote:

I am putting up a 20 TB SQL iSCSI SAN very soon. If done correctly, iSCSI is
great!

Cheers,

Rodney R. Fournier

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://www.msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner


"Geoff N. Hiten" <SQLCraftsman@xxxxxxxxx> wrote in message
news:ev5$Eo4RGHA.2276@xxxxxxxxxxxxxxxxxxxxxxx
I have heard too many horror stories about iSCSI storage with SQL to be
comfortably using any solution. I do know some people have had success
using iSCSI, but when it goes bad, it goes way, way bad. I would not
recommend using iSCSI without a manufacturer showing me both a live
customer install AND letting me play with a setup for afew days.

I have had excellent results with EMC Clariion boxes, provided the SAN
Architect actually understands how to set up a system for Microsoft SQL
Server.

Either way, don't automatically select the lowest cost provider. If this
is your first foray into the SAN world, you really need good advice and
guidance. That means paying for professional services along with the
hardware. Make sure your vendor can provide both to the level you need.

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP




"AJ" <AJ@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:09F0A374-2188-4FA9-9AAE-9B09E90C38BD@xxxxxxxxxxxxxxxx
We have been advised that there are performance issues with putting
transaction logs on iSCSI targets. Can anyone give more
detail/confirm/repudiate this?

We are looking at implementing a two node (probably single instance to
begin
with) SQL 2K cluster with an iSCSI or fibre channel set of disk
resources.
We would prefer to use iSCSI due to our existing data network but we are
unsure of the performance implications of doing this.

Has anyone installed anything similar? I have been looking at NetApp,
EMC
and HP iSCSI targets.

Thanks in advance. Any pointers are appreciated.





.

Relevant Pages

  • Re: Fibre Channel vs iSCSI
    ... I am thinking about investing in a SAN for my company & am not sure ... whether to go with Fibre Channel or ISCSI ... At the office, we use SLES 10, Qlogic switches, Qlogic HBA's ...
    (alt.os.linux.suse)
  • Fibre Channel vs iSCSI
    ... I am thinking about investing in a SAN for my company & am not sure ... whether to go with Fibre Channel or ISCSI ... In opensuse 10.3 which would be more favourable in terms of support ...
    (alt.os.linux.suse)
  • Re: Linux-Server als Fibre Channel SAN?
    ... SAN "holen". ... überlegen wir nun von iSCSI auf Fibre Channel zu wechseln. ... ist Latency eigentlich kein großes Problem bei iscsi, ...
    (de.comp.os.unix.linux.hardware)
  • Recovery from interrupted SAN connection
    ... I have a Solaris 8 machine connected via a single Qlogic fibre HBA to EMC ... When the SAN connection is lost, ... When I plug the fibre connector back in, the /var filesystem, which is on ... console login: root ...
    (SunManagers)
  • Re: [opensuse] SAN Solution on Linux
    ... You decide a level of redundancy and add more equipment ... I've got a 1Gbit fibre SAN setup that I'm slowly phasing out, ... Which software you use to run SAN server? ... If you have some old SAN equipment you do not need may be you can consider to sell it? ...
    (SuSE)
Quantcast