SQL Server 2008 runnning super slow with 4GB ram & a AMD Six-Core Opteron 8439 CPU

Toggle sidebar Toggle sidebar
A

Absiin

Reputable
Aug 21, 2014
7
0
4,510
Hi everyone :)

I work in a software house and am really struggling to find out answers for one of our customer's problems...

They're running CRM and a few other DB's (including the one needed to run our own software which is over 20GB) from a SQL server 2008.

It is running soooo slow and painfully but I can't really find information online about the memories and processor used.

The terminal server is really slow as well, CPU is constantly high but it has around 2GB free memory...

What would you guys recommend that would be able to handle that kind of information?

PS. customer is using Citrix environment with virtual machines...
 
Sort by date Sort by votes
RobCrezz

RobCrezz

Expert
Ambassador
Mar 14, 2013
19,080
99
75,190
Get a SQL admin to check how much RAM SQL instance is allowed to use, it must be limited otherwise SQL usually takes everything it can get. 4gb is mega low on a highly used SQL server too..


Check Perfmon to see what it getting high utilization. I suspect its thrashing the disks like crazy, causing a huge bottleneck, due to the low amount of ram, and/or SQL being allowed so little RAM.
 
Upvote 0 Downvote
T

TommyJay1212

Honorable
Aug 13, 2013
10
0
10,510
VM will utilize a lot of processing power because of the multi os system running. Assuming that the sql database is written efficiently. I think the amount of memory would need to be upgraded especially if you are running VM and SQL I would have 4 gb for a barebones web server. Check all processes under the task manager to see how much memory sql is using unless thats what you meant by 2 gb of free memory. Keep in mind standard edition of sql will try to use up to 64 gb of memory which could really slow your server. You can change the limit of memory sql uses by default its set to as much as possible. If memory is the issue I would recommend upgrading and utilizing as many memory slots as possible as this will divide the work load. The next bottleneck would be the speed of the hard drives. SQL drives should have at least 10k rpm or 15k.
 
Upvote 0 Downvote
You must log in or register to reply here.

TRENDING THREADS

Latest posts

Moderators online

Share this page

COMPANY
RESOURCES
FOLLOW
Top Bottom