Server Setup

Kinetic ERP
, ,
1

Building a new server setup for moving to and testing 2025.2.10. I’m trying to find the line where “best practices” become overkill.

We’re a relatively small company, licensed for 50 users.
This is our current server setup. These were setup by IT so I can’t give you too many specifics about the architecture.
SQL Server - 96gb Ram, 2 sockets - 24 processors. Our database is ~120gb
App Server - 32gb ram, 1 socket - 4 processors

  1. Is it worth it to move the SSRS Service to it’s own VM? I’ve been doing some research and have gotten conflicting information about it’s affect on performance. From what I can tell, leaving the report database on the same sql server is fine, but moving the service to another VM could improve performance. Again, best practices vs overkill..

  2. About drive setup on the SQL server.
    Should the .mdf and .ldf for ReportServer, ReportServerTempDB, and SSRS Database be on separate drives than the application database data and log files? There’s a whole bunch of technical stuff about clogging up I/O that’s out of my wheelhouse.
    Setup
    C - Windows OS
    E - SQL Application
    F - Data (.mdf for everything)
    G - Logs (.ldf for everything)
    H - Backups
    I - TempDB (.mdf and .ndf)

We’re going to be on-prem with this setup at least until I retire on 12/31/2029…

1 Like
2

Without knowing the transaction amounts and how heavily the system is used it is hard to say what you really need. Just going by user count is IMHO not a good way to size things.

I would argue that with a 120 GB database (again without knowing how long you have been on epicor to get to that size or how many transactions you put through) most of these specs are probably overkill.

For our SQL Server here we have nVME drives that we store our databases on and the Data and Log files live on the same disk, different disks for different instances but everything is virtualized. All of the other Temp/Report/etc dbs just live with the SQL Install like normal.

I also probably wouldn’t both splitting SSRS onto its own server for performance only reasons, I do no think you would see any performance gain from that TBH.

1 Like