Talk:Data Warehouse/@comment-110.174.173.27-20200728120953/@comment-110.174.173.27-20200728121925

Let me elaborate...a DW and SCOM are not related.

DW facilitates reporting SCOM is a specific piece of software for monitoring server performance. A DW is related to SCOM as much as itunes is.

A DW is not hosted in SQL server. A DW MAY be built on a SQL server but SQL server is one brand of software. A DW or DB could be built in Oracle, Firebird or even excel.

The size of the db is irrelvant. 100 tables is actually very small but tables is not a valid metric for measuring the storage size of a DW.

A DW or DB does not correlate to performance. The designs used in eiher will impact performance.

Size would not be a primary driver for modifying rention of data. You would not comprmose the business needs for this. It would be like saying, we are going to throw out all the stock in our store cause we don't want to have to count higher than 10 when we do a stock take.