How do you cope with Database Server Inventory Management

Posted on

Question :

Is it common for SQL Server DBAs to have to struggle with Server Inventory Management due to multiple parties / departments bringing online their own instances of SQL Server?

If so have you been able to successfully add controls to prevent this problem?
Also how do you monitor your environment on a regular basis to troll for unmanaged instances so that you can proactively prevent embarrassing situations like databases without backups?

Answer :

I don’t have direct experience with this task but know how folks get around this problem. 🙂

You setup some monitoring program to look out for all SQL Server instances on the network and anytime something comes up that is NOT in your radar, you can catch them right away. There are lot of options and here are couple of them. I am pretty there might be others or many variants of these two.

http://www.straightpathsql.com/archives/2009/02/what-sql-instances-are-installed-on-my-network/

http://andrekamman.com/find-sql-servers-on-your-network-with-powershell

That said, I have to tell you that if someone brings an instance without notifying the DBA or production support team then this should be handled politically. Get your boss (in confidence) to talk to their boss and avoid future recurrence of the problem. GL.

I’d like to add to Sankar’s answer 2 other means of finding the sql servers in your network:

  • server discovery feature of Management Studio

  • SQL Ping – free tool from www.sqlsecurity.com

These situations are mainly political, if you don’t manage them directly, then you can’t be held accountable for others’ deeds.

You can also use Microsofts MAP tool. This tool will hunt out all the servers on a domain basis, and provided the user has access to those server (domain admin would work). Just filter it out for SQL servers.

There is a wrong assumption made here, namely policing other departments Sql Server is DB admins responsibility. Every and all departments are responsible for what they set up themselves, actively going out there and hunting them is nothing more than exercising political power. As a DB Admin you are only responsible for the servers that you have set up and manage. The best a DB Admin can do is to offer to manage their data for them, otherwise should leave them be.

Leave a Reply

Your email address will not be published. Required fields are marked *