1

Have an old MOSS2007 "mammonth" on SQL 2008, which have performance issues.

IIS often crashes and gives "Unknown error".

It is a two-tier Farm with Database on one server and WFE+App.Server on the other. Hardware is the same:

enter image description here

About 1'800 users registered, size of Content DB is about 470Gb. Databases are well separated according best practicies (databases are stored on different LUN's, MDF and log files are separated too).

There are 4 web applications:

  • Central Admin,
  • Personal Sites,
  • Shared Services administration,
  • Root web application, example http://sp.

This root site collection contains about 10 site-collections: http://sp/blabla/another_site_collection1,2,3.. and most of them have few webs and workspaces, (in total not more than 150).

Search is configured in Shared Services Provider, and there are about 1'270'000 elements crawled.

I used

%stsadm.exe% -o enumsites -url "http://sp" >> c:\site_collections_size.txt

command and found that Root site collection and one other has more than 100Gb:

<Sites Count="43"> ..  <Site Url="http://sp" ..  
StorageUsedMB="112567,5" StorageWarningMB="0" StorageMaxMB="0" />   ..
<Site Url="http://sp/blabla/blabla" ..   StorageUsedMB="124295,8"
StorageWarningMB="180500" StorageMaxMB="200500" />   ..

What I detected is two problems:

  • I think 8Gb RAM for WFE could be Ok, but 8Gb for database is extremely small.

  • And the second problem I think is Search - the additional crawl runs for 49 hours, and it is still running non-stop. And also there is configured Full Crawl every week. Configuration of additional Crawl is strange: "for 24 hours, every 8 hours"

enter image description here

So I think Search is configured wrong and it hangs the system. I think I need to turn of Full crawl (it is only necessary on first time, as I know), and I'll set additional crawl to night time. What do you think?

  • 1
    How many site collections in the content Database? do you have documents or photos, which cause that big size? do you have auditing enabled? – Waqas Sarwar MVP Apr 5 '16 at 19:13
  • Hi! don't have any additional information now. Will provide more data tomorrow – Gennady G Apr 5 '16 at 19:46
  • Sorry guys, still no details.. – Gennady G Apr 20 '16 at 9:52
2

Some things to consider:

  • Make use of the object cache.
  • You can always beef up SQL--add more memory.
  • You can also add more servers to your farm to open up two lanes of possible web traffic.
  • Retention policies can be set into place to clean up an environment of unused sites, content, historical data, tests, junk, redundancy, etc.
  • On that note, you could set up an archiving solution to archive or move old data to another site collection.

If you want to go the route of splitting the database, I would recommend using export/import to your advantage, although much of the content may be lost/disfigured based on the original site collection and customizations, so you'll have to test. You need to split the site collection into many site collections (lowest logical structure to house on another content database), which would require planning. I recommend splitting them at the department level. HR, IT, and operational departments, recruiting, upper management, etc. Beware, that sort of project is not to be taken lightly.

  • Thank You very much for advices! Yes I understand there is no "silver bullet". Yes I used stsadm import/export - permissions will be lost in that case.. And even if I archive/move some data to another database - db will remain the same size. SQL Shrink and Rebuild Indexes needed - but on this size I think it could take a week of Farm downtime, uff.. I'll get access tomorrow and make update with new information here! – Gennady G Apr 5 '16 at 19:44
  • If you archive data to another site collection with another database, you will have more space available, but yes you will need to shrink the database if you really want to downsize the size of the database. – Mike Apr 5 '16 at 19:54

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.