This is all very new to me, including managing from an administration standpoint so let me know if you need additional information. The docs arent helping me understand if I should be worried about capacity or not based on where I stand. 24% database storage capacity left.
I have 4 environments (Prod, Test, UAT & CDS testing). We've used SQL Server as our primary database but are looking into using the CDS specifically for apps. I'm part of a much larger tenant and have a T2 license. I only have access to my environments. We have 4 very active apps using SQL Server for 1 small team (7 active users) and are looking to roll out about 7 apps to my entire business unit using CDS (~900 people). This would require ~10 more tables, two of which are 10-20k rows.
I added the CDS only to the CDS Testing environment with 4 test tables that have very few rows in order to validate and better understand how to manage security requirements.
I'm now looking at my database storage capacity (never looked at it before), and Im little shocked at the size: 24.64% available! Should I be worried about capacity? Is this just an admin burden base due to the CDS that wont go up much as we add tables? Or could we easily go over our database capacity?
