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

    Question

  • We are working on the sharePoint 2010 testing using Developer Dashboard. We found the "Database Queries" changed sometimes on same webpage.

    Usually it is:

    But sometimes it is:

    Do you have any idea why it is changed sometimes.

    Thanks,

    SkyRiver


    SkyRiver

    Friday, March 30, 2012 8:51 PM

Answers

  • 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
    Monday, April 09, 2012 1:54 PM

All replies

  • 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

    Tuesday, April 03, 2012 4:44 AM
    Moderator
  • 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


    Thursday, April 05, 2012 3:30 PM
  • 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

    Thursday, April 05, 2012 7:49 PM
  • 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
    Monday, April 09, 2012 1:54 PM