CMDB for MSSQL business apps

for any of you with involvement in managing SQL driven business applications, do you have a CMDB for the database and application itself? What kind of configuration items do you store about the database, servers, and the applicaiton itself? And how is the configuration information feed into your CMDB, i.e. via software or manual techniques? I dont really understand what people record at each level of the applications stack.
LVL 3
pma111Asked:
Who is Participating?
 
Ryan McCauleyConnect With a Mentor Data and Analytics ManagerCommented:
We use BMC's CMDB, but it's a hefty solution:

http://www.bmc.com/it-solutions/product-listing/atrium-cmdb.html

At a very basic level, you need to record what ports are open for listening and what ports have active connections, for each of the servers involved in your layout. That way, you'll know if an open port closes or if connections suddenly stop from one server to another, which would indicate a problem. For Windows, this can be accomplished with a scheduled "NETSTAT -A" that you parse and log the results of.

Beyond that, you'd need logging at the service level to track users that connect and watch for changes there. You'll know what accounts are used in what locations, and you'll know if that changes. This can be done via an automated "SP_WHO2" on each of your SQL instances, which would show open connections, volume, and application names.

A formalized CMDB is going to collect quite a bit more configuration information, and would also work for Linux and other DBMS platforms, but if you're just using Windows and MSSQL, those are the basics of what you'd need to collect to know when something changes.
0
 
pma111Author Commented:
surely someone can assist?
0
All Courses

From novice to tech pro — start learning today.