Friday, March 30, 2012 8:51 PM
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.
Tuesday, April 03, 2012 4:44 AMModerator
Thursday, April 05, 2012 3:30 PM
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.
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).
The proc_GetCurrent Stored Procedure is called to return the timestamp and Change Log Identifier of the latest Event from the Change Log.
proc_GetTpWebMetaDataAndListMetaData is invoked to retrieve metadata for a particular site or list.
The proc_GetChangesstored procedure is called to get a range of events from the change log specified by the parameters.
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.
proc_GetListMetaDataAndEventReceivers is invoked to retrieve information about the metadata, scopes, web parts and event receivers for a specified list.
The proc_GetDocsMetaInfo stored procedure is invoked to request Document Metadata information for up to ten Documents within a specified site.
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.
The proc_SecGetListItemSecurity stored procedure is called to get the security information of a list item.
The proc_GetListItemWorkflows stored procedure is called to obtain a set of Workflows.
The proc_GetWebMetaInfo stored procedure is invoked to request metadata information for a site.
The proc_SecRefreshToken stored procedure is invoked to update the UserInfo Table with information about a specified user's membership in external groups.
ScottC - Microsoft SharePoint Support
- Edited by ScottC - MSFT Thursday, April 05, 2012 5:51 PM
Thursday, April 05, 2012 7:49 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.
Monday, April 09, 2012 1:54 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:
If I load a document to that library, the queries change to:
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.
ScottC - Microsoft SharePoint Support