Sage 500 RAID Configuration

Hello Everyone,
We are in the process of setting up our new server and was wondering if Sage 500 will work in a RAID environment? The SQL Server will be running in a VM and we have 16 1TB SSD drives to "play" with.What RAID configuration would be best or is it even possible?

Also, is it still common to separate the Data, log, and index onto separate drives?

Thanks in advance for any advice.

Jason

Parents
  • 0

    Sage 500 is hardware agnostic in that respect, you can array the drives SQL uses however you like. Depending on the storage array you're using, RAID 1+0 probably work best. Data, logs and tempdb should generally reside on different arrays in a simple RAID solution, it's your choice on where you locate indexes since the Sage tools will only create them on the primary. The more configuration features you enable within the engine or database the more you need to test and maintain the solution yourself. For example, the Sage database upgrade doesn't like memory-optimized objects, native or encrypted code, foreign key constraints or column store indexes within the app database. Version 2023 databases are set to SQL 2012 compatibility out of the box and begin to encounter performance problems if you go above that in an upgraded database due to the legacy code constructs (especially with a large database). There are ways around the performance issues, including some that Sage builds into the code base these days, you just have to sometimes be creative with your solutions. Don't forget about memory and CPU allocated to the VMs.

  • 0 in reply to Contefication

    Thank you for the quick response. Our "IT" company has setup the Hypervisor on a RAID 5 with 2 hot spare drives. They want to keep it this way and setup virtual drives for the data, logs, and temp drives. I'm sure that i read in one of the compatibility sheets that Sage 500 is not compatible with RAID 5 but i can't find the documentation now. We have a relatively small database (less than 10GB), 20 users. Our new server is probably overkill, more than enough cores and 128GB RAM. All drives are SSD. Should i keep the configuration the way they have it or insist that they recreate the drives....Thoughts?

  • 0 in reply to Ostrem

    Seems like pretty low volume and a small db. With modern storage devices even RAID 5 should be fine. More than enough memory, so it should perform more than adequately, but only you can really be the judge of that.

    Sage 500 Compatibility Guides:

    kb.sage.com/.../viewContent.do

Reply Children
No Data