Manage Filters slow to load. Each time a user clicks on a filter it takes over 40 seconds to load. All other pages load find and there appear to be no performance issues on the NS.
The performance of stored procedure spGetParameterTypes is bad, in one instance it was causing filters to take 40 seconds to load.
Change the stored procedure to use the String table instead of the StringCache view.
7.5 SP1 HF3