Solved

High RAM usange on SBS2008 cause network drops?

Posted on 2010-11-18
12
786 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
 

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
What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 

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

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
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…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

757 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now