As per the title - I am trying to determine the minimum and recommended system specifications for an MSSQL offload database. Tried searching but haven't found anything of use.
Thanks
Hi Ben,
Unfortunately there are no fixed requirements for the central DB setup, as this depends on the intentions for this DB.
The very bare minimum requirements to run a Microsoft SQL server can be found here: https://docs.microsoft.com/en-us/sql/sql-server/install/hardware-and-software-requirements-for-installing-sql-server-ver15?view=sql-server-ver15
In my opinion those minimum requirements are very low, and personaly I would go higher.
The requirements for your central database setup will depend on the amount of data that you want to offload, how long you want to store the data, and on the intensity of how much data will be read from this DB.
Bare in mind also that once offloaded we no longer maintain the data and you'll be responsible for removing old data from the central database.
I would at least suggest a raid setup with separate disks for the data storage (so not on the disk running the OS).
It's a good idea to look at the total size of the local databases of the DMAs in your cluster and make an estimation of the portion of this data that you plan to offload.