I was reading the change log for the 9.5 upgrade and it mentions DB growth, the exact line is this.
“The basic rule of thumb for the upgrade to V9.5 is to ensure that you can accommodate a 100% growth in the size of the actual database (twice the size of your current database). The additional space is required to manage the growth of tables for UTF-8 transcoding, including the allocation of temporary space for the movement of data within the BigFix databases. For Windows deployments, the database size can be determined through the Microsoft SQL Server Management Studio. For Linux deployments, the get_dbsize_info procedure canbe used.”
I have a few deployments that shipped with SQL 2008R2 Express an so they are limited to 10GB. I don’t know what size each of the DB’s are today, but I can probably guess that if they grew 100% then they’d be over 10GB or very near it. What is happening with people’s DB size in the real world? What is your experience?
Thanks