Solved

CMDB for MSSQL business apps

Posted on 2014-04-15
2
332 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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

Never store passwords in plain text or just their hash: it seems a no-brainier, but there are still plenty of people doing that. I present the why and how on this subject, offering my own real life solution that you can implement right away, bringin…
When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

739 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