More info on those reports

Carpe Datum — Fri, 16 Nov 2007 18:10:35 GMT

I spoke with Andrew Fryer yesterday via e-mail when I noticed he was also covering some of the same information

SQL Server - Monitoring Reports take 2

Andrew Fryer's Blog — Fri, 16 Nov 2007 11:40:44 GMT

Blogging is pretty new for me and it's difficult to know how interesting or valuable my stuff is. So

re: SQL Server - monitoring reports

colin leversuch-roberts — Thu, 15 Nov 2007 12:12:48 GMT

It's something which is always being asked on the forums and solutions usually involve complex solutions with linked servers which might not be what you want.Sounds fine for 6 servers but maybe not for 200. An oft found problem with the process of linking all the server data together is what happens when a server is not there - you have to make sure the error handing is really good. What I'd possibly say is that there are products out there, like Idera SQL Diagnostic Manager, sometimes it makes sense to buy a tool to handle the basic stuff rather than re-inventing the wheel and spending lots of time ( which has a cost too ) to develop your own.

The best solution is to return data to a central server and work on it there - just be wary of the overhead you may apply to your system, network and servers.