[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

CMDB for MSSQL business apps

Posted on 2014-04-15
2
Medium Priority
?
376 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 2000 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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
In this article, I’ll look at how you can use a backup to start a secondary instance for MongoDB.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…

649 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