It is taking more than 250ms to respond also sometime it throws DB connectivity Error, throws low memory alerts every now and then.
In our SharePoint 2007 Farm, basically it a publishing framework with 4 WFEs and an application server (just Excel service runs there). A WFE is used as an Index & Query Server. We are facing a performance issue since a month, it is taking
more than 250ms to respond also sometime it throws DB connectivity Error.
It has only one web-application with 18 Content DBs with 10 Site collection including the root.
Server Details (All the servers are having the same configuration)
4 Cores - 2.27GZ
Full crawl takes - 90hrs (weekly)
Incremental crawl takes - 6hrs (daily)
It has been stopped Temporarily.
Performance Analysis(per server)
Number of Hits/ Day
1 Lac - 200 hits
1 Lac - 401 hits
.5Lac - others
2GB - 2.5GB
5GB - 6.5GB
35K - 37K
View Complete Post