Solved

SharePoint 2010: Opening document -- "Contacting server for information" for a long time

Posted on 2010-11-19
7
3,865 Views
Last Modified: 2012-05-10
I've created a virtual lab environment with Windows Server 2008 R2 servers, SharePoint Server 2010, SQL Server 2008 R2, Exchange Server 2010, and Windows 7 with Office 2010.

Please note that this environment works very well performance wise and in other ways; the SharePoint sites loads fast for instance and everything is good -- except for one thing:

Question: When opening an Office document (Word 2010 or Excel 2010) from a document library, it takes unacceptable long time, up to a minute just to open the document, while the splash screen is showing; most of the time it says "Contacting server for information".

Also, for instance, when I check in a document, it might take minutes; everything I do with Office documents in SharePoint 2010 just takes so long time.

(If working with Office 2010 outside of SharePoint, so to speak, it is super fast.)

Anybody know why this is, and what I can do about it?

0
Comment
Question by:Jack_A_Roe
  • 3
  • 3
7 Comments
 
LVL 7

Expert Comment

by:luceysupport
ID: 34172228
Sounds like your database inserts.

Everything else you describe will use caching so pages will load fast.

But uploading and downloading docs use the database so I would take a look there.

Check sql profile to see how long the queries are taking and check the cpu on the server when waiting for your docs to download/upload
0
 

Author Comment

by:Jack_A_Roe
ID: 34173012
Thanks for your suggestions! Well, what I can see is that the disk is too slow (was this a production environment) -- I've been doing some research with performance monitor on VM and host.

But fact is, that if I work with pictures ten times larger or more, there's no lag at all; whether I upload, check our, check in, etc. Also, uploading a large PDF is fast and without any performance hit.

But, once again, if I open a just about empty Word file, it takes ca 40 seconds. I also get these "lags" when checkin out/in etc; but disk etc is not a bottle neck on SQL server.

It does seem to me to be something the Office docs are trying to do which simply takes time...?
0
 
LVL 7

Accepted Solution

by:
luceysupport earned 500 total points
ID: 34173122
The only difference between the office docs, check in etc and other docs is that the check out/in and office intergration use web services.

Install fiddler and run it while you are checking out a doc. This will show you the exact web service it is calling. Then note the times and see if there is a bottle neck on these web services.

I hope this helps
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Author Comment

by:Jack_A_Roe
ID: 34186268
Thank you for your suggestion. I've been toying around with Fiddler now, but being rather far from a web expert, I'm not sure it is helping me. - Also, now that I've started all the virtual mashines, that I shut down Friday, things are working alot smoother.

I'll let the question hang in here a little while, if somebody who has experienced the same problem has something to share.
0
 

Author Comment

by:Jack_A_Roe
ID: 34187674
Nope, I was wrong about "smoothness": Saving a document for instance takes minutes. :-(  Only Office 2010 docs, not pics or pdfs or whatever else, demands very long time to do whatever.
0
 

Expert Comment

by:davidlopan
ID: 34241479
I had the same issue.  I used Fiddler to detect a conflict between opening Office files on SharePoint and the Symantec Backup Exec DLO agent.  As soon as I shut down the Backup Exec agent, the files opened within a reasonable time.  I'm not sure if this helps, but maybe you have some sort of backup program running as well that is causing a conflict?
0
 
LVL 7

Expert Comment

by:luceysupport
ID: 34244016
Have you any virus software running, if so maybe stop it and see if this changes anything.
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Work Over Net is a new and very powerful collaboration product. With its new easy interface it is becoming very competitive to other similar products like webex and office interactive. WON 2010 have the standard business tools needed for multi-offic…
I used to be SharePoint evangelist in our company, so my Outlook always full of questions about how to do this, or where I can find that. One day I found such an email with the following question: "how to attach 3-State workflow (one of the workflow…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

837 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