We have 200+ servers and I am thinking about creating a centralized DBA database where it logs backup, errors, space jobs and generate reports on SSRS. I am not sure where to start and I would highly appreciate your help. Thank you very much.

  • Can I accomplish this using System Center Operations Manager 2007 R2? Please let me know from your experience comparing to MOM. Thank you!
    – db7
    May 17, 2011 at 20:27

4 Answers 4


On SQL Server 2008 R2 I'd guide you to SQL Server Utility Control Point, with some details here.

From MSDN description: "The SQL Server Utility models an organization’s SQL Server-related entities in a unified view. Utility Explorer and SQL Server Utility viewpoints in (SSMS) provide administrators a holistic view of resource health through an instance of SQL Server that serves as a utility control point (UCP). Entities that can be viewed in the SQL Server UCP include:

Instances of SQL Server
Data-tier applications
Database files
Storage volumes

Resource utilization dimensions that can be viewed in the SQL Server UCP include:

CPU utilization
Storage space utilization"

On 2008 and earlier - MOM, as Gaius pointed, or maybe give a try to Multi Server Administration as defined by MS. You can see detailed article on SQLServerCentral Multi-Server Administration or on MSDN.


Take a look at MOM, MS's product for doing this. It is broadly analogous to Oracle's Grid Control.

  • I didn't know MOM is free. Have you used it before? do you know a good blog post on how to implement it? Thank you.
    – db7
    Apr 29, 2011 at 13:16
  • 3
    MOM is very much not free. You have to purchase the server license as well as a license for each server that MOM is monitoring.
    – mrdenny
    Apr 30, 2011 at 20:52

If you have a SQL2008 machine to use, look into the using Central Management Server. It is free and built into SQL. You can even do multiserver queries and policy based management. Check this link for more details.


If you still want to develop smth custom where you can log what info you want take these steps as start: Create tables with servers, databases linked to server id, backup info linked both to server id and db id. Create scripts that will be launched on destination servers using xp_cmdshell. The scripts will insert collected info to destination tempdb table and insert through linked server to your DBA server. This is very shortly. you can contact me on private if you need more details. I am using this method as it is the best way to track many stuff.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.