Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


NetApp & clustering dependencies


NetApp & clustering dependencies

Author
Message
Gazareth
Gazareth
SSCrazy
SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)

Group: General Forum Members
Points: 2868 Visits: 5350
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
arnipetursson
arnipetursson
Old Hand
Old Hand (339 reputation)Old Hand (339 reputation)Old Hand (339 reputation)Old Hand (339 reputation)Old Hand (339 reputation)Old Hand (339 reputation)Old Hand (339 reputation)Old Hand (339 reputation)

Group: General Forum Members
Points: 339 Visits: 1019
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.
Gazareth
Gazareth
SSCrazy
SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)

Group: General Forum Members
Points: 2868 Visits: 5350
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.
arnipetursson
arnipetursson
Old Hand
Old Hand (339 reputation)Old Hand (339 reputation)Old Hand (339 reputation)Old Hand (339 reputation)Old Hand (339 reputation)Old Hand (339 reputation)Old Hand (339 reputation)Old Hand (339 reputation)

Group: General Forum Members
Points: 339 Visits: 1019
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?
Gazareth
Gazareth
SSCrazy
SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)

Group: General Forum Members
Points: 2868 Visits: 5350
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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search