?
Solved

Opening XLS DOC on Windows 2008 SBS network share slow

Posted on 2010-09-22
12
Medium Priority
?
1,035 Views
Last Modified: 2012-05-10
I have setup a Windows Small Business Server 2008, fully updated, and I get long (about 45 seconds to 2 mins) to open XLS and DOC files on a network share residing on this server.

The workstation is Windows 7 Professional fully updated and I get the lag in Office 2007 and 2010 when clicking directly on the file in the share via the windows explorer.

When opening the file directly from the program (Excel or Word) I get no lag.

Furthermore I get the lag only when opening my first (doc or xls) file of the day, all subsequent files open fast from explorer or the application itself.  All XLSX or DOCX work like a charm even the first time.

Seems to be related to the first file opened in ''compatibility mode''.

This is what i tried so far.

- Disabled and uninstalled all anti-virus from both server and workstation to no avail
- Disabled all gpos on the SBS
- Tried DDE tweaks and the % for DOC and XLS
- NoNetcrawling Registry tweak
- added full domain name to the network share (example : \\server.company.local\share
- added the network locations in excel 2007 or 2010 in the trusted locations
- added the network location as trusted in Internet explorer (example : \\server.company.local\* )

I tried so many things, I probably forgot a few...

I'm running out of ideas.

0
Comment
Question by:TimeBomb
[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
  • 5
12 Comments
 
LVL 2

Expert Comment

by:S_Todd
ID: 33735575
Are you sure the 'lag' is not just the application starting up on the machine for the first time.

Can you:

1. Open the application - say excel
2. minimise excel
3. Browse via explorer to an excel spreadsheet and open

Is there still the lag? If not, sounds like it is just the app starting
0
 
LVL 7

Expert Comment

by:jesaja
ID: 33738846
please provide informations on you storage configuration

Raid level, stripe size, hd type and qty, array controller type, sever hw type

network speed
0
 
LVL 7

Expert Comment

by:jesaja
ID: 33738850
and av software
0
Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

 

Author Comment

by:TimeBomb
ID: 33738916
Maybe I was unclear :

If I had started, say Excel, then an XLS file from the server share via explorer, it hangs about 45 secs to a couple minutes on only the first XLS file of the day. Even if Excel was opened prior.

If I were to open Excel then a XLSX, the file comes up rapidly.
If I were to open a XLS file subsequent to that XLSX file and it's the first daily XLS file I get from the server share i do get lag or hangtime.

After that first hang, I can get all XLS or DOC files and no more hangtime or lag for the whole day

So no it does not help to open the application before hand.


Another thing I had done on the server and workstation, I disabled the NIC sleep function.
0
 

Author Comment

by:TimeBomb
ID: 33739016
I have experienced this behavior on all of my customers SBS2008 environments with Windows 7 as a Workstation and Office 2007 or Office 2010.  User rights are local admin on their own PC.

To be specific on material, many are using ASUS Z8NA-D6C MB, RAID1, Default Stripe Size on Intel ICH10R,
Disk size 500GB.

Network speed is Gigabit.

NOD32 anti-virus
0
 
LVL 7

Expert Comment

by:jesaja
ID: 33745942
this then points to a different cause of the problem


It think it has something to do with SMB 2.0 and maybe IPv6

I would update first the SMB 2.0 hotfixes
0
 
LVL 7

Expert Comment

by:jesaja
ID: 33745961
»support.microsoft.com/kb/973554
»support.microsoft.com/kb/950836
»support.microsoft.com/kb/955427
»support.microsoft.com/kb/958702
0
 
LVL 7

Accepted Solution

by:
jesaja earned 1000 total points
ID: 33745985
0
 

Author Comment

by:TimeBomb
ID: 33754451
I will try the proposed solutions this week-end and get back to you monday.

thanks
0
 

Author Comment

by:TimeBomb
ID: 33823074
I tested all hotfixes that applied, it did not solve the issue.

I tested with SP2 for Windows 2008, it did not solve the issue.

But disabling SMB2 on both the Small business server 2008 and Windows 7 clients seems to have solved the issue.

I will test for a few days and award the points if it sticks.

Will there be any performance downside to disabling this feature?
0
 
LVL 7

Expert Comment

by:jesaja
ID: 33823956
SMB 2.0 is supposed increases performance for copying date, latency issues etc.

but if you happy with the current network performance and if you don't have any latency issues I wouldn't care
0
 

Author Comment

by:TimeBomb
ID: 33846947
It does not seem to slow things down at all...  I'll keep an eye on it, but for now all is great.

Thanks again for helping me resolve this issue!
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
The Windows functions GetTickCount and timeGetTime retrieve the number of milliseconds since the system was started. However, the value is stored in a DWORD, which means that it wraps around to zero every 49.7 days. This article shows how to solve t…
The Task Scheduler is a powerful tool that is built into Windows. It allows you to schedule tasks (actions) on a recurring basis, such as hourly, daily, weekly, monthly, at log on, at startup, on idle, etc. This video Micro Tutorial is a brief intro…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

800 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