patternMinor
Creating centralized DBA database
Viewed 0 times
creatingdbacentralizeddatabase
Problem
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.
Solution
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:
Resource utilization dimensions that can be viewed in the SQL Server UCP include:
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.
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 volumesResource 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.
Code Snippets
Instances of SQL Server
Data-tier applications
Database files
Storage volumesCPU utilization
Storage space utilization"Context
StackExchange Database Administrators Q#2439, answer score: 8
Revisions (0)
No revisions yet.