Solved

Slow server

Posted on 2014-01-30
7
745 Views
Last Modified: 2016-11-23
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.
0
Comment
Question by:Alex Angus
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
7 Comments
 
LVL 3

Expert Comment

by:BertSublime
ID: 39820759
Have a look at the Resource monitoring (Under The performance tab on the Task Manger)

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.
0
 
LVL 88

Accepted Solution

by:
rindi earned 500 total points
ID: 39820767
Is this all on the same server OS? DC, TS, SQL? All those should be setup on separate 2008 r2 OS's (A TS should never also be a DC and run SQL server, and also a DC should never run SQL server), That configuration isn't supported by m$ and it is also advised strongly against doing.

If you want to run this on the same hardware, set it up as Hyper-V or ESXi host, and then run 3 x 2008 r2 Server OS's on that host, one the DC, the 2nd for TS, and the 3rd for SQL.

Adding RAM can never be wrong.
0
 
LVL 16

Expert Comment

by:gurutc
ID: 39820838
Agree with rindi on this.  Even with low usage it's a bad idea to put all that on one server.

- gurutc
0
PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

 

Author Comment

by:Alex Angus
ID: 39821181
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.
0
 
LVL 16

Expert Comment

by:gurutc
ID: 39821637
Move any of the functions and it will help.

- gurutc
0
 
LVL 10

Expert Comment

by:tmoore1962
ID: 39821910
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.
0
 
LVL 88

Assisted Solution

by:rindi
rindi earned 500 total points
ID: 39821926
I'm not an m$ license expert, but as far as I know the client CAL's you already own should be fine.

One Option I think you have is to get an SBS 2011 Standard with Premium add-on. That would give you the SBS 2011 server license (which is a 2008 r2 server), along with a 2nd 2008 r2 server license. You'd then have enough licenses for your 3 server OS's. You can run these under Hyper-V, so that would also be no problem, and if the 20 TS users reflects the number of your total users, SBS should also be fine too.

You could run all these OS's on the same hardware, provided it is powerful enough, but of course you could also run part of it on the microserver, maybe the SQL part.

Also, you can add 2012 servers to your environment, that should not be a problem with the licenses you already have. You just need the additional server licenses.
0

Featured Post

Is Your DevOps Pipeline Leaking?

Is your CI/CD pipeline a hodge-podge of randomly connected tools? You’ve likely got a tool to fix one problem & then a different tool to fix another, resulting in a cluster of tools with overlapping functionality. Learn how to optimize your pipeline with Gartner's recommendations

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
In this video, we discuss why the need for additional vertical screen space has become more important in recent years, namely, due to the transition in the marketplace of 4x3 computer screens to 16x9 and 16x10 screens (so-called widescreen format). …
The viewer will learn how to successfully create a multiboot device using the SARDU utility on Windows 7. Start the SARDU utility: Change the image directory to wherever you store your ISOs, this will prevent you from having 2 copies of an ISO wit…

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question