High RAM usange on SBS2008 cause network drops?

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.
DagwoodBumsteadAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Olaf De CeusterConnect With a Mentor Commented:
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
 
Olaf De CeusterCommented:
What anti-virus are you running?
Also what server board and what Network card.
Olaf
0
 
DagwoodBumsteadAuthor Commented:
Symantec Endpoint Protection 12
HP Proliant ML350 G6 (don't know exact mobo)
HP NC326i PCIe Dual NIC
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

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.

 
DagwoodBumsteadAuthor Commented:
Thanks... I'll look over this and try them out and let you know.
0
 
DagwoodBumsteadAuthor Commented:
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
 
Olaf De CeusterCommented:
No need for script.
Olaf
0
 
DagwoodBumsteadAuthor Commented:
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
 
Olaf De CeusterCommented:
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
 
DagwoodBumsteadAuthor Commented:
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
 
Olaf De CeusterCommented:
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
 
DagwoodBumsteadAuthor Commented:
Thanks Olaf... I'm going to close and award now.
0
 
Olaf De CeusterCommented:
Only award if fixed.
Thanks
Olaf
0
All Courses

From novice to tech pro — start learning today.