February 13, 2008 at 5:20 pm
We are going to install SharePoint Services for company collaboration on documents, etc. My manager is suggesting that we put the associated SQL databases onto our main production server (SQL 2005 EE) where we have about 10 production databases which are mirrored to another server.
Our current strategy for the mirroring is a system that fails over all the production databases, plus the applications, to the mirror server in the event that a single production database fails over.
Is it OK to put the SharePoint databases on the production server? If so, should we mirror them?
Does anyone have any experience with the pros and cons of putting all these eggs in one basket? Currently I have the luxury of being able to take down the production server for testing and/or maintenance during non-business hours. I'm concerned that the users would probably expect 24/7 access to the SharePoint data.
Thanks for your time,
Elliott
February 14, 2008 at 5:40 am
Since you are mirroring, all of your eggs are in two baskets - so there is little risk.
Sharepoint database access is not much of a server load, so putting it on the same server is not a big problem. It is a lot of file IO on the sharepoint databases, so if you have a RAID array that is not currently being used, I would try to put it on it's own set of disks.
Read up on sharepoint database recovery - because of the multiple database thing, it is a bit more complicated than just restoring a backup. This may have an impact on your mirroring solution, but it should be workable.
February 14, 2008 at 10:02 pm
One caveat on the sharepoint database typically not being a big resource hog - when Sharepoint kicks off a crawl of it's content databases it's a HUGE hog, the rest of the time it's typically not bad but when a crawl is running watch out.
February 15, 2008 at 3:01 pm
Thanks guys, I'll study up more along the lines you suggested. I already believe in performing periodic restores from backups to prove that the system works, so it's valuable to know that SharePoint takes some special handling in that regard.
Elliott
February 27, 2008 at 10:56 am
The whole backup and restore functionality is somewhat funky with Sharepoint, and it might not function with the processes that you currently use.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply