phigmov at gmail
Sep 6, 2009, 2:19 PM
Post #2 of 2
(442 views)
Permalink
|
|
Re: R: SQL 2005 reacts badly to a cluster giveback ?
[In reply to]
|
|
Thanks for all the advice - the key take aways would appear to be -
* try the host utilities - they make registry tweaks to key time out values
* failover / giveback can be a little slow on the low-end FAS models
As suggested I had a bit of a poke around NOW and came across some
interesting stuff
*
http://now.netapp.com/NOW/knowledge/docs/mpio/win/reldsm31/html/software/install/concept3.htm
We don't use MPIO but I'll try the registry tweak.
I'm still unsure wether this was a problem or not under SD 4.2.1 - I don't
think it was but these reboots are so infrequent its hard to recall.
We're replacing our 270C with a 2050HA so hopefuly failover speed will
improve.
Do people install the Host Utilities as a standard ? The notes seem to
relate more towards FC rather than iSCSI setups so I've held off using them.
Cheers,
Raj.
On Sun, Sep 6, 2009 at 2:56 AM, Milazzo Giacomo <G.Milazzo[at]sinergy.it>wrote:
> Among the other things reported there's another one.
> 270 (and 20X0) are "slow" filer when they performs a takeover or a
> giveback.
> ISCSI hosts (both physical and VMs) are faster for these reasons there are
> a couple of Windows registry keys to increase the timeouts of iSCSI "hba".
>
> These is well documented on NOW.
>
> Regards,
>
> -----Messaggio originale-----
> Da: owner-toasters[at]mathworks.com [mailto:owner-toasters[at]mathworks.com] Per
> conto di Leimann, Olaf
> Inviato: martedė 1 settembre 2009 14.50
> A: Filip Sneppe; Jack Lyons
> Cc: Raj Patel; toasters[at]mathworks.com
> Oggetto: RE: SQL 2005 reacts badly to a cluster giveback ?
>
> Hi,
>
> The Hostname/IP Address paris in PreferredIPAddresses in
> Snapdrive are NOT for the iSCSI traffic, they are meant for the
> management (RPC) traffic, and they need to be reverse-resolvable
> and normal network ports on the Filer reachable from the Guest-OS
> network.
>
> iSCSI traffic is only determined by the setting in the initiator.
>
> For the failover: make sure you use Host Utilities for ESX 5.0R2 or 5.1
> and normally the config)hba should be run during the install. A reboot
> is then required!
> --
> Olaf Leimann
>
> -----Original Message-----
> From: Filip Sneppe [mailto:filip.sneppe[at]gmail.com]
> Sent: dinsdag 1 september 2009 13:30
> To: Jack Lyons
> Cc: Raj Patel; toasters[at]mathworks.com
> Subject: Re: SQL 2005 reacts badly to a cluster giveback ?
>
> Hi,
>
> Yes, the preferred IP address was set (using hostname/IP address pairs).
> I have no indication of name resolution issues, ie. the LAN interfaces of
> the
> filers are statis DNS entries, and the iSCSI IP addresses are set using
> the filer preferred IP addresses in SnapDrive.
>
> Best regards,
> Filip
>
> On Tue, Sep 1, 2009 at 1:14 PM, Jack Lyons<jack1729[at]gmail.com> wrote:
> > Did you set the prefered filer IP address in snapdrive config. Did you
> > setup your iscsi target using hostname or ip's, could there be name
> > resolution issues?
> >
> > Filip Sneppe wrote:
> >>
> >> Hi,
> >>
> >> Yes, all hosts are on the same subnet, no jumbo frames are involved, and
> >> for iSCSI, single_image mode isn't really relevant...
> >>
> >> Best regards,
> >> Filip
> >>
> >> On Tue, Sep 1, 2009 at 12:50 PM, Jack Lyons<jack1729[at]gmail.com> wrote:
> >>
> >>>
> >>> We are about to implement a new SQL 2005 (x64) on NetApp so I will
> follow
> >>> this thread pretty closely. We have built a few virtual-virtual
> >>> active-active clusters and virtual-physical active-active clusters for
> in
> >>> house developed software with no issues.
> >>>
> >>> I assume that the iscsi NIC is on the same segment as the storage?
> >>> I assume you are not using jumbo frames?
> >>> I assume your netapp cluster is configure for single image mode?
> >>>
> >>>
> >>> Raj Patel wrote:
> >>>
> >>>>
> >>>> Hi.
> >>>>
> >>>> We've had a couple of cluster-failover events on our FAS270c (watchdog
> >>>> errors every time) on 7.2.5.1
> >>>>
> >>>> The failover is fine (AFAIK) when one of the nodes reboots - however
> in
> >>>> the Giveback it appears that the SQL server has a couple of initiator
> >>>> errors
> >>>> events logged and although the drives are visible (and working in
> terms
> >>>> of
> >>>> I/O) and the SQL services are still running any SQL dependent
> >>>> applications
> >>>> just don't work after the giveback. As soon as I stop/start the SQL
> >>>> services
> >>>> its all back to normal (or I reboot the box).
> >>>>
> >>>> Server is Windows 2003sp2, its a VM on ESX3.5, the iSCSI interface
> goes
> >>>> through a dedicated iSCSI NIC (a virtual switch which also carries the
> >>>> ESX
> >>>> iSCSI LUN's) Snapdrive is 6.01, iSCSI initiator is 2.03 and its a
> 32bit
> >>>> VM.
> >>>>
> >>>> Oddly Exchange didn't miss a beat (they're physical Windows 2008 64
> bit
> >>>> servers) but SQL was definitely unhappy (even though the SQL service
> >>>> itself
> >>>> carried on - ie it didn't stop).
> >>>>
> >>>> Any ideas ? I note theres a newer iSCSI initiator available (2.08)
> from
> >>>> Microsoft. I'm pretty sure we haven't had this Giveback issue with our
> >>>> old
> >>>> SnapDrive 4.2.1 setup on the same server.
> >>>>
> >>>> Thanks in advance,
> >>>> Raj.
> >>>>
> >>>
> >>>
> >>
> >>
> >
> >
>
>
>
|
