[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1186
  • Last Modified:

Slow SharePoint Performance for Web page

Slow SharePoint Performance
I am testing a SharePoint page form a group and it is very slop.  They have build a customer page for the sharpen site. I have the call stack that has the latency just trying to understand what might be causing it. The page is taking 20 second. I can see they are doing allot of sqlcommand call.
My first question is how many is too many for sqlcommand call.
Second what setting should I be looking at to increase the capability of the web service is it possible there is not enough connect pools of some kind.
Third it seems that the calls are stacking for sql requests look like some kind of single threaded mode.    

Call                                                       Latency (Total)       Total CPU
100% /sites/grr/GrrCarDashboard.aspx       20.3 s       4.8 s
   100% Server.Request()       20.3 s         
      7.7% SqlCommand.ExecuteReader()       1.6 s         
         7.7% Outbound Call to SqlCommand.ExecuteReader()       1.6 s         
      0.2% SqlCommand.ExecuteReader()       35.6 ms         
         0.2% Outbound Call to SqlCommand.ExecuteReader()       35.4 ms         
      0.1% SqlCommand.ExecuteReader()       24.7 ms         
         0.1% Outbound Call to SqlCommand.ExecuteReader()       24.5 ms         
      0.1% SqlCommand.ExecuteReader()       12.4 ms         
         0.1% Outbound Call to SqlCommand.ExecuteReader()       12.2 ms         
      0.1% SqlCommand.ExecuteReader()       23.7 ms         
         0.1% Outbound Call to SqlCommand.ExecuteReader()       23.6 ms         
      0.1% SqlCommand.ExecuteReader()       24 ms         
         0.1% Outbound Call to SqlCommand.ExecuteReader()       23.8 ms         
      0.1% SqlCommand.ExecuteReader()       17.7 ms         
         0.1% Outbound Call to SqlCommand.ExecuteReader()       17.6 ms         
      4.5% SqlCommand.ExecuteReader()       913.3 ms         
         4.5% Outbound Call to SqlCommand.ExecuteReader()       913.1 ms         
      0% SqlCommand.ExecuteReader()       6.7 ms         
         0% Outbound Call to SqlCommand.ExecuteReader()       6.6 ms         
      0.1% SqlCommand.ExecuteReader()       29.6 ms         
         0.1% Outbound Call to SqlCommand.ExecuteReader()       29.4 ms         
      0.1% SqlCommand.ExecuteReader()       16.4 ms         
         0.1% Outbound Call to SqlCommand.ExecuteReader()       16.3 ms         
      0% SqlCommand.ExecuteReader()       9.2 ms         
         0% Outbound Call to SqlCommand.ExecuteReader()       9.1 ms         

 
       Selection Details
                                           
Arguments      Maximum number of unique SQL exceeded              
Class      System.Data.SqlClient.SqlCommand              
Alias                   
Default Name      System.Data.SqlClient.SqlDataReader System.Data.SqlClient.SqlCommand.ExecuteReader()              
Category Name                   
Layer      Database/ADO/Execute              
Type                   
Latency (Exclusive Total)      0.2 ms              
Latency (Total)      1,563.7 ms              
Timeout?      false              
Exception?      false              
Name      SqlCommand.ExecuteReader()              
Namespace      System.Data.SqlClient              
Return Type      System.Data.SqlClient.SqlDataReader      
0
williamfl
Asked:
williamfl
1 Solution
 
David ToddSenior DBACommented:
Hi,

Given that it is a closed application, there is only so much you can do.

Look at their page and make sure that it isn't trying to do something stupid, like have the movie tralier for Lord of the Rings run as a a background.

Make sure that database optimisation on the sharepoint databases are up to date. I have a couple of log tables that the automatic statistics go out every day. So after the uploads and audits I have to update the statistics on these tables. Takes only a second or two.

Make sure that the sharepoint datafiles are on good hard drives, the hard drives aren't more than 80% full, and the files are defragmented.

Check the other usual things for SQL Server.
http://www.sql-server-performance.com/articles/per/performance_audit_p1.aspx

HTH
  David
0
 
williamflAuthor Commented:
It helped identify other issues.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now