SQL Response blocks NetApp SnapManager
normajeanb
Posts: 3
Our production system runs on Blade servers managed by NetApp filers.
Like many NetApp users, SnapManager is the most prominent part of our disaster recovery plan - this tool allows you to configure, schedule and manage SnapShot backups.
One option in the SnapManager backup step is the ability to mount a copy of the newly taken snapshot, and run DBCC checkdb to verify the snapshot backup of the database. After this step completes, SnapManager detaches the database and destroys the temporary LUN it was mounted on.
SnapManager backup jobs (with verification) fail when they run concurrent with SQLResponse because SQLResponse polls and accesses ALL the databases on the server, thereby blocking the detach action of the new database by SnapManager. Once this happens, all subsequent SnapManager backup jobs fail.
If only I could configure SQL Response to only poll certain databases - OR if we could schedule the polling periods for SQLResponse to exclude certain timespans we could work around this. But, I can't seem to locate these configuration options...
It's impractical for me to manually start and stop the service around SnapShot times - and I really lose the value of the product if it's not going most of the time to feed me alerts as they occur.
Do you have any suggestions?
Thanks, Normajean Bowen
Like many NetApp users, SnapManager is the most prominent part of our disaster recovery plan - this tool allows you to configure, schedule and manage SnapShot backups.
One option in the SnapManager backup step is the ability to mount a copy of the newly taken snapshot, and run DBCC checkdb to verify the snapshot backup of the database. After this step completes, SnapManager detaches the database and destroys the temporary LUN it was mounted on.
SnapManager backup jobs (with verification) fail when they run concurrent with SQLResponse because SQLResponse polls and accesses ALL the databases on the server, thereby blocking the detach action of the new database by SnapManager. Once this happens, all subsequent SnapManager backup jobs fail.
If only I could configure SQL Response to only poll certain databases - OR if we could schedule the polling periods for SQLResponse to exclude certain timespans we could work around this. But, I can't seem to locate these configuration options...
It's impractical for me to manually start and stop the service around SnapShot times - and I really lose the value of the product if it's not going most of the time to feed me alerts as they occur.
Do you have any suggestions?
Thanks, Normajean Bowen
Comments
SQL Response polls the SQL Server every 15 seconds or so, and there isn't any way I know to change that. I would probably solve this problem by scheduling a maintenance interval for the time that you want to verify your snapshots, then create a batch file on the Response repository to stop and start the SQL Response Repository Service during those times by putting the batch file in a Windows Scheduled Task.
Hopefully this would work for you.
I don't think this is going to be a workable "workaround" for me...
Normajean
Following our telephone conversation earlier today, I have added your Support Call details to an existing Feature Request whose reference is SSR-1377 "Ability to configure the amount of e-mails that you get for certain alerts". Following our discussion regarding the E-Mail notifications.
I created a new Feature Request whose reference is SSR-1602 "To be able to deselect databases on a SQL Instance from being monitored"
Many Thanks
Eddie
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com
Thanks for your help in advance,
Julie
http://www.Linux2Aix.com