Hello,
For a distributed installation of FME Server, what are the database requirements? I imagine it will vary a bit based on number of jobs, engines, and such, but is there a rough guideline for the volume of data the server will need to store?
Solved
FME Server Database Specs
Best answer by geosander
You mean for the internal database? I wouldn't know exactly, but unless you have a ridiculously large setup, I wouldn't worry about it.
The database is only used to store some basic job properties, queues, engine properties and stats. Nothing major (especially if you run cleanup jobs every now and then), and the CRUD-traffic is low. I am quite sure that you can even run it next to your FME Server core (same machine) without affecting performance, especially if it uses an SSD.
Rather focus on enough RAM and (SSD) disk space on your engine machines!
+7You mean for the internal database? I wouldn't know exactly, but unless you have a ridiculously large setup, I wouldn't worry about it.
The database is only used to store some basic job properties, queues, engine properties and stats. Nothing major (especially if you run cleanup jobs every now and then), and the CRUD-traffic is low. I am quite sure that you can even run it next to your FME Server core (same machine) without affecting performance, especially if it uses an SSD.
Rather focus on enough RAM and (SSD) disk space on your engine machines!
+6- Contributor
Hi, The FME Server DB is extremely small, i think it is about 100MB +/-
The up-time of the FME Server DB is critical, without that not a lot works.
Ours run in the Corporate SQL Server farm, with high availability.
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.