MIS Systems Thread, SIMS Server Hardware Spec in Technical; Swings and Roundabouts I suppose, I do get a lot of increase when the admin staff are running large reports ...
Swings and Roundabouts I suppose, I do get a lot of increase when the admin staff are running large reports or other housekeeping tasks and has no affect on the performance of Sims for other users.
Bulk uploading student photos is now a painless task, for me the additional memory sitting there does come in use at some point (I have never fully used 20GB but have gone over the 16GB)
I am still yet to upgrade to Solus3 (holding back as long as I can to be honest) hate sitting on needles.
I'm pretty sure if you give SQL 120GB to play with, it will happy make use of it somehow. It's just not needed for what is really a fairly small program, even with it's memory leaks!
I have 20GB of RAM and on the second day (Log Growth) the database can use as much as 12GB RAM (Virtual Memory is Disabled) - 30GB for me would be a decent amount for the Sims Server (also consider additional database's and services that you may run on the same server (Discover, Intouch) as well as other MIS systems that Syncs with Sims (Oliver, Cashless Catering) etc..
For me I say (If purchase of a new server is agreed then no harm in adding as much memory) considering you could take some out and slap it in another server you been dying to get memory for.
Its actually a downside to order too much RAM for a SQL server as it will use as much as it can get.
Just because it is using it, does not mean Sims needs it. Thats just how SQL server allocates resources.
Its actually a downside to order too much RAM for a SQL server as it will use as much as it can get.
Just because it is using it, does not mean Sims needs it. Thats just how SQL server allocates resources.
4GB is fine.
Indeed. This concept is why MS tell you to put a limit on the SQL server when you're setting up SCCM and SCVMM, as it isn't so efficient to just let it run riot.