Timeout on Largest Files report
I try to run the Server Report "Largest Files" from the NS Console but get the error:
Sql error in query. Error: System.Data.SqlClient.SqlError: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.Sql CommandText: -- MAX ROWCOUNT SET ROWCOUNT 50000
Does anyone know what I can do to get this report to run succesfully? It's similar to what is described here: AKB 36049. Unfortunately it didn't work.
I turned down the resource history retention level to 2 months and have purged the DB. Still no luck. Any guidance would be appreciated.