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      
williamflAsked:
Who is Participating?
 
David ToddConnect With a Mentor Senior 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.