[BUG] Create Database PerformanceMonitor Doesn't Account For model DB

[Ghriogair]

Component

Installer (GUI)

Performance Monitor Version

2.4.1

SQL Server Version

Microsoft SQL Server 2016 (SP2-CU1)

Windows Version

Windows Server 2016 Datacenter

Describe the Bug

Installer fails with the following error:
The CREATE DATABASE statement failed. The primary file must be at least 5120 MB to accommodate a copy of the model database.

The model DB has been configured with 5120MB data file and 1024MB log file. Although the 01_install_database.sql script retrieves the server data and log directory information, and SQL version, it does not account for that fact that the hardcoded data and log file sizes in the script do not meet the requirements defined in the model DB.

Steps to Reproduce

1. Size the model DB to be bigger than the hardcoded file sizes used in the 01_install_database.sql.
2. Run installer.

Expected Behavior

It would be helpful if the script accounts for the model DB file sizes and uses those in the CREATE DATABASE statement.

Actual Behavior

Installer script failed.

Error Messages / Log Output

Msg 1803, Level 16, State 1, Line 48
The CREATE DATABASE statement failed. The primary file must be at least 5120 MB to accommodate a copy of the model database.

Screenshots

No response

Additional Context

No response

[Ghriogair]

I overcame the issue by manually creating the PerformanceMonitor database, and also running the subsequent ALTER DATABASE command in the create database section in the 01_install_database.sql script prior to running the installer.

[erikdarlingdata]

@Ghriogair ooh that's a fun one! I never thought of that (obviously). Thanks for reporting! I'll get the robots on it asap.