Avatar of Daniel Bertolone
Daniel BertoloneFlag for United Kingdom of Great Britain and Northern Ireland

asked on 

Slow opening of excel docs via network share

 
Just setup a new client of mine with a sbs 2008 server. Server is running 12 GB ram & has raid 1 for os & raid 5 consisting of 3 146 10k sas drives for the data.
 
The end users are suffering extreme slow down on their workstations when they to an open an excel document from the data drive. It can take up to a minute to either open or save a document.
 
I think i have narrowed it down to the on access scanner (savservice.exe) on both the server & workstation as when i disable this option the slowdown is no longer current.
 
I do realise this is a security risk but i would have thought the server specification would easily be able to handle what the client is throwing at it without any issues.
 
SoftwareNetwork SecuritySBS

Avatar of undefined
Last Comment
Daniel Bertolone
Avatar of Shreedhar Ette
Shreedhar Ette
Flag of India image

- Run SBS 2008 Best Practise Analyser tool and fix the errors reported.

- Also refer this previuosly answered question:
https://www.experts-exchange.com/questions/24336198/Extremelly-slow-LAN-speed-on-Server-2008-and-SBS-2008.html
Avatar of optionpc
optionpc

This is an issue with SMB (Server Messaging Block) 2.0 and OpLocks (Opportunistic Locking). You need to disable SMB 2.0, first on just the affected user’s machine and if necessary on the 2008 server it is accessing.
 
SMB 2.0 only works between Windows Vista or Windows 7 and a Server 2008 box. If you have Windows XP or Server 2003 SMB 2.0 is not your problem!
 
Disabling SMB 2.0 on Windows 7 or Windows Vista:
 
From Windows 7.0 you need to run CMD.exe in elevated mode (run as administrator) and issue the following commands:
 sc config lanmanworkstation depend= bowser/mrxsmb10/nsi
 sc config mrxsmb20 start= disabled
 
Disabling SMB 2.0 on Server 2008
 
Note that disabling SMB 2.0 on your problem Windows 7 or Windows Vista machines is enough to stop SMB 2.0 from being used. You should only disable SMB 2.0 on Server 2008 if disabling the client desktops using the command above has failed!
 
Open Regedit and browse to this key…

HKLM\System\CurrentControlSet\Services\LanmanServer\Parameters
 
Add the DWORD key with the name Smb2 and set the value to 0 to disable SMB 2.0.
 
Reboot the server.
Avatar of Daniel Bertolone

ASKER

I saw that option on the net but the clients are running windows xp. However the server is sbs 2008 so do you think smb could be causing the issue?
Avatar of optionpc
optionpc

No, SMB 2.0 would not affect an XP client.
Avatar of Daniel Bertolone

ASKER

Attached are the bpa results. Is there anything there that could cause the slow down? User generated image
Avatar of Daniel Bertolone

ASKER

I looked at the articles and disabled TCP Checksum, IP Checksum & TCP Offload. I also changed the duplex speed on the server from auto negotiation to 1000/Full but still get the same issues.

I have investigated further and the issue seems to be with Sophos on access scanner (savservice.exe). When i look at task manager when trying to open the document cpu activity is at 99%. When i disable the function the slow down disappears but the machines are at risk. I have since spoken with sophios and it seems there is not much else that i could try.

Could the issues raised in BPA have any effect?
ASKER CERTIFIED SOLUTION
Avatar of Daniel Bertolone
Daniel Bertolone
Flag of United Kingdom of Great Britain and Northern Ireland image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of Daniel Bertolone

ASKER

The solution turned out to be that sophos was causing the slow down
SBS
SBS

Small Business Server (SBS) is a line of server operating systems targeted at small businesses by bundling the operating system with a number of other Microsoft products that would normally need to be purchased or licensed separately. The most notable inclusions are Exchange, SQL Server, SharePoint and ISA/TMG (Microsoft's firewall and proxy server).

59K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo