First published on MSDN on Mar 12, 2012
If you think you might be having issues with large lists in SharePoint 2007, there’s a good way to see if your WFEs are executing long running queries. Fire open ULS viewer, and filter on EventID 8sli. It will show you all list related queries that are taking more than 2 seconds. In each entry, you’ll see the duration, the list being called and the query that’s being called. While 2 seconds isn’t terrible it may indicate an issue. You should really pay attention to anything more than 5 I’d say. If you see a lot of these, think about working with list owners to correct their list views.
Large Lists Whitepaper – http://technet.microsoft.com/en-us/library/cc262813(v=office.12).aspx
ULS Viewer - http://archive.msdn.microsoft.com/ULSViewer
Updated Apr 28, 2020
Version 3.0ronalg
Microsoft
Joined December 27, 2018
Core Infrastructure and Security Blog
Follow this blog board to get notified when there's new activity