Our team is currently taking over management of additional SQL Servers from other parts of the company. While we are just starting this process one thing we know is that we are going to need some way to manage the details about servers, instances and databases even users better than using a spreadsheet. I have been looking for some way to do this and have not found anything good as of yet. What we will eventually be faced with is the following:
200 ish servers
1000's of databases and users
versions from SQL Server 2000 to SQL Server 2008 r2 currently.
We are trying to figure out some way to look at a database and see a listing of the prod, qa and dev servers, which development team is in charge, the Business Owner, and information about the application that is using the database.
I am not sure if there is some way to put all that info into extended properties and if there is some tool that can pull a report, or if there is some third party tool I haven't been able to find yet, or whether it would have to be a custom app that we build internally.
200 ish servers
1000's of databases and users
versions from SQL Server 2000 to SQL Server 2008 r2 currently.
We are trying to figure out some way to look at a database and see a listing of the prod, qa and dev servers, which development team is in charge, the Business Owner, and information about the application that is using the database.
I am not sure if there is some way to put all that info into extended properties and if there is some tool that can pull a report, or if there is some third party tool I haven't been able to find yet, or whether it would have to be a custom app that we build internally.
Comment