Re: SQL transaction logs on iSCSI

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: Clustered SQL-Server. iSCSI
    ... MVP - Windows Server - Clustering ... I plan to use iSCSI and a Promise VTrak M200i ...
    (microsoft.public.windows.server.clustering)
  • 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 have heard too many horror stories about iSCSI storage with SQL to be ... Architect actually understands how to set up a system for Microsoft SQL ... Microsoft SQL Server MVP ... transaction logs on iSCSI targets. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Cluster IP Address change
    ... I've heard the same story from...after not hearing this in 2 years of SQL ... After changing sql ip address resource & sql name resource came online but ... sql server resource was failing. ... MVP - Windows Server - Clustering ...
    (microsoft.public.sqlserver.clustering)
Loading