Solved

SQL Performance on SBS 2011

Posted on 2014-03-15
3
413 Views
Last Modified: 2014-03-22
I've inherited an SBS 2011 server.   All services are installed on a single partition (C:)  The the customer does heavy sql work using Thompson Reuters CS.  This is a practice management solution for CPAs.

With 36 Gb RAM, everything is hideously slow and 10 users have trouble accomplishing the simplest of tasks.

Does it make sense to move the SQL instances to a separate RAID volume for better performance? (I know this is a broad\general question, but they are not on a budget that would allow them to replace the server with the correct environment.)

Thanks,
Craig
0
Comment
Question by:OnsiteSupport
3 Comments
 
LVL 35

Expert Comment

by:Cris Hanna
ID: 39932484
Part of the issue "could be" if there really is 36 GB of RAM in the server.  Server 2008r2 which SBS 2011 is based on, has limit of 32gb of Ram.   While a single partition is not the best configuration, it's not impossible.  Is this a raid 1 or raid 5 partition?  What kind of drive controller?  yes a separate partition on a good controller could help.  But the real key is running Perfmon to find the real culprit
0
 
LVL 28

Accepted Solution

by:
Ryan McCauley earned 500 total points
ID: 39946873
If you use perfmon, I'd take a quick look at the disk read/write queue for the single partition - if it's above 1 steadily, that's a problem, and it means that there's always at least one command waiting for access to the disk and the disk is never idle. This can lead to slow performance, especially if that same partition also contains the swap file (with 36GB of RAM you shouldn't need to swap, but that doesn't mean it doesn't cause a problem).

Since you're using Windows 20008 R2, you could also use the Resource Monitor (the "Disk" tab, under the "Disk Activity" panel) to get a clear picture of hard drive performance. If you sort by the latency column, what kind of values are you seeing? That will show you how long, on average, a request for something on the disk has to wait to be serviced. Values under about 25MS are pretty quick, and even values up to 100ms aren't terrible (though a bit slow), but if you're seeing values well above this, it's time to consider separate physical disks for whatever has the largest throughput - in your case, likely SQL Server.

SBS is handy because it's easy to configure and it supports very small offices well, but it doesn't scale well and it puts everything on a single server, so ramping up the load can quickly lead to contention problems like what you're seeing. Good luck!
0
 

Author Closing Comment

by:OnsiteSupport
ID: 39947342
thanks Ryan. just moving email off the server was a tremendous improvement.  Disabled the exchange services with no ill side effects.

great info!
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Server 2012 r2 licensing CALs 3 83
2008 R2 time server is invalid 6 38
Windows 10 ISO build version 3 54
Need to trim my database size 9 29
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

697 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