API tools faq
paste
Advertisement
Guest User

proc_GetTpWebMetaDataAndListMetaData

a guest
Jun 27th, 2017
143
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 13.52 KB | None | 0 0
raw download clone embed print report
  1. Texto
  2. SqlCommand: 'proc_GetTpWebMetaDataAndListMetaData'
  3.    CommandType: StoredProcedure CommandTimeout: 0
  4.    Parameter: '@RETURN_VALUE' TYPE: INT SIZE: 0 Direction: ReturnValue VALUE: ''
  5.    Parameter: '@WebSiteId' TYPE: UniqueIdentifier SIZE: 0 Direction: INPUT VALUE: '88bd92e0-8b9d-44af-99de-c38fe21c7e0b'
  6.    Parameter: '@WebId' TYPE: UniqueIdentifier SIZE: 0 Direction: INPUT VALUE: ''
  7.    Parameter: '@Url' TYPE: NVarChar SIZE: 4000 Direction: INPUT VALUE: ''
  8.    Parameter: '@ListId' TYPE: UniqueIdentifier SIZE: 0 Direction: INPUT VALUE: ''
  9.    Parameter: '@ViewId' TYPE: UniqueIdentifier SIZE: 0 Direction: INPUT VALUE: ''
  10.    Parameter: '@RunUrlToWebUrl' TYPE: Bit SIZE: 0 Direction: INPUT VALUE: 'True'
  11.    Parameter: '@DGCacheVersion' TYPE: BIGINT SIZE: 0 Direction: INPUT VALUE: '33'
  12.    Parameter: '@SystemId' TYPE: VarBinary SIZE: 8000 Direction: INPUT
  13.    Parameter: '@AppPrincipalName' TYPE: NVarChar SIZE: 256 Direction: INPUT VALUE: ''
  14.    Parameter: '@IsHostHeaderAppPrincipalName' TYPE: Bit SIZE: 0 Direction: INPUT VALUE: ''
  15.    Parameter: '@MetadataFlags' TYPE: INT SIZE: 0 Direction: INPUT VALUE: '18'
  16.    Parameter: '@ThresholdScopeCount' TYPE: INT SIZE: 0 Direction: INPUT VALUE: '5000'
  17.    Parameter: '@CurrentFolderUrl' TYPE: NVarChar SIZE: 260 Direction: INPUT VALUE: ''
  18.    Parameter: '@RequestGuid' TYPE: UniqueIdentifier SIZE: 0 Direction: INPUT VALUE: 'd1b1ff9d-4ea8-4024-1bdc-9996795685ee'
  19.  
  20. --------------------------------------------------------------------------------------------------------------------------------------
  21.  
  22. Pila de llamadas
  23.    at Microsoft.SharePoint.Utilities.SqlSession.OnPostExecuteCommand(SqlCommand command, SqlQueryData monitoringData)
  24.    at Microsoft.SharePoint.Utilities.SqlSession.ExecuteReader(SqlCommand command, CommandBehavior behavior, SqlQueryData monitoringData, BOOLEAN retryForDeadLock)
  25.    at Microsoft.SharePoint.SPSqlClient.ExecuteQueryInternal(BOOLEAN retryfordeadlock)
  26.    at Microsoft.SharePoint.SPSqlClient.ExecuteQuery(BOOLEAN canRetryForDeadlock)
  27.    at Microsoft.SharePoint.Library.SPRequestInternalClass.OpenWebInternal(String bstrUrl, Guid& pguidID, DateTime& pdtTimeCreated, String& pbstrRequestAccessEmail, UInt32& pwebVersion, String& pbstrServerRelativeUrl, UInt32& pnLanguage, UInt32& pnLocale, String& pbstrDefaultTheme, String& pbstrDefaultThemeCSSUrl, String& pbstrThemedCssFolderUrl, String& pbstrAlternateCSSUrl, String& pbstrCustomizedCssFileList, String& pbstrCustomJSUrl, String& pbstrAlternateHeaderUrl, String& pbstrMasterUrl, String& pbstrCustomMasterUrl, String& pbstrSiteLogoUrl, String& pbstrSiteLogoDescription, Object& pvarUser, Boolean& pvarIsAuditor, Int32& plSiteFlags, Boolean& pbOverwriteMUICultures, Boolean& pbMUIEnabled, String& pbstrAlternateMUICultures, Int32& plSiteSchemaMajorVersion, Int32& plSiteSchemaMinorVersion, Int32& plSiteSchemaBuildVersion, Int32& plSiteSchemaRevisionVersion, Int32& puiVersion, Int16& pnClientTag, Boolean& pfIsEvalSite, Guid& pgSourceSiteId, DateTime& pdtExpirationDate, Guid& pgEvalSiteId, Guid& pguidAppInstanceId, String& pbstrRemoteAppUrl, String& pbstrOAuthAppId, String& pbstrAppDatabaseName, Guid& pgAppDatabaseServerReferenceId, String& pbstrAppDatabaseTargetApplicationId, String& pbstrAppDatabaseLastAccessedDate, Int32& pnAppDatabaseStorageState, String& pbstrAppWebDomainId, Int32& plUpgradeFlags, DateTime& pdtReminderDate, DateTime& pdtLastContentChange, DateTime& pdtLastSecurityChange, UInt64& pmaskDeny, Int64& pllDiskQuota, Int64& pllDiskUsed, Int64& pllDiskWarning, UInt32& pulminutesSinceDenyMaskUpdate, String& pbstrDenyMaskGroupId, UInt64& pulCacheFlags, Int32& pminCacheAge, Int32& plWebTemplateId, Int32& plRootWebTemplateId, Int64& pllSiteFlags2)
  28.    at Microsoft.SharePoint.Library.SPRequestInternalClass.OpenWebInternal(String bstrUrl, Guid& pguidID, DateTime& pdtTimeCreated, String& pbstrRequestAccessEmail, UInt32& pwebVersion, String& pbstrServerRelativeUrl, UInt32& pnLanguage, UInt32& pnLocale, String& pbstrDefaultTheme, String& pbstrDefaultThemeCSSUrl, String& pbstrThemedCssFolderUrl, String& pbstrAlternateCSSUrl, String& pbstrCustomizedCssFileList, String& pbstrCustomJSUrl, String& pbstrAlternateHeaderUrl, String& pbstrMasterUrl, String& pbstrCustomMasterUrl, String& pbstrSiteLogoUrl, String& pbstrSiteLogoDescription, Object& pvarUser, Boolean& pvarIsAuditor, Int32& plSiteFlags, Boolean& pbOverwriteMUICultures, Boolean& pbMUIEnabled, String& pbstrAlternateMUICultures, Int32& plSiteSchemaMajorVersion, Int32& plSiteSchemaMinorVersion, Int32& plSiteSchemaBuildVersion, Int32& plSiteSchemaRevisionVersion, Int32& puiVersion, Int16& pnClientTag, Boolean& pfIsEvalSite, Guid& pgSourceSiteId, DateTime& pdtExpirationDate, Guid& pgEvalSiteId, Guid& pguidAppInstanceId, String& pbstrRemoteAppUrl, String& pbstrOAuthAppId, String& pbstrAppDatabaseName, Guid& pgAppDatabaseServerReferenceId, String& pbstrAppDatabaseTargetApplicationId, String& pbstrAppDatabaseLastAccessedDate, Int32& pnAppDatabaseStorageState, String& pbstrAppWebDomainId, Int32& plUpgradeFlags, DateTime& pdtReminderDate, DateTime& pdtLastContentChange, DateTime& pdtLastSecurityChange, UInt64& pmaskDeny, Int64& pllDiskQuota, Int64& pllDiskUsed, Int64& pllDiskWarning, UInt32& pulminutesSinceDenyMaskUpdate, String& pbstrDenyMaskGroupId, UInt64& pulCacheFlags, Int32& pminCacheAge, Int32& plWebTemplateId, Int32& plRootWebTemplateId, Int64& pllSiteFlags2)
  29.    at Microsoft.SharePoint.Library.SPRequest.OpenWebInternal(String bstrUrl, Guid& pguidID, DateTime& pdtTimeCreated, String& pbstrRequestAccessEmail, UInt32& pwebVersion, String& pbstrServerRelativeUrl, UInt32& pnLanguage, UInt32& pnLocale, String& pbstrDefaultTheme, String& pbstrDefaultThemeCSSUrl, String& pbstrThemedCssFolderUrl, String& pbstrAlternateCSSUrl, String& pbstrCustomizedCssFileList, String& pbstrCustomJSUrl, String& pbstrAlternateHeaderUrl, String& pbstrMasterUrl, String& pbstrCustomMasterUrl, String& pbstrSiteLogoUrl, String& pbstrSiteLogoDescription, Object& pvarUser, Boolean& pvarIsAuditor, Int32& plSiteFlags, Boolean& pbOverwriteMUICultures, Boolean& pbMUIEnabled, String& pbstrAlternateMUICultures, Int32& plSiteSchemaMajorVersion, Int32& plSiteSchemaMinorVersion, Int32& plSiteSchemaBuildVersion, Int32& plSiteSchemaRevisionVersion, Int32& puiVersion, Int16& pnClientTag, Boolean& pfIsEvalSite, Guid& pgSourceSiteId, DateTime& pdtExpirationDate, Guid& pgEvalSiteId, Guid& pguidAppInstanceId, String& pbstrRemoteAppUrl, String& pbstrOAuthAppId, String& pbstrAppDatabaseName, Guid& pgAppDatabaseServerReferenceId, String& pbstrAppDatabaseTargetApplicationId, String& pbstrAppDatabaseLastAccessedDate, Int32& pnAppDatabaseStorageState, String& pbstrAppWebDomainId, Int32& plUpgradeFlags, DateTime& pdtReminderDate, DateTime& pdtLastContentChange, DateTime& pdtLastSecurityChange, UInt64& pmaskDeny, Int64& pllDiskQuota, Int64& pllDiskUsed, Int64& pllDiskWarning, UInt32& pulminutesSinceDenyMaskUpdate, String& pbstrDenyMaskGroupId, UInt64& pulCacheFlags, Int32& pminCacheAge, Int32& plWebTemplateId, Int32& plRootWebTemplateId, Int64& pllSiteFlags2)
  30.    at Microsoft.SharePoint.SPWeb.InitWebPublic()
  31.    at Microsoft.SharePoint.SPWeb.get_ID()
  32.    at Microsoft.SharePoint.SPContext.DefaultKey(HttpContext context, SPWeb web)
  33.    at Microsoft.SharePoint.SPContext.GetContext(HttpContext context)
  34.    at Microsoft.SharePoint.SPContext.get_Current()
  35.    at Microsoft.SharePoint.Client.SPClientServiceHost.OnBeginRequest()
  36.    at Microsoft.SharePoint.Client.Rest.RestService.ProcessQuery(ClientServiceHost serviceHost, Stream inputStream, IList`1 pendingDisposableContainer)
  37.   at Microsoft.SharePoint.Client.ClientRequestService.ProcessRestQuery(Stream inputStream)
  38.   at SyncInvokeProcessRestQuery(Object , Object[] , Object[] )
  39.   at System.ServiceModel.Dispatcher.SyncMethodInvoker.Invoke(Object instance, Object[] inputs, Object[]& outputs)
  40.   at System.ServiceModel.Dispatcher.DispatchOperationRuntime.InvokeBegin(MessageRpc& rpc)
  41.   at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage5(MessageRpc& rpc)
  42.   at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage11(MessageRpc& rpc)
  43.   at System.ServiceModel.Dispatcher.MessageRpc.Process(Boolean isOperationContextSet)
  44.   at System.ServiceModel.Dispatcher.ChannelHandler.DispatchAndReleasePump(RequestContext request, Boolean cleanThread, OperationContext currentOperationContext)
  45.   at System.ServiceModel.Dispatcher.ChannelHandler.HandleRequest(RequestContext request, OperationContext currentOperationContext)
  46.   at System.ServiceModel.Dispatcher.ChannelHandler.AsyncMessagePump(IAsyncResult result)
  47.   at System.ServiceModel.Dispatcher.ChannelHandler.OnAsyncReceiveComplete(IAsyncResult result)
  48.   at System.Runtime.Fx.AsyncThunk.UnhandledExceptionFrame(IAsyncResult result)
  49.   at System.Runtime.AsyncResult.Complete(Boolean completedSynchronously)
  50.   at System.Runtime.InputQueue`1.AsyncQueueReader.SET(Item item)
  51.    at System.Runtime.InputQueue`1.EnqueueAndDispatch(Item item, Boolean canDispatchOnThisThread)
  52.   at System.Runtime.InputQueue`1.EnqueueAndDispatch(T item, Action dequeuedCallback, BOOLEAN canDispatchOnThisThread)
  53.    at System.ServiceModel.Channels.SingletonChannelAcceptor`3.Enqueue(QueueItemType item, Action dequeuedCallback, Boolean canDispatchOnThisThread)
  54.   at System.ServiceModel.Channels.HttpPipeline.EnqueueMessageAsyncResult.CompleteParseAndEnqueue(IAsyncResult result)
  55.   at System.ServiceModel.Channels.HttpPipeline.EnqueueMessageAsyncResult.HandleParseIncomingMessage(IAsyncResult result)
  56.   at System.Runtime.AsyncResult.SyncContinue(IAsyncResult result)
  57.   at System.ServiceModel.Channels.HttpPipeline.EmptyHttpPipeline.BeginProcessInboundRequest(ReplyChannelAcceptor replyChannelAcceptor, Action dequeuedCallback, AsyncCallback callback, Object state)
  58.   at System.ServiceModel.Channels.HttpChannelListener`1.HttpContextReceivedAsyncResult`1.ProcessHttpContextAsync()
  59.   at System.ServiceModel.Channels.HttpChannelListener`1.BeginHttpContextReceived(HttpRequestContext context, Action acceptorCallback, AsyncCallback callback, Object state)
  60.    at System.ServiceModel.Activation.HostedHttpTransportManager.HttpContextReceived(HostedHttpRequestAsyncResult RESULT)
  61.    at System.ServiceModel.Activation.HostedHttpRequestAsyncResult.HandleRequest()
  62.    at System.ServiceModel.Activation.HostedHttpRequestAsyncResult.BeginRequest()
  63.    at System.ServiceModel.Activation.HostedHttpRequestAsyncResult.OnBeginRequest(Object state)
  64.    at System.ServiceModel.AspNetPartialTrustHelpers.PartialTrustInvoke(ContextCallback callback, Object state)
  65.    at System.ServiceModel.Activation.HostedHttpRequestAsyncResult.OnBeginRequestWithFlow(Object state)
  66.    at System.Runtime.IOThreadScheduler.ScheduledOverlapped.IOCallback(UInt32 errorCode, UInt32 numBytes, NativeOverlapped* nativeOverlapped)
  67.    at System.Runtime.Fx.IOCompletionThunk.UnhandledExceptionFrame(UInt32 error, UInt32 bytesRead, NativeOverlapped* nativeOverlapped)
  68.    at System.Threading._IOCompletionCallback.PerformIOCompletionCallback(UInt32 errorCode, UInt32 numBytes, NativeOverlapped* pOVERLAP)
  69.  
  70. --------------------------------------------------------------------------------------------------------------------------------------
  71.  
  72. Estadísticas de E/S
  73.  
  74. proc_GetTpWebMetaDataAndListMetaData:TABLE 'AllWebs'. Scan COUNT 0, logical reads 2, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.proc_GetTpWebMetaDataAndListMetaData:TABLE 'AllSites'. Scan COUNT 0, logical reads 2, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.proc_UrlToWebUrlOutput:TABLE 'AllSites'. Scan COUNT 0, logical reads 2, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.proc_GetTpWebMetaDataAndListMetaData:TABLE 'AllDocs'. Scan COUNT 1, logical reads 6, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.proc_ReturnTpWebMetaData:TABLE 'AllWebs'. Scan COUNT 0, logical reads 2, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.proc_ReturnTpWebMetaData:TABLE 'UserInfo'. Scan COUNT 0, logical reads 4, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.proc_ReturnTpWebMetaData:TABLE 'WebMembers'. Scan COUNT 0, logical reads 2, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.proc_ReturnTpWebMetaData:TABLE 'UserInfo'. Scan COUNT 0, logical reads 2, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.proc_ReturnTpWebMetaData:TABLE 'Perms'. Scan COUNT 0, logical reads 4, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.proc_ReturnTpWebMetaData:TABLE 'AllWebs'. Scan COUNT 0, logical reads 2, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.proc_GetEventReceivers:TABLE 'Solutions'. Scan COUNT 0, logical reads 0, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.proc_GetEventReceivers:TABLE 'EventReceivers'. Scan COUNT 1, logical reads 4, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.proc_GetEventReceivers:TABLE 'Solutions'. Scan COUNT 0, logical reads 0, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.proc_GetEventReceivers:TABLE 'EventReceivers'. Scan COUNT 1, logical reads 4, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!