Correlation ID Result from Log file
Area : SharePoint Foundation Category : Monitoring Level : High EventID : b4ly Message : Leaving Monitored Scope (PostResolveRequestCacheHandler). Execution Time=6.92841879464484 Area : SharePoint Foundation Category : Monitoring Level :
High EventID : b4ly Message : Leaving Monitored Scope (EnsureListItemsData). Execution Time=11.286 7567953774 Area : SharePoint Foundation Category : Monitoring Level : High EventID : b4ly Message : Leaving Monitored Scope (EnsureListItemsData). Execution
Time=10.455 6586124602 Area : SharePoint Foundation Category : Monitoring Level : High EventID : b4ly Message : Leaving Monitored Scope (EnsureListItemsData#1). Execution Time=11.0 272439240317 Area : SharePoint Foundation Category : Monitoring Level : High
EventID : b4ly Message : Leaving Monitored Scope (CachedObjectFactory: Caching ListItem at: / Pages/Home.aspx). Execution Time=54.5198765507126 Area : SharePoint Foundation Category : Database Level : Monitorable EventID : fa42 Message : A large block of literal
text was sent to sql. This can result in b locking in sql and excessive memory use on the front end. Verify th at no binary parameters are being passed as literals, and consider b reaking up batches into smaller components. If this request is for a SharePoint
list or list item, you may be able to resolve this by r educing the number of fields. Area : SharePoint Foundation Category : Database Level : High EventID : fa43 Message : Slow Query Duration: 22.711893080697 Area : SharePoint Foundation Category : Database
Level : High EventID : fa44 Message : Slow Query StackTrace-Managed: at Microsoft.SharePoint.Utilities. SqlSession.OnPostExecuteCommand(SqlCommand command, SqlQueryData mon itoringData) at Microsoft.SharePoint.Utilities.SqlSession.Execut eReader(SqlCommand
command, CommandBehavior behavior, SqlQueryData m onitoringData, Boolean retryForDeadLock) at Microsoft.SharePoint .SPSqlClient.ExecuteQueryInternal(Boolean retryfordeadlock) at M icrosoft.SharePoint.SPSqlClient.ExecuteQuery(Boolean retryfordeadloc k) at Microsoft.SharePoint.Library.SPRequestInternalClass.CrossL
istQuery(String bstrUrl, String bstrXmlWebs, String bstrXmlLists, St ring bstrXmlQuery, ISP2DSafeArrayWriter pCallback, Object& pvarColum ns) at Microsoft.SharePoint.Library.SPRequest.CrossListQuery(Str ing bstrUrl, String bstrXmlWebs, String bstrXmlLists,
String bstrXml Query, ISP2DSafeArrayWriter pCallback, Object& pvarColumns) at M icrosoft.SharePoint.SPWeb.GetSiteData(SPSiteDataQuery query) at Microsoft.SharePoint.Publishing.CachedArea.GetSiteData(SPWeb web, SP SiteDataQuery siteDataQuery, Boolean useSpQueryOnList)
at Micros oft.SharePoint.Publishing.CachedArea.GetCrossListQueryResults(SPSite DataQuery query, SPWeb currentContext, Boolean onlyPopulateCache, Bo olean useSpQueryOnList, Int32 lcid) at Microsoft.SharePoint.Publ
August 29th, 2014 10:32am
Do you know if there is a particular list or library in your SharePoint environment that contains a large number of columns?
Area : SharePoint Foundation Category : Database Level : Monitorable EventID : fa42 Message : "A large block of literal text was sent to sql. This can result in blocking in sql and excessive memory use on the front end. Verify that no binary parameters are being passed as literals, and consider breaking up batches into smaller components. If this request is for a SharePoint list or list item, you may be able to resolve this by reducing the number of fields."
Free Windows Admin Tool Kit Click here and download it now
August 29th, 2014 1:48pm
This topic is archived. No further replies will be accepted.
Other recent topics
