PC Review


Reply
Thread Tools Rate Thread

Saving Excel files to Win 2003 Server very slow

 
 
chris@groupinfo.com
Guest
Posts: n/a
 
      15th Mar 2006
Hello:

We have in ongoing problem and I have not been able to find a direct
solution to it yet, and was wondering if anybody could provide some
insight.

The problem is users that are saving files to a network drive from
Excel 2003 SP2 on Windows XP SP2, to a Windows 2003 SP1 server
(Appliance Edition), takes a very long time. I watched the bytes
written in task manager... basically Excel.exe writes the total size of
the file to the destination quickly at first (creating the temp file I
believe), then the speed slows down to around 100 bytes / second as it
continues to save the file. I am testing Excel files around 200-300KB
in size, but the problem is there for all Excel files. Copying files
normally in Explorer works fine, and seems to also be fine saving from
other apps like Word, etc.

The client machine is connecting on a VPN, but this problem seems to be
specific to this Windows 2003 SP1 server. When saving the exact same
files to a Windows XP workstation to the same network as the server,
the saves go very quick as expected. So to me it seems like a Windows
2003 server issue.

Has anybody else seen this problem or know of a possible solution?
Thank you in advance for any & all feedback!

--
Chris

 
Reply With Quote
 
 
 
 
Trooper
Guest
Posts: n/a
 
      15th Mar 2006
The problem seems to be:
(The client machine is connecting on a VPN)

Direct connect to the share works, because you are not encrypting the
packets being sent to the server.
VPN is running slower than direct connect to begin with....

We would be interested in the reults of your post to the networking
group.

 
Reply With Quote
 
chris@groupinfo.com
Guest
Posts: n/a
 
      16th Mar 2006
My main post may have been misleading. Actually we are able to save
over the VPN without any problems, from an XP client to another XP
machine (through the VPN) sharing out a folder. But, when we save from
the same XP client to our Windows 2003 server through the same VPN,
that is where we see the problem. So our problem is specifically on
the Windows 2003 server only. We are doing some further tests on this
server. Also, we found that the problem also happens with MS Word
documents as well. However Acrobat documents and others do not have
this problem.

 
Reply With Quote
 
Richard G. Harper
Guest
Posts: n/a
 
      16th Mar 2006
Checked to make sure that an antivirus scan isn't slowing things down? If
documents like Word and Excel (which could contain macros that could attack
a system) are slow but other document types are not, that's where I'd start
looking.

--
Richard G. Harper [MVP Shell/User] (E-Mail Removed)
* PLEASE post all messages and replies in the newsgroups
* for the benefit of all. Private mail is usually not replied to.
* My website, such as it is ... http://rgharper.mvps.org/
* HELP us help YOU ... http://www.dts-l.org/goodpost.htm


<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> My main post may have been misleading. Actually we are able to save
> over the VPN without any problems, from an XP client to another XP
> machine (through the VPN) sharing out a folder. But, when we save from
> the same XP client to our Windows 2003 server through the same VPN,
> that is where we see the problem. So our problem is specifically on
> the Windows 2003 server only. We are doing some further tests on this
> server. Also, we found that the problem also happens with MS Word
> documents as well. However Acrobat documents and others do not have
> this problem.
>



 
Reply With Quote
 
Leythos
Guest
Posts: n/a
 
      16th Mar 2006
In article <(E-Mail Removed)>, (E-Mail Removed)
says...
> Checked to make sure that an antivirus scan isn't slowing things down? If
> documents like Word and Excel (which could contain macros that could attack
> a system) are slow but other document types are not, that's where I'd start
> looking.


Also check that auto-backup is not enabled on the documents....

--

(E-Mail Removed)
remove 999 in order to email me
 
Reply With Quote
 
chris@groupinfo.com
Guest
Posts: n/a
 
      21st Mar 2006
Thank you for the reply. We did try stopping Symantec Antivirus on
both the server and the client PC, and still the same results. We did
finally narrow this problem down somewhat after quite a bit of testing.
The problem seems to be with a specific share on our server that is
used by multiple people (I showed about 54 concurrent on average at a
given time). We compared two mapped drives from the client PC, both
mapped to the same folder on the server's filesystem, one going through
the specific share used by multiple people, and also a share only used
by the client PC user. For example, one drive is mapped to
"\\server\home\userfolder" and the other drive is mapped to
"\\server\userfolder" ; both point to the same exact folder on the
server. The performance on the share used by multiple people was quite
poor (\\server\home\userfolder), and showed all the signs of our
initial problem (Word/Excel writing back around 100 bytes/sec.).
However the share used by only the client PC user (\\server\userfolder)
was significantly faster.

Our server has more than enough resources (dual Xeon 3.0 GHz, 2 GB RAM)
and CPU usage is quite low (< 10%) and only about 25% of the physical
memory is being used. Plus I would think that if the server was being
taxed somehow that it would affect all shares.

We are trying to find any information on this type of problem, and so
far come up empty handed. Has anybody seen this type of problem
before?

Thank you again for all feedback and help!!
--
Chris

 
Reply With Quote
 
Malke
Guest
Posts: n/a
 
      21st Mar 2006
(E-Mail Removed) wrote:

> Thank you for the reply. We did try stopping Symantec Antivirus on
> both the server and the client PC, and still the same results. We did
> finally narrow this problem down somewhat after quite a bit of
> testing.
> The problem seems to be with a specific share on our server that is
> used by multiple people (I showed about 54 concurrent on average at a
> given time). We compared two mapped drives from the client PC, both
> mapped to the same folder on the server's filesystem, one going
> through the specific share used by multiple people, and also a share
> only used
> by the client PC user. For example, one drive is mapped to
> "\\server\home\userfolder" and the other drive is mapped to
> "\\server\userfolder" ; both point to the same exact folder on the
> server. The performance on the share used by multiple people was
> quite poor (\\server\home\userfolder), and showed all the signs of our
> initial problem (Word/Excel writing back around 100 bytes/sec.).
> However the share used by only the client PC user
> (\\server\userfolder) was significantly faster.
>
> Our server has more than enough resources (dual Xeon 3.0 GHz, 2 GB
> RAM) and CPU usage is quite low (< 10%) and only about 25% of the
> physical
> memory is being used. Plus I would think that if the server was being
> taxed somehow that it would affect all shares.
>
> We are trying to find any information on this type of problem, and so
> far come up empty handed. Has anybody seen this type of problem
> before?


Not enough bandwidth. Try setting up a second file server (you can do
this cheaply with a Linux box if you like). Also look at your network
hardware and make sure it is good quality.

Malke
--
Elephant Boy Computers
www.elephantboycomputers.com
"Don't Panic!"
MS-MVP Windows - Shell/User
 
Reply With Quote
 
=?Utf-8?B?Y2FuaXNpb3Vz?=
Guest
Posts: n/a
 
      18th Apr 2006
I'm facing the same problem, additionaly i found that if u close the open
file from client the server still shows that file being used by that client
some time it close after long time, this is critical when a client cpu get
stuck while a file open other clients can't acces that file, I got some
information regarding this in microsoft website
http://support.microsoft.com/?kbid=150384
I edited the registry i feel i got some speed in file accesing but still i
face the problem when a client get stuck. this problem becs of when a client
close the file the server must disconnect that file, we have novell server as
file server i check this matter it's disconnecting closed file immediatly. i
thing if u find solution for this u can solve ur problem. I'm still tring to
get solutin for this if u hav any ideas pls reply

thanks
cani

"(E-Mail Removed)" wrote:

> Thank you for the reply. We did try stopping Symantec Antivirus on
> both the server and the client PC, and still the same results. We did
> finally narrow this problem down somewhat after quite a bit of testing.
> The problem seems to be with a specific share on our server that is
> used by multiple people (I showed about 54 concurrent on average at a
> given time). We compared two mapped drives from the client PC, both
> mapped to the same folder on the server's filesystem, one going through
> the specific share used by multiple people, and also a share only used
> by the client PC user. For example, one drive is mapped to
> "\\server\home\userfolder" and the other drive is mapped to
> "\\server\userfolder" ; both point to the same exact folder on the
> server. The performance on the share used by multiple people was quite
> poor (\\server\home\userfolder), and showed all the signs of our
> initial problem (Word/Excel writing back around 100 bytes/sec.).
> However the share used by only the client PC user (\\server\userfolder)
> was significantly faster.
>
> Our server has more than enough resources (dual Xeon 3.0 GHz, 2 GB RAM)
> and CPU usage is quite low (< 10%) and only about 25% of the physical
> memory is being used. Plus I would think that if the server was being
> taxed somehow that it would affect all shares.
>
> We are trying to find any information on this type of problem, and so
> far come up empty handed. Has anybody seen this type of problem
> before?
>
> Thank you again for all feedback and help!!
> --
> Chris
>
>

 
Reply With Quote
 
Scott Lowe
Guest
Posts: n/a
 
      27th Apr 2006
On 2006-03-15 10:20:39 -0500, (E-Mail Removed) said:

> Hello:
>
> We have in ongoing problem and I have not been able to find a direct
> solution to it yet, and was wondering if anybody could provide some
> insight.
>
> The problem is users that are saving files to a network drive from
> Excel 2003 SP2 on Windows XP SP2, to a Windows 2003 SP1 server
> (Appliance Edition), takes a very long time. I watched the bytes
> written in task manager... basically Excel.exe writes the total size of
> the file to the destination quickly at first (creating the temp file I
> believe), then the speed slows down to around 100 bytes / second as it
> continues to save the file. I am testing Excel files around 200-300KB
> in size, but the problem is there for all Excel files. Copying files
> normally in Explorer works fine, and seems to also be fine saving from
> other apps like Word, etc.
>
> The client machine is connecting on a VPN, but this problem seems to be
> specific to this Windows 2003 SP1 server. When saving the exact same
> files to a Windows XP workstation to the same network as the server,
> the saves go very quick as expected. So to me it seems like a Windows
> 2003 server issue.
>
> Has anybody else seen this problem or know of a possible solution?
> Thank you in advance for any & all feedback!


Try disabling SMB signing on the clients and the server (use the Local
Security Policy console). I have seen instances where this will affect
network performance.

HTH.

--
Regards,
Scott Lowe
ePlus Technology, Inc.

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Corrupt Excel files when saving to Win2k3 server ssk3666@gmail.com Microsoft Excel Programming 1 19th Mar 2008 03:18 PM
Saving Excel files to Win 2003 Server very slow chris@groupinfo.com Windows XP Help 8 27th Apr 2006 08:22 PM
Saving Excel files to Win 2003 Server very slow chris@groupinfo.com Windows XP Networking 8 27th Apr 2006 08:22 PM
Slow saving of Excel Files on Server =?Utf-8?B?R2F5bG9u?= Microsoft Windows 2000 Setup 1 12th Sep 2005 04:42 AM
Saving files to a 2k Server very slow . Please help. =?Utf-8?B?SmlwaQ==?= Microsoft Windows 2000 Networking 1 12th Feb 2004 08:56 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:11 PM.