Solved

High RAM usange on SBS2008 cause network drops?

Posted on 2010-11-18
12
789 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
  • 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
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

 

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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering 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

If you are a user of the discontinued Microsoft Office Accounting 2008 (MSOA) and have to move to a new computer running Windows 8, you will be unhappy to discover that it won't install.  In particular, Microsoft SQL Server 2005 Express Edition (SSE…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

809 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