Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

NetApp & clustering dependencies Expand / Collapse
Author
Message
Posted Thursday, July 17, 2014 5:39 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 10:23 AM
Points: 2,008, Visits: 3,434
Hi guys,
Just a quick Q... should the clustered SQL Server instance have a dependency on the snapinfo LUN when using SnapManager for SQL?
I know the drive has to be in the cluster resource group, but can't see why there'd be a dependency too?

Cheers
Post #1593534
Posted Thursday, July 24, 2014 3:09 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 9:46 AM
Points: 282, Visits: 889
The question is, do you want to bring the SQL server resource online even if there is an issue with the snapinfo LUN?
If YES, then you do not need the dependency.
if NO, then you do need the dependency.
Post #1596034
Posted Friday, July 25, 2014 2:53 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 10:23 AM
Points: 2,008, Visits: 3,434
Cheers, the issue was that the LUN filled, went offline, and took the SQL instance with it!
We've removed the dependency, I just wasn't sure if it was a NetApp recommended practice or not.
Post #1596122
Posted Friday, July 25, 2014 9:02 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 9:46 AM
Points: 282, Visits: 889
Then remove the dependency.

In general you must be very careful using snapshots.
If your database has a lot of churn and frequent index maintenance you will require a lot of snapshot space.
Why did it fill up? how are snapshots configured? what kind of retention? If the snapshot volume is filling up, why does it not just throw away the oldest snapshots and send a warning?

Why are you using snaphots at all? Do you have a requirement to use them?
Post #1596267
Posted Friday, July 25, 2014 10:04 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 10:23 AM
Points: 2,008, Visits: 3,434
Thanks, we have done.

It filled with streaming backup files as snapshot backups aren't currently being used (system db file in the wrong place), plus the user db starting growing much quicker than anticipated.
Moving those system db files soon so won't be an issue then; in the meantime we've reduced backup rentention.
Post #1596308
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse