Solved

High RAM usange on SBS2008 cause network drops?

Posted on 2010-11-18
12
795 Views
Last Modified: 2012-05-10
I have searched for answers, but find inconclusive/ambiguous answers on this:

I have an SBS2008 SP2 server with 8Gb RAM running SQL Server 2008. The RAM usage stays high (around 93%). There are a few applications having general errors, and the event logs on the clients indicate a loss of network connectivity (file becomes unavailable). The users don't notice any disconnect, and they can rerun the program with no problem. But the errors and event log messages are consistent with a file (typically an EXE or DLL) becoming temporarily unavailable. On one workstation, it seems to after being minimized for while, and then bringing it back into focus.

Resource Monitor shows around 100 hard faults/sec.

Can the RAM bumping up against the top cause a momentary network connection drop? Any other ideas what might? I think I'm going to swap the network switch, even though there aren't any obvious manifestations of network problems. (Owner's computer: gotta do something!)

Thanks for any help provided.
0
Comment
Question by:DagwoodBumstead
[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
  • 6
  • 6
12 Comments
 
LVL 22

Expert Comment

by:Olaf De Ceuster
ID: 34170112
What anti-virus are you running?
Also what server board and what Network card.
Olaf
0
 

Author Comment

by:DagwoodBumstead
ID: 34170169
Symantec Endpoint Protection 12
HP Proliant ML350 G6 (don't know exact mobo)
HP NC326i PCIe Dual NIC
0
 
LVL 22

Accepted Solution

by:
Olaf De Ceuster earned 500 total points
ID: 34170335
Please update your NIC drivers.
Once that's done, from an elevated prompt run the following commands one by one:
netsh int ip set global taskoffload=disabled
netsh int tcp set global congestion=none
netsh int tcp set global autotuning=disabled
netsh int tcp set global rss=disabled
netsh interface tcp set global autotuninglevel=highlyrestricted

In SQL Server  Managemnt Studio Express: (Run as administrator ...you might need to reactivate that account)
On all Databases set memory usage to 250Mb max.
Right click on the instance>Properties> Memory and make changes.
Also open: \\.\pipe\mssql$microsoft##ssee\sql\query and make the same changes.

I am having same issues with a couple of servers. Intel boards and Trend AV. One I fixed by adding an extra 8GB of ram, The other I fixed as above.
Both machines have been OK for 48 hours without issues.
Let me know.
Olaf
0
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 

Author Comment

by:DagwoodBumstead
ID: 34170409
Thanks... I'll look over this and try them out and let you know.
0
 

Author Comment

by:DagwoodBumstead
ID: 34170485
Will the changes above, specifically the netsh commands, remain permanent after a reboot, or do I need to script them to run each time?
0
 
LVL 22

Expert Comment

by:Olaf De Ceuster
ID: 34170492
No need for script.
Olaf
0
 

Author Comment

by:DagwoodBumstead
ID: 34170536
I've made most of the changes, but:

"Also open: \\.\pipe\mssql$microsoft##ssee\sql\query and make the same changes."

I'm not sure how/where to do this?
0
 
LVL 22

Expert Comment

by:Olaf De Ceuster
ID: 34170545
It is the MSSQL DB used by SBS2008.
In SQL Server  Managemnt Studio Express:
Copy this instance  \\.\pipe\mssql$microsoft##ssee\sql\query as Server Name.

If you can't open this instance you might have updated it to a full sql instance. It will be available in the drop down list under another name. Just trottle the ram on that one instead.
0
 

Author Comment

by:DagwoodBumstead
ID: 34170603
Found that (I'm running SQL Studio, not Express) but copy/paste brought it up.

One last thing:

According to

http://www.windowsreference.com/windows-vista/slow-network-copy-and-connection-drops-in-windows-7/

if you type "netsh int ip show offload" after the first command above, it should display nothing... for me it still displays "supported" for everything... I realize that page references Win 7 and not Server 2008... but is there a way I can be sure that command took?

Thanks for all your help... hope this works...
0
 
LVL 22

Expert Comment

by:Olaf De Ceuster
ID: 34170621
Download the SBS BPA and run it.
http://www.microsoft.com/downloads/en/details.aspx?familyid=86a1aa32-9814-484e-bd43-3e42aec7f731&displaylang=en
Neat little tool.
It will tell you if your offload settings are correct for SBS2008.
Might as well fix all the other issues it finds while you are at it.
Olaf
0
 

Author Comment

by:DagwoodBumstead
ID: 34170635
Thanks Olaf... I'm going to close and award now.
0
 
LVL 22

Expert Comment

by:Olaf De Ceuster
ID: 34170648
Only award if fixed.
Thanks
Olaf
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Sum of items in two tables not equal. 5 64
Exchange Calendars 8 59
Split string into 3 separate fields 5 36
SQL Server replace between tags 6 27
Because virtualization becomes more and more common, and, with Microsoft Hyper-V included in Windows Server at no additional costs, and, most server hardware nowadays is more than capable of running a physical Small Business Server (SBS) 2008 or 201…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

739 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