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

  • rodneylandrum

    Valued Member

    Points: 50

    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: 12908

    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
  • Merrill Aldrich

    SSCrazy

    Points: 2142

    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: 3503

    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

    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

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply