Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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.

share|improve this question
    
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 '11 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.

share|improve this answer

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

share|improve this answer
    
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 '11 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 '11 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.

share|improve this answer

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.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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