How can I quickly find Large List with more than 2000 List items in SharePoint?

According to the whitepaper <White paper: Working with large lists in Office SharePoint Server 2007>, when a List with more than 2000 items is displayed on the UI, the performance may be poor.

 

So how can we find a list like this in SharePoint Content DB?

 

Run the following query statement.

SELECT ItemChildCount + FolderChildCount as Items, DirName + '/' + LeafName as RelativePath FROM alldocs WITH (NOLOCK) WHERE ItemChildCount + FolderChildCount> 1500 order by Items DESC

 

This query returns a list of folders and list items that exceed 1500.