Where to put MS SQL DBs in the CMDB

[jimlynch]

We are struggling with how to represent our MS SQL DB's and DB Instances in the CMDB.   We are further confused by the placement of cmdb_ci_db_mssql_database in the cmdb_ci_db_instance hierarchy rather than cmdb_ci_database.   We are not using an auto-discovery tool.

[Dave Smith1]

There's already some tables for them on my instance, but that could be part of the test data:

The top one is used for the actual server itself (hardware, cluster, etc) and the lower for instances found within that database installation (in the same way, I could have two web servers but nearly twenty websites).

[ChristianE]

Hi! It's a shame that the computer world adheres to this terminology that Database Servers should mean "...... actual server itself (hardware, cluster, etc)". The "actual server itself ..." is really the running processes in the computer system of the SQL Server executable that serves the client calls for database operations. The menu item "Database Servers" should refer to the instances of SQL Server installations running in computer systems and nothing else. "Database instances" should mean actual instances of databases within the SQL Servers, i. e. the collection of objects holding data that is the tables, view, indexes, triggers and so on. This terminology that ServiceNow uses is all mixed up and confused. It will not bring understanding and clarity to anyone. It will just contribute to the, since long time, ongoing confusion in this field.

rgds Christian Eriksson