Re: SQL transaction logs on iSCSI

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: SQL transaction logs on iSCSI
    ... Plenty of people have set up SQL SANs with the HP 1500 with fibre channel; ... with iSCSI over Ethernet. ... MVP - Windows Server - Clustering ...
    (microsoft.public.sqlserver.clustering)
  • Re: S-ATA in cluster
    ... I'm sure SQL can run just fine over iSCSI, I was just pointing out that you ... software initiator consumes approx 500Mhz of CPU cycles. ... As a hardware initiator is going to cost a fraction of what a clustered SQL ...
    (microsoft.public.windows.server.clustering)
  • Re: SQL transaction logs on iSCSI
    ... I am putting up a 20 TB SQL iSCSI SAN very soon. ... MVP - Windows Server - Clustering ... Architect actually understands how to set up a system for Microsoft SQL ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL transaction logs on iSCSI
    ... I'm one of the guys that had an iSCSI array go south - big time. ... Columnist, SQL Server Professional ... Architect actually understands how to set up a system for Microsoft SQL ... transaction logs on iSCSI targets. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Memory Leak Event 2019
    ... this pool leak can also occur on x64 clusters. ... The issue is with MPIO, so if you do not have multiple paths to the storage, ... Also, when configuring your iSCSI targets, do ...
    (microsoft.public.windows.server.clustering)
Loading