Troubleshooting Large List Performance – SharePoint 2007
Published Feb 08 2019 12:47 PM 301 Views

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 –
ULS Viewer -

Version history
Last update:
‎Apr 28 2020 12:06 PM
Updated by: