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

Question

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

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

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

Jerry Hung SSChampion Points: 12968 More actions · Answer 1

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 · Answer 2

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 · Answer 3

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 · Answer 4

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