Alex Angus
asked on
Slow server
Belarc shows the following:
Dell R720 Server
Dual Xeon E5-2620 2.00 Ghz
16G memory
Windows Server 2008 R2 SP2 (64bit)
MS SQL 2008 R2 (64Bit)
Remote Desktop with 20 TS users
Set up as DC
Basically runs Sage 300 (Accpac) on SQL with 20 remote users.
Users complain very slow. Sometimes it just stops and they have to reboot the server.
I suggested adding another 32Gb or 64Gb of memory.
Is this the correct suggestion?
SQL had no configuration so I set it to one CPU and 8Gb memory. This seems to be the best performance.
Dell R720 Server
Dual Xeon E5-2620 2.00 Ghz
16G memory
Windows Server 2008 R2 SP2 (64bit)
MS SQL 2008 R2 (64Bit)
Remote Desktop with 20 TS users
Set up as DC
Basically runs Sage 300 (Accpac) on SQL with 20 remote users.
Users complain very slow. Sometimes it just stops and they have to reboot the server.
I suggested adding another 32Gb or 64Gb of memory.
Is this the correct suggestion?
SQL had no configuration so I set it to one CPU and 8Gb memory. This seems to be the best performance.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Agree with rindi on this. Even with low usage it's a bad idea to put all that on one server.
- gurutc
- gurutc
ASKER
Yes it is all on one server.
I know that is not the ideal, but this is what we have been given.
I am no expert at this as ERP Consultant is my business, not hardware and OS.
I know at another client the IT guys installed a small HP MicroServer and moved the DC there on its own. Slightly different to this site but I was wondering if that would work here to offload some load from the server. I do not know how to prove what is chewing up the resources. I have looked at Task Manager.
If I give them the suggestion of Hyper-V as above, it means they would need to buy 2 more Server OS's. Not so?
They would need to buy same Server 2008 R2 Standard so that the cals, which are for 2008, can be used. Or will the CALS work with Server 2012? I believe not.
If the DC is on another server, like a MicroServer, would it be ok to leave the TS and SQL on the main server?
I guess the question boils down to this. If you had money for another 32Gb memory and a small MicroServer, but not for a whole new server, would you spend it like this?
or
Would you stick with 16Gb memory, go Hyper-V (I guess 2012R2) and buy 2x Server 2008R2?
At the end of the day it boils down to budget.
Appreciate your thoughts in this not perfect situation.
I know that is not the ideal, but this is what we have been given.
I am no expert at this as ERP Consultant is my business, not hardware and OS.
I know at another client the IT guys installed a small HP MicroServer and moved the DC there on its own. Slightly different to this site but I was wondering if that would work here to offload some load from the server. I do not know how to prove what is chewing up the resources. I have looked at Task Manager.
If I give them the suggestion of Hyper-V as above, it means they would need to buy 2 more Server OS's. Not so?
They would need to buy same Server 2008 R2 Standard so that the cals, which are for 2008, can be used. Or will the CALS work with Server 2012? I believe not.
If the DC is on another server, like a MicroServer, would it be ok to leave the TS and SQL on the main server?
I guess the question boils down to this. If you had money for another 32Gb memory and a small MicroServer, but not for a whole new server, would you spend it like this?
or
Would you stick with 16Gb memory, go Hyper-V (I guess 2012R2) and buy 2x Server 2008R2?
At the end of the day it boils down to budget.
Appreciate your thoughts in this not perfect situation.
Move any of the functions and it will help.
- gurutc
- gurutc
1 wouldn't run a DC, Sql, and RD server all one server, but since you are you need to make tweaks to limit the sql memory usage to 4-6GB so that you have memory for the RDP sessions. I would also have NIC teaming going if the server supports it to increase the through put (don't forget to provision your switch ports for the teaming). More Memory would also be good but you still have to tweak the sql as by default it will want to use as much of the server's memory that it can. If you sql db is big definitely have to increase memory as well as manage sql usage of it.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Look at the disk usage and disk queue. see if there is a large queue during the slow periods.
SQL can be quite disk intensive.