SharePoint 2010 Enterprise
We have two site collections which are very slow when it comes to creating content like sites, lists, and libraries and accessing settings for existing objects. I would say creating a site takes about 3-5 minutes from the time you select a template. Sometimes, it can take as long as 10 minutes. If, on the other hand, I create a new site collection site creation is almost instant. Both these problem site collections have their own content database.
I looked at the databases. One is about 130GB and the other is 40GB. I know MS recommends databases be around the 100GB, but it also states they can be as large as 200GB. I copied the DBs to our dev server and used DBCC to check for index fragmentation and even reindexed the databases to rule out problems with the databases. Everything came back fine.
Here is our current config:
- 2 WFE's 12GB RAM, 4 core processors @ 2.6GHz, VM
- 1 App Server, 8GB RAM, 4 core processors @ 2.6GHz, VM
- 1 DB Server, SQL 2008, Physical server. Not sure of the specs but I am sure they pretty beefy
Just as an experiment, I tried creating sites with powershell. I noticed that when I create a site without specifying a template, it is created in seconds. Follwing that, when I access the site I have to select a template. The first time I selected the team template. As expected, it took forever. The second time I selected the blank site template, which took about 27 seconds to create the site.
I am at a loss as to why these to site collections are so slow. Could there be something wrong with our team site template? How do you troubleshoot that?
Any help is appreciated.
Edit 1/20/15: I am still not able to find the source of the slowness. I have run profiler and DBCC against the database, reindexed, etc but performance is still slow. May have to consult with our contractor...