|
|
|
|
|
|
by mb_72
3539 days ago
|
|
|
We've got 10-12 users connected to a SBS 2013 server with a couple of RAIDed HDDs and 8GB RAM, and - yes - the SQL Server service pegs out at the maximum allowed RAM (which I think is 1GB or so) pretty much the whole day. However the performance is deemed much more than acceptable, even though no doubt a lot of query results are getting booted out of RAM way too soon. We've still got a trick up our sleeves in terms of performance boosting by moving the server to SSDs instead of magnetic drives. FYI all my other clients running 'Express' consist of small companies with 10 or fewer users, and they are more than happy with performance (or at least aren't willing to pay the large MS fees for a 'proper' version of MS SQL Server). |
|
|