Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

High RAM usange on SBS2008 cause network drops?

Posted on 2010-11-18
12
Medium Priority
?
804 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 2000 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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 

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

Does Your Cloud Backup Use Blockchain Technology?

Blockchain technology has already revolutionized finance thanks to Bitcoin. Now it's disrupting other areas, including the realm of data protection. Learn how blockchain is now being used to authenticate backup files and keep them safe from hackers.

Question has a verified solution.

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

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…

722 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