October 10, 2011 at 2:10 am
Hello,
I wondered if anyone could give me a little advice, I have a server that already has 3 intances of SQL 2008 (64bit), and I am being asked if having a 4th instance that will house the latest sharepoint databases on it. I'm not keen, what are some good compelling real world reasons for having Sharepoint in its own machine?
Thanks for reading.
Regards,
D
October 10, 2011 at 5:16 am
Management likes the word consolidation... A few questions:
Is it SharePoint 2007 or 2010?
How many SP users do you plan to have within three years from now?
How many WFE, Search servers, etc. in your farm?
Two good reasons even w/o answer from you:
1.If the other 3 instances host "heavy load" databases, forget it because SP Search crawl will tear down SQL server performance on a regular basis.
2. should you need to move the database on a separate instance because you notice that a shared server is suboptimal, you'll be in trouble when trying to move the SP configuration databases and will need to run Setup again on the SP servers.
October 10, 2011 at 5:38 am
Hello,
Thanks for getting back
Is it SharePoint 2007 or 2010? 2010
How many SP users do you plan to have within three years from now? 100-120
How many WFE, Search servers, etc. in your farm? Not sure at this stage, but Windows 7 clients will configured to use the search.
Regards,
D.
October 11, 2011 at 2:38 am
Where does your company want to spend its money? On isolating the impact of SharePoint in its own Windows instance or in the extra admin cost of running everything on a single Windows instance and possibly (probably?) suffering the impact of poor performance of both SharePoint and non-SharePoint systems.
If you have enough cores amd memory on your Windows box and you are prepared to set processor affinity for the various SQL instances and you are prepared to risk that after all this you will still get poor performance, then go ahead and put everything on a single box. If alternatively you want to reduce risk in your environment and safeguard SLAs for the non-SharePoint services then putting SharePoint on its own Windows instance seems like a good idea.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply