Logo 
Search:

MOSS Forum

Ask Question   UnAnswered
Home » Forum » MOSS       RSS Feeds

MOSS 2007 on Production Environment

  Asked By: Keaton    Date: May 14    Category: MOSS    Views: 1029

We are going to be launching our new Intranet site which has been
developed on MOSS 2007 Beta 2, in the next 8 to 10 days.

Question:

Will MOSS run better on SQL Server 2000 or SQL Server 2005?

The reason I ask is because when MOSS was crawling our file store
last week, the DB server had a power cut and hasn't recovered since -
and the index service refuses to stop as well ! :(

Anyway, I've heard that MOSS runs more stable on SQL Server 2000 so
shall we go ahead and install MOSS on SQL Server 2000 or risk going
on SQL Server 2005?

Share: 

 

10 Answers Found

 
Answer #1    Answered By: Damon Garner     Answered On: May 14

I would wait until the Technical Refresh to set up any production
environments. You cannot upgrade from Beta2 to RTM without
uninstalling and reinstalling the whole thing... but you can upgrade
from the TR.

Details are listed on the MS Sharepoint Team Blog site...
blogs.msdn.com/.../665864.aspx

 
Answer #2    Answered By: Karla Morrison     Answered On: May 14

Minor correction; while upgrading directly from B2 to RTM will not be
supported, uninstalling and reinstalling the whole thing will not be
required either. The upgrade path is only from B2 to B2TR to RTM. You
just can't skip from B2 to RTM. We are implementing productions sites in
B2 that we plan to upgrade to B2TR and eventually to RTM.

 
Answer #3    Answered By: Patricia Richardson     Answered On: May 14

With B2TR coming so soon, I would still hold off. I had thought the
install was non-compatible from B2 according to Microsoft Tech Specs
that we have working with us, but I see what you are saying. The B2
> B2TR > RTM just seems like a lot of upgrading, imo.

 
Answer #4    Answered By: Alexandra Patterson     Answered On: May 14

As for your SQL 2000 vs. SQL 2005 questions... I think this article
may be of some use to you. I am not technically inclined, but I
remember reading this before off the Sharepoint Team blogs.

Its a performance bench test of both products.
office.microsoft.com/.../HA100993571033.aspx

 
Answer #5    Answered By: Christop Mcfadden     Answered On: May 14

As for your SQL 2000 vs. SQL 2005 questions... I think this article
may be of some use to you. I am not technically inclined, but I
remember reading this before off the Sharepoint Team blogs.

Its a performance bench test of both products.
office.microsoft.com/.../HA100993571033.aspx

 
Answer #6    Answered By: Stefanie Ruiz     Answered On: May 14

I am designing a large my site implementation on oss2007, SQL 2005. the tests we
ran showed 19% - 25% better performance than with sql2k. I have also had some
search issues, but I am depending on PSS to resolve those quickly after RTM.

I say SQL2k5 all the way... it also has better disaster continuance features.

 
Answer #7    Answered By: Damon Garner     Answered On: May 14

I'd go with SQL Server 2005. There have been reports of up to 10-60%
performance boost running on 2005. Only one odd configuration resulted
in diminished performance (as I recall). Make sure you install SQL
Server 2005 SP1 too. We ran into a problem until we installed SP1.

 
Answer #8    Answered By: Royce Orr     Answered On: May 14

FWIW, most of the reports of 30-60% perf improvement were attributed from going from x32 SQL2000 -> x64 SQL2005 (which isn’t really fair). Regardless, Todd’s right, head for the hills with SQL2005!

There’s also a post rollup hotfix in addition to SP1 you’ll want to install.

 
Answer #9    Answered By: Laura Walker     Answered On: May 14

I am going with SQL Server 2005 after hearing all suggestions of
performance increases, especially if we are going to be hosting a
Intranet site for a hundreds of employees.

By applying the latest SQL Server 2005 hotfix, we have eliminated the
search crawler problem… hooray.

This is a useful link to see what version of SQL Server 2005 you're
running:

http://www.aspfaq.com/sql2005/show.asp?id=20

 
Answer #10    Answered By: Nina Banks     Answered On: May 14

Here’s another resource for checking the version of SQL you’re running (as well as .NET, CMS, WSS & SPS)… I’m not adding WSS v3/MOSS until it’s RTM.

andrewconnell.com/.../ApplicationVersions.aspx

 
Didn't find what you were looking for? Find more on MOSS 2007 on Production Environment Or get search suggestion and latest updates.




Tagged: