SQL Response blocks NetApp SnapManager

Monitor, diagnose and receive alerts to problems across your SQL Servers.

Moderators: eddie davis, david connell, dlkj, Colin Millerchip, priyasinha, Emma A

SQL Response blocks NetApp SnapManager

Postby normajeanb » Fri Apr 24, 2009 11:57 pm

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
normajeanb
 
Posts: 2
Joined: Fri Apr 24, 2009 11:34 pm
Location: Anacortes, WA

Postby Brian Donahue » Mon Apr 27, 2009 5:51 pm

Hi,

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.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

This fixes the Snapshot failure, but SQLResponse stops

Postby normajeanb » Wed Apr 29, 2009 11:29 pm

Yes, I had thought of doing that too - so I went ahead and created the jobs, scheduling them around the snapshot database cloning time BUT once SQLResponse gets a force disconnect from the stopped service, it doesn't try to reconnect by itself...I have to remember to manually go back in to the app and re-establish the connection in order to get back online for my raised alerts.
I don't think this is going to be a workable "workaround" for me...
Normajean
normajeanb
 
Posts: 2
Joined: Fri Apr 24, 2009 11:34 pm
Location: Anacortes, WA

Postby eddie davis » Mon May 04, 2009 6:40 pm

Hi

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
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
eddie davis
 
Posts: 943
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software

IBM Tivoli Storage FlashCopy Manager

Postby msright1981 » Sat Jul 10, 2010 7:18 pm

I have seen many companies depending on NetApp SnapManager to backup their SQL using snapshot, though we have IBM DS8000 & would like to do what others are doing with NetApp SnapManager for SQL. The best I was able to get to was IBM Tivoli Storage FlashCopy Manager Tutorial though I am still curious how stable is this IBM Tivoli Storage FlashCopy Manager & how much of the NetApp SnapManager functionality it can offer. Is it worth it?

Thanks for your help in advance,
msright1981
 
Posts: 1
Joined: Sat Jul 10, 2010 7:12 pm


Return to SQL Response 1

Who is online

Users browsing this forum: No registered users and 0 guests