Microsoft recommends not to use lists/libraries with a huge amount of items, so called large lists. These lists can seriously impact the performance of SharePoint. Unfortunately there is no way to keep track of such large lists from an administrative side.
In order to be able to determine where large lists exist, I have created a PowerShell script.
How to use it:
- Download the PowerShell script
- Open it in a text editor like Notepad
- Run the script
- Open the output in Microsoft Excel and use "*" as separator