Collect historical data for offline viewing

SQL Server performance monitoring and alerting

Moderators: eddie davis, priyasinha, Adam, chriskelly, Chris Lambrou, Chris Spencer

Collect historical data for offline viewing

Postby dbarbon » Wed Dec 14, 2011 9:43 am

Hi all members, this is my first post.
I bought SQL Monitor 2.3 and I installed it on a customer's production server.
I want to backup the RedGateMonitor db on regular basis (prior of data purging) , transfer it to my server and analyze historical data offline.

Is it possible ? How to achieve this target?
Thanks.
dbarbon
 
Posts: 2
Joined: Wed Dec 14, 2011 9:30 am

Postby RBA » Wed Dec 14, 2011 2:44 pm

Hi,

The SQL Monitor repository is no different to any other SQL Server database. As such, any method for database replication will probably do (mirroring, replication, log shipping).

Our SQL Backup product allows you to set up log shipping with ease, so if they have a licence you have a quick win.

The data purging will mean that replicated or mirror DBs lose data over time. If this is unacceptable, then I'd just recommend taking full backups and restoring them when you want to analyse the time period that backup relates to.

As for the actual analysis, you can install SQL Monitor locally and point it at the restored database. To prevent it from modifying your copy, it is essential that you configure your local copy of SQL Monitor to be in 'slave mode' (=read only). Details of this I can email you, if that's what you want to do: robin.anderson@red-gate.com.

Regards,
Robin Anderson
Development
Red-Gate Software
RBA
 
Posts: 148
Joined: Fri Jun 05, 2009 12:13 pm
Location: Cambridge

Postby dbarbon » Thu Dec 15, 2011 4:32 pm

Hi Robin, thanks for your response.

As for the actual analysis, you can install SQL Monitor locally and point it at the restored database. To prevent it from modifying your copy, it is essential that you configure your local copy of SQL Monitor to be in 'slave mode' (=read only). Details of this I can email you, if that's what you want to do: robin.anderson@red-gate.com.


Yes, this is exactly what I want; can you send a mail with details at dbarbon@olicom.eu ?

Thanks again.
dbarbon
 
Posts: 2
Joined: Wed Dec 14, 2011 9:30 am

Postby RBA » Thu Dec 15, 2011 5:06 pm

Emailed.

Regards,
Robin Anderson
Development
Red-Gate Software
RBA
 
Posts: 148
Joined: Fri Jun 05, 2009 12:13 pm
Location: Cambridge

Postby Richard Line » Wed Feb 01, 2012 11:16 pm

Hi

Just purchased some Production and Development licenses of SQL Monitor and would like to be able to provide Read Only access to developers. Under these licenses would I be able to into the web element twice once to DBA use and once in 'slave mode' for read only access for developers? If so how would I acheive this?

Thanks
Richard Line
 
Posts: 2
Joined: Wed Feb 01, 2012 11:10 pm
Location: Staffordshire, UK

Postby RBA » Thu Feb 02, 2012 10:38 am

Hi,

Please get in touch via email and I'll provide details: robin.anderson@red-gate.com.

Note that slave mode was designed for our public facing demo, rather than for customer use, and will display marketing messages.

We will be releasing version 3.0 at some point over the next few months and one of the features will the addition of user roles, including a read-only role.

You won't have to use up a licence if you want a second SQL Monitor web server running in slave mode.

Regards,
Robin Anderson
Development
Red-Gate Software
RBA
 
Posts: 148
Joined: Fri Jun 05, 2009 12:13 pm
Location: Cambridge


Return to SQL Monitor 2

Who is online

Users browsing this forum: No registered users and 0 guests