We've been having what appears to be performance issues across the board with one of our SQL servers. It was recently rebuilt because we had to move it to a new domain. One symptom that we are seeing that perplexes me is that when you try to get a list
of stored procedures using the Object Browser in SSMS, it can sometimes take over a minute. It displays (expanding...) next to the folder which shows all the Stored Procedures for our main database. I feel like this must be a symptom of the slowness. CPU usage
is not particularly high either. Any ideas?
View Complete Post