SCOM DB and DW data and log files

Question

I know the size that our Data Warehouse DB should be according to the sizing chart provided by Microsoft. However, what should be the size allocated initially to the Data and Log files? How is that broken up within SQL? If our DW DB will grow to a max of 650 GB over a year, how much of that is data, logs, and temp files? Only asking so we can build the DW Server correctly and allocate the correct amount of space for each drive.

We have around 4000 windows servers and 500 Unix servers and planning to migrate agents in phases. The database retention has been adjusted . Please advise

Answer 1

@py ，For the initial database sizing, we can use tool "Operations Manager Sizing Helper" to calculate the initial DB size. Here are links for the reference:
https://learn.microsoft.com/en-us/system-center/scom/plan-sqlserver-design?view=sc-om-2019#initial-database-sizing
https://techcommunity.microsoft.com/t5/system-center-blog/operations-manager-2012-sizing-helper-tool/ba-p/345075

For the data, log and temp db size, we can check it under the database location. For example, in my lab, it is under "C:\Program Files\Microsoft SQL Server\MSSQL14.SCOM_OPSMGR\MSSQL\DATA".

Hope it can help.

---

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.