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

• rodneylandrum

  Valued Member

  Points: 50

  More actions

  January 21, 2008 at 11:36 pm

  #378119

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

• Jerry Hung

  SSChampion

  Points: 12968

  More actions

  January 22, 2008 at 10:10 am

  #770543

  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

  SQLServerNewbieMCITP: Database Administrator SQL Server 2005

• Merrill Aldrich

  SSCrazy

  Points: 2358

  More actions

  January 22, 2008 at 11:41 am

  #770586

  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.

• jswong05

  Hall of Fame

  Points: 3553

  More actions

  November 16, 2011 at 7:54 pm

  #1408943

  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
  

• te4t0n 70594

  Grasshopper

  Points: 17

  More actions

  June 26, 2013 at 11:04 am

  #1627663

  Thanks for this information.

  I have a few questions:

  1) How do you know the size should only be divided by 1,000,000 and not 1,048,576?

  2) Is speed MB/s ?

  Thanks in Advance.

  Regards,

  Tom