9.5 DB upgrade question

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

I’m at 25 GB, a little over 6,000 computers, and about a hundred operators. Running Linux and Windows, subscribed to the patching sites for each, CIS / USGCB / FDCC checklists for each. We’re not running SUA / Inventory yet, but probably will be soon (which uses its own separate database).

Thanks for the info, but what I’m really interested in is if your DB grew immediately after upgrading to 9.5. The instructions make it sound like there will be an immediate growth of my db to do the UTF-8 conversion. Is this so?

Hmm I wouldn’t be able to say. I think I was one of the early adopters on 9.5, I’ve been running it for several months now.