Reporting on Activity across Multiple Servers using SQL Backup and SQL Multi Script

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by rodneylandrum » Reporting on Activity across Multiple Servers...

Reporting on Activity across Multiple Servers using SQL Backup and SQL Multi Script

Rate Topic

Display Mode

Topic Options

Author

Message

rodneylandrum

Posted Monday, January 21, 2008 11:36 PM

Forum Newbie

Group: General Forum Members
Last Login: Monday, February 25, 2002 12:00 AM
Points: 0, Visits: 1

Comments posted to this topic are about the item Reporting on Activity across Multiple Servers using SQL Backup and SQL Multi Script

Post #445732

Jerry Hung

Posted Tuesday, January 22, 2008 10:10 AM

Right there with Babe

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 3:02 PM
Points: 768, Visits: 1,159

Interesting article

I have RedGate Toolbelt, but sucks that SQL Backup is PER SERVER license so I don't have it installed on any server instance yet to try this technique

SQLServerNewbie

MCITP: Database Administrator SQL Server 2005

Post #445978

Merrill Aldrich

Posted Tuesday, January 22, 2008 11:41 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, February 14, 2013 2:07 AM
Points: 126, Visits: 123

This series is great, but isn't the phrase "months of laborious work" indicative of the notion it might be more effective to buy a monitoring tool than to write one? It might be possible to get a lot more functionality while spending your time on work directly benefiting whatever your core business is.

Post #446030

jswong05

Posted Wednesday, November 16, 2011 7:54 PM

SSC Rookie

Group: General Forum Members
Last Login: Monday, March 18, 2013 7:54 AM
Points: 27, Visits: 421

Merrill,
Yes, monitoring software like Idera DM and Quest Spotlight does work. I use them all day long. It is the best black-box recorder you can have when CIO wants to know why database had a problem last week (month) and evidence report.

However I wrote a lot of stuff myself, because A) the tool may not provide or provided a different view. Imagine how many performance counters you can have recorded and shown. The tool may not have all. Any DBA manual tasks, I wrote them into automated scripts. When I come to work, I only need to glance review everything. B) I wrote index defrag which savs my company $1200 per instance per year. That is $80,000 saving. I wrote database refresh script so I can plug in parameters and run a refresh at a few clicks. There are things money cannot buy.

When I have some doubts about my databases, I pull out some scripts from my repository (most of them in SP form), a few clicks I have complete info about my databases' current status.

Jason
http://usa.redirectme.net

Jason
http://dbace.us
Tongue

Post #1207212

« Prev Topic | Next Topic »

Permissions