Registered users    
MembershipMembership:
Latest New UserLatest:Ron Ang
New TodayNew Today:9
New YesterdayNew Yesterday:6
User CountOverall:23401

Private messaging    
You must be logged in to use this module.
Top 10 posters    
NamePosts
Mariette Knap12949
Marina Roos12626
Eriq Neale2117
Stan Guinn1917
Michael Patrick1914
Robert Pearman1784
Nick Pieters1425
william warren634
Stewart Brown620
Kevin D.579
Welcome unauthorized visitor    
If you want to join us in the discussions on this forum you need to register first. Registration is free! If you are already a registered user please login to join the forum.
Small Business Server Support Forum    
Subject: Slow SharePoint response
Prev Next
You are not authorized to post a reply.

Page 1 of 212 > >>
Author Messages
Greg Mohr User is Offline
United States
Member since
3/27/2005

Platinum Membership
Posts: 103

6/05/2008 06:49 PM  
I have users in an Office using SharePoint 2.0 on SBS 2003 Std.  It is using SQL as the dB.  The users are complaining that it is taking a minute and a half or longer to access CompanyWeb from the My Network Places.  The users access the companyweb from their Network Places and open files and work on them, then save the work. This is due to the fact that 2 - 3 people may want to access the file to edit it and it needs to show that it is in use if they click on it.
 
We have from 15 - 20 users on at anyone time and the comapny has put its entire documents structure into SharePoint and I admint some of the files are big, 35 - 50 MB, but it shouldn't be enough to bring the service to a crawl.
 
I have the server scheuled for a restart every morning at 5:30 AM, to give a fresh and faster response time.  During the day, it just slows to a crawl, but not as often since the daily restarts.
 
The Switch is a 10/100 unit an a WatchGuard VPN/Firewall.  It seems the older the PC the longer it also takes to get to SharePoint. 
The server is a Quad Core Xeon Processor, with 4GB of Ram.
 
Any suggestions on trying to speed up user access? 
 
Thanks,
Greg
Kevin Da Silva User is Offline
Mississauga, Canada
Member since
1/12/2008

Registered Users
Posts: 579

6/06/2008 05:28 AM  
Have them try to access it using http://companyweb to see if it is still giving the same result. Normally the first response will take a little longer.

MCSE:Messaging, MCTIP, SBS Specialist
Greg Mohr User is Offline
United States
Member since
3/27/2005

Platinum Membership
Posts: 103

6/06/2008 01:50 PM  
They have been trying that and that also is very slow. 
 
Greg
Marina Roos User is Offline
The Netherlands
Member since
3/24/2005

Forum Admins
Posts: 12626

8/30/2008 10:50 PM  
Hi Greg,

Did you figure this out yet?

Marina Roos Smallbizserver.Net AdministratorMission accomplished. We have joined the branch office to our SBS 2003 Headquarters and have the same user experience on the branch office as we have on our local  network at the Headquarters. Want to know how? Signup up for a subscription and get instant access to the article series 'How to add an additional Domain Controller from a remote office to the SBS domain'
Greg Mohr User is Offline
United States
Member since
3/27/2005

Platinum Membership
Posts: 103

8/31/2008 02:13 AM  
Marina,
 
This has not been resolved yet and I'm about to drop $200 to work with MSFT to try and correct something that shouldn't be happening at all!  It's really frustrating.
 
Greg
Greg Mohr User is Offline
United States
Member since
3/27/2005

Platinum Membership
Posts: 103

8/31/2008 02:16 AM  

Still no solution, a couple of things from the technet KB that look like it on the surface, but not 100%.  This customer has gone full tilt into using and embracing Sharepoint, 20 users, and a SP SQL db that is about 18 GB in size.  This is causing major issues in their productivity.  They are in Europe, Asia and S. America and the Sharepoint is fantastic, but with a 5 minute delay in opening up the companyweb, it almost becomes unusable.

Marina Roos User is Offline
The Netherlands
Member since
3/24/2005

Forum Admins
Posts: 12626

8/31/2008 02:25 AM  
Hi Greg,
 
Please, post an ipconfig /all from the server and a workstation. Open a command prompt by opening Start -> Run from the Start Menu and type cmd. From the command prompt type ipconfig /all >ip.txt. Attach this file to your answer.

Marina Roos Smallbizserver.Net AdministratorMission accomplished. We have joined the branch office to our SBS 2003 Headquarters and have the same user experience on the branch office as we have on our local  network at the Headquarters. Want to know how? Signup up for a subscription and get instant access to the article series 'How to add an additional Domain Controller from a remote office to the SBS domain'
Greg Mohr User is Offline
United States
Member since
3/27/2005

Platinum Membership
Posts: 103

8/31/2008 02:52 AM  
I just ran a BPA and it states the following as critical:
 
The DNS client is not configured to point only to the internal IP address of the server. For detailed instructions about how to configure the DNS client, see the "Configurations" section of the Knowledge Base article "How to configure Internet access in Windows Small Business Server 2003" at http://go.microsoft.com/fwlink/?LinkId=95289. Note: If you have another domain controller or DNS server in your domain, it may not be necessary to point the DNS client only to the internal IP address of the server .
 
However when I follow what it says to do, everything is set the same as the KB article.

Here is the server ipconfig: ( the other adapter is disabled)
 
Windows IP Configuration
   Host Name . . . . . . . . . . . . : SF-SERVER1
   Primary Dns Suffix  . . . . . . . : xxxxxxxxxx.local
   Node Type . . . . . . . . . . . . : Unknown
   IP Routing Enabled. . . . . . . . : Yes
   WINS Proxy Enabled. . . . . . . . : Yes
   DNS Suffix Search List. . . . . . : xxxxxxxxxx.local
 
Ethernet adapter Server Local Area Connection:
   Connection-specific DNS Suffix  . :
   Description . . . . . . . . . . . : Broadcom NetXtreme Gigabit Ethernet #2
   Physical Address. . . . . . . . . : 00-1D-09-F1-69-55
   DHCP Enabled. . . . . . . . . . . : No
   IP Address. . . . . . . . . . . . : 10.10.10.5
   Subnet Mask . . . . . . . . . . . : 255.0.0.0
   Default Gateway . . . . . . . . . : 10.10.10.1
   DNS Servers . . . . . . . . . . . : 10.10.10.5
   Primary WINS Server . . . . . . . : 10.10.10.5
 
Here is an IPCONFIG from a client PC:
 
Windows IP Configuration
        Host Name . . . . . . . . . . . . : LT-PKRAMATA
        Primary Dns Suffix  . . . . . . . : xxxxxxxxxx.local
        Node Type . . . . . . . . . . . . : Hybrid
        IP Routing Enabled. . . . . . . . : No
        WINS Proxy Enabled. . . . . . . . : No
        DNS Suffix Search List. . . . . . : xxxxxxxxxx.local
                                            xxxxxxxxxx.local
 
Ethernet adapter Local Area Connection:
        Connection-specific DNS Suffix  . : xxxxxxxxxx.local
        Description . . . . . . . . . . . : Marvell Yukon 88E8040 PCI-E Fast Ethernet Controller
        Physical Address. . . . . . . . . : 00-17-42-75-05-99
        Dhcp Enabled. . . . . . . . . . . : Yes
        Autoconfiguration Enabled . . . . : Yes
        IP Address. . . . . . . . . . . . : 10.10.10.112
        Subnet Mask . . . . . . . . . . . : 255.255.255.0
        Default Gateway . . . . . . . . . : 10.10.10.1
        DHCP Server . . . . . . . . . . . : 10.10.10.5
        DNS Servers . . . . . . . . . . . : 10.10.10.5
        Primary WINS Server . . . . . . . : 10.10.10.5
        Lease Obtained. . . . . . . . . . : Friday, August 29, 2008 3:08:24 PM
        Lease Expires . . . . . . . . . . : Friday, September 05, 2008 3:08:24 PM
 
Ethernet adapter Wireless Network Connection:
        Media State . . . . . . . . . . . : Media disconnected
        Description . . . . . . . . . . . : Atheros AR5006EXS Wireless Network Adapter
        Physical Address. . . . . . . . . : 00-1B-9E-8A-74-A8
Marina Roos User is Offline
The Netherlands
Member since
3/24/2005

Forum Admins
Posts: 12626

8/31/2008 03:01 AM  
Hi Greg,
 
Were the servernics ever swapped in the past? Why are you using netmask 255.0.0.0 on the server? Did you have any warnings in the BPA?

Marina Roos Smallbizserver.Net AdministratorMission accomplished. We have joined the branch office to our SBS 2003 Headquarters and have the same user experience on the branch office as we have on our local  network at the Headquarters. Want to know how? Signup up for a subscription and get instant access to the article series 'How to add an additional Domain Controller from a remote office to the SBS domain'
Greg Mohr User is Offline
United States
Member since
3/27/2005

Platinum Membership
Posts: 103

8/31/2008 03:12 AM  
The server Nics were never swapped, it just happened to be the nic that was chosen for ease of access.
 
The netmask was originally set to 255.255.255.0 and they brought in another company to provide enduser desktop support 24/7 and they hooked up a server to the network to provide monitoring and remote access to help in the support.  I can only figure they changed it in the last 3 weeks, but this slowdown has been going on for a lot longer than that.  I have reset the netmaske back to a class C and I'll see what happens on Tuesday when they get back to work.
 
Thanks for catching the netmask!
 
Greg
Marina Roos User is Offline
The Netherlands
Member since
3/24/2005

Forum Admins
Posts: 12626

8/31/2008 03:29 AM  
Hi Greg,
 
So is that other nic completely disabled? And what about the warnings in the BPA?

Marina Roos Smallbizserver.Net AdministratorMission accomplished. We have joined the branch office to our SBS 2003 Headquarters and have the same user experience on the branch office as we have on our local  network at the Headquarters. Want to know how? Signup up for a subscription and get instant access to the article series 'How to add an additional Domain Controller from a remote office to the SBS domain'
Greg Mohr User is Offline
United States
Member since
3/27/2005

Platinum Membership
Posts: 103

8/31/2008 03:38 AM  
The one nic was re-enabled by the "support group" I turned it off and it cleared up the critical error.  But that error has only been there since they came in.  I had the NIC disabled prior to them monkeying with things.  Since I turned it off, there are no further warnings.
Marina Roos User is Offline
The Netherlands
Member since
3/24/2005

Forum Admins
Posts: 12626

8/31/2008 03:47 AM  
Hi Greg,
 
Good. What kind of hardware are you using in the server and how much memory? Is the partition where the sharepoint databases are located very fragmented?

Marina Roos Smallbizserver.Net AdministratorMission accomplished. We have joined the branch office to our SBS 2003 Headquarters and have the same user experience on the branch office as we have on our local  network at the Headquarters. Want to know how? Signup up for a subscription and get instant access to the article series 'How to add an additional Domain Controller from a remote office to the SBS domain'
Greg Mohr User is Offline
United States
Member since
3/27/2005

Platinum Membership
Posts: 103

8/31/2008 03:53 AM  
Its a Dell PowerEdge 860 Quad core processor with 4 GB of RAM.  The 400 GB Raid 1 HD is partitioned into 2 parts, an 80GB C and the balance as G.  The SQL Server 2005 DB is on the G partition and the SQL runs the standard nightly cleanups.  There is very little fragmentation on the HD for either partition.
Marina Roos User is Offline
The Netherlands
Member since
3/24/2005

Forum Admins
Posts: 12626

8/31/2008 04:08 AM  
Hi Greg,
 
Have you set the page file to 1,5 the RAM? What third party programs are installed? Is it only Sharepoint that is slowing down? Can you see what processes are using a lot of CPU or memory usage at the time when the server is slowed down?

Marina Roos Smallbizserver.Net AdministratorMission accomplished. We have joined the branch office to our SBS 2003 Headquarters and have the same user experience on the branch office as we have on our local  network at the Headquarters. Want to know how? Signup up for a subscription and get instant access to the article series 'How to add an additional Domain Controller from a remote office to the SBS domain'
Greg Mohr User is Offline
United States
Member since
3/27/2005

Platinum Membership
Posts: 103

8/31/2008 01:18 PM  
Hi Marina,
 
The page file had been reset to 2046  - 4092 MB in size, I bumped it to 6144 MB max.  The Processor scheduling is for best performance of background svcs and memory usuage is for best performance of programs.
 
3rd party programs on the server are CA Integrated Threat Manager and print drivers for a Samsung color printer and a Kyocera printer/scanner.
 
Greg
Marina Roos User is Offline
The Netherlands
Member since
3/24/2005

Forum Admins
Posts: 12626

9/01/2008 05:07 PM  
Hi Greg,
 
What about my other question about whether it is only Sharepoint please? Not being familiar with CA, have you tried turning that off on the server itself?

Marina Roos Smallbizserver.Net AdministratorMission accomplished. We have joined the branch office to our SBS 2003 Headquarters and have the same user experience on the branch office as we have on our local  network at the Headquarters. Want to know how? Signup up for a subscription and get instant access to the article series 'How to add an additional Domain Controller from a remote office to the SBS domain'
Greg Mohr User is Offline
United States
Member since
3/27/2005

Platinum Membership
Posts: 103

9/02/2008 02:18 AM  
Hi Marina,
 
Whenever I check the taskmgr, the store and sqlserver instances are using 500,000KB or more per instance.  I restart the server every morning around 5 AM to clear the memory and set everything fresh for the day, but by about 10 am the store is over 500,000 kb of ram usage.  The CA only uses about 20 - 30 MB of RAM.
 
The server is used for Exchange  & sharepoint, an occaisional VPN user or RWW user, but thats it.
 
Greg
Marina Roos User is Offline
The Netherlands
Member since
3/24/2005

Forum Admins
Posts: 12626

9/02/2008 02:24 AM  
Hi Greg,
 
It is normal that those instances are using that much kb and it isn't even out of the ordinary. By rebooting the server every day, you don't give it a chance to settle down.
You still haven't told me if the whole server is slowing down or only sharepoint. It is not about the usage of CA, it is that it might be scanning stuff it shouldn't.
Anyway, I suggest you consider our remote support services.

Marina Roos Smallbizserver.Net AdministratorMission accomplished. We have joined the branch office to our SBS 2003 Headquarters and have the same user experience on the branch office as we have on our local  network at the Headquarters. Want to know how? Signup up for a subscription and get instant access to the article series 'How to add an additional Domain Controller from a remote office to the SBS domain'
Greg Mohr User is Offline
United States
Member since
3/27/2005

Platinum Membership
Posts: 103

9/02/2008 02:57 AM  
Hi Marina,
 
It is only the Sharepoint that is slowing down and taking 45 sec to 5 minutes to render the pages, either in webview or explorer view.  I tried the daily reboot of the server to bring the ram usuage down for the start of the day for Exchange.  Before I began the daily reboot, I was getting the store using up to 1.5 GB of RAM.
 
Greg
You are not authorized to post a reply.
Page 1 of 212 > >>




ActiveForums 3.7
Forum policy    
These Discussion Forums are dedicated to the discussion of the Small Business Server and related server and client software. For the benefit of the community please observe the following posting guidelines:
  1. No Advertising. This includes promotion of commercial products and non-commercial products which are not directly related to Small Business Server and related server and client software.
  2. No Flaming or Trolling.
  3. No Profanity, Racism, or Prejudice.
  4. Site Moderators have the final word on approving/removing a thread or post or comment.