Solved

CMDB for MSSQL business apps

Posted on 2014-04-15
2
340 Views
Last Modified: 2014-04-29
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.
0
Comment
Question by:pma111
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 3

Author Comment

by:pma111
ID: 40003379
surely someone can assist?
0
 
LVL 28

Accepted Solution

by:
Ryan McCauley earned 500 total points
ID: 40004208
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

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
Your data is at risk. Probably more today that at any other time in history. There are simply more people with more access to the Web with bad intentions.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

724 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question