Developer Dashboard, "Database Queries" are different on same page

All Replies

• Tuesday, April 03, 2012 4:44 AM

  Moderator

   

   
  

  0

  Hi,

  Thank you for your post.

  I am trying to involve someome familiar with this topic to further look at this issue.

  ---

  Xue-mei Chang

  TechNet Community Support

  

  • Reply
  • Quote

   
• Thursday, April 05, 2012 3:30 PM

   

   
  

  0

  Hey SkyRiver,

  To get some more information on this issue, what web parts are being run on the page in question? What type of site template are you using? There are several reasons that this could be occurring, and in order to gauge my response properly, I need to collect this additional information.

  My initial guess by looking at the dashboard is that this is the difference between a fresh page load, and a refresh of the current page. I will need to get some additional information from you to determine if that is the case. If you want more information on what each of those stored procedures is doing, I have provided it below.

  Proc_FetchDocForHttpGet
  The proc_FetchDocForHttpGet stored procedure is invoked to fetch a document for the HTTP GET & HEAD operations and to provide information necessary to render the document on the WFE. Different sets of information are provided depending on the type of request (HEAD or GET) or the type document requested (such as a file, a Web page, or a list item view Web page).
  http://msdn.microsoft.com/en-us/library/dd304775(v=PROT.13).aspx

  Proc_GetCurrent
  The proc_GetCurrent Stored Procedure is called to return the timestamp and Change Log Identifier of the latest Event from the Change Log.
  http://msdn.microsoft.com/en-us/library/dd905370(v=office.12).aspx

  Proc_GetTpWebMetaDataAndListMetaData
  proc_GetTpWebMetaDataAndListMetaData is invoked to retrieve metadata for a particular site or list.
  http://msdn.microsoft.com/en-us/library/dd302800(v=PROT.13).aspx

  Proc_GetChanges
  The proc_GetChangesstored procedure is called to get a range of events from the change log specified by the parameters.
  http://msdn.microsoft.com/en-us/library/dd926201(v=office.12).aspx

  Proc_GetListWebParts
  The proc_GetListWebParts stored procedure is called to return a Result Set of list view Web Parts, list form Web Parts, Data View Web Parts, and Data Form Web Parts associated with the specified list in Web Part pages.
  http://msdn.microsoft.com/en-us/library/dd927699(v=office.12).aspx

  Proc_GetListMetaDataAndEventReceivers
  proc_GetListMetaDataAndEventReceivers is invoked to retrieve information about the metadata, scopes, web parts and event receivers for a specified list.
  http://msdn.microsoft.com/en-us/library/dd340357(v=PROT.13).aspx

  proc_GetDocsMetaInfo
  The proc_GetDocsMetaInfo stored procedure is invoked to request Document Metadata information for up to ten Documents within a specified site.
  http://msdn.microsoft.com/en-us/library/cc668912(v=prot.10).aspx

  proc_SecGetPrincipalByLogin
  The proc_SecGetPrincipalByLogin stored procedure is invoked to return security and attribute information for a principal (a user or domain group) identified by a specified login name.
  http://msdn.microsoft.com/en-us/library/dd339964(v=PROT.13).aspx

  proc_SecGetListItemSecurity
  The proc_SecGetListItemSecurity stored procedure is called to get the security information of a list item.
  http://msdn.microsoft.com/en-us/library/dd960579(v=office.12).aspx

  Proc_GetListItemWorkflows
  The proc_GetListItemWorkflows stored procedure is called to obtain a set of Workflows.
  http://msdn.microsoft.com/en-us/library/dd945916(v=office.12).aspx

  proc_GetWebMetaInfo
  The proc_GetWebMetaInfo stored procedure is invoked to request metadata information for a site.
  http://msdn.microsoft.com/en-us/library/ee363755(v=PROT.13).aspx

  proc_SecRefreshToken
  The proc_SecRefreshToken stored procedure is invoked to update the UserInfo Table with information about a specified user's membership in external groups.
  http://msdn.microsoft.com/en-us/library/cc717224(v=prot.10).aspx

  Thanks,

  ScottC - Microsoft SharePoint Support

  
  

  • Edited by ScottC - MSFT Thursday, April 05, 2012 5:51 PM
  •  
  • Reply
  • Quote

   
• Thursday, April 05, 2012 7:49 PM

   

   
  

  0

  Thank you ScottC,

  Most of the webparts being used here are out-of-the-box from SharePoint, we only customized how it looks like. I believe it is using a publishing template.

  I use Refresh(F5) to test, most of time the SQL queries are 5, but sometimes they are many, like 40 queries.

  Regards,

  SkyRiver

  ---

  SkyRiver

  • Reply
  • Quote

   
• Monday, April 09, 2012 1:54 PM

   

   
  

  0

  The "Database Queries" section of the developer dashboard will change depending on what actions were recently taken on a site.

  To give an example:

  If I load a Shared Documents Library, I get the following two queries:

  proc_FetchDocForHttpGet

  declare @DocParentIDForRF

  If I load a document to that library, the queries change to:

  proc_FetchDocForHTTPGet

  proc_GetCurrent

  proc_GetTpWebMetaDataAndListMetaData

  proc_GetTpWebMetaDataAndListMetaData

  proc_GetChanges

  declare @DocParentIdForRF

  The actions that are taken on the site are reflected in the developer dashboard, and show what stored procedures had to be run to perform the last action on the site.

  Thanks,

  ScottC - Microsoft SharePoint Support

  • Marked As Answer by ScottC - MSFT Monday, April 09, 2012 1:54 PM
  • Unmarked As Answer by ScottC - MSFT Monday, April 09, 2012 1:55 PM
  • Marked As Answer by SkyRiver999 Monday, April 09, 2012 5:16 PM
  •  
  • Reply
  • Quote