Solved

CMDB for MSSQL business apps

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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
For cloud, the “train has left the station” and in the Microsoft ERP & CRM world, that means the next generation of enterprise software from Microsoft is here: Dynamics 365 is Microsoft’s new integrated business solution that unifies CRM and ERP fun…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

932 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

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now