SharePoint Portal Server 2003 Performance Tip: Use SQL Server 2005

Wednesday, March 15, 2006

[Via Martin] Do you want to increase the performance of your SharePoint Portal Server 2003 Server farm up to 59%? Just switch from SQL Server 2000 to SQL Server 2005! More information and test details over here: SQL Server Performance Test Results.

The results were captured by measuring the average Requests Per Second (RPS) for each farm size and SQL Server version. The following table presents the performance impact of using SQL Server 2000 versus SQL Server 2005.

Farm size	SQL Server 2000 average RPS	SQL Server 2005 average RPS	Change
Small	75	97	+29%
Medium	131	198	+51%
Large	1015	1114	+10%
Extra-large	1638	1932	+18%
Extra-large, topics only	1148	1820	+59%
Extra-large, team sites only	1722	1610	–7%
Extra-large, home page only	1736	1750	+1%

6 Comments

I am assuming same would be true for WSS?

Dion - Wednesday, March 15, 2006 1:55:00 PM

Who is using 64 bit SQL Server 2000? I would have preferred the test be on 32 bit hardware. Check out my post.

Shane Young [SPS MVP] - Wednesday, March 15, 2006 4:41:00 PM

Dion - I think it would be the same for WSS provided SQL Server 2005 is being used and not SQL Server Express 2005. Interesting question though..

SBC - Wednesday, March 15, 2006 7:11:00 PM

Is there any special installation method needed to integrate Sharepoint with SQL2005? I didn't even know it was compatible.

Steve Savage - Monday, March 20, 2006 9:46:00 PM

I would like to know the procedure to install sps with sql 2005, I installed first sql 2005 standard edition and when sps begans setup it doesnt detect a database to install.

Luis - Thursday, March 23, 2006 3:38:00 AM

I have heard some people say that SPS2003 has some 'issues' running on SQL2005 and its better to run on SQL2000 until a service pack is released to resolve the problems. Any merit in this?

Giles Gregg - Tuesday, March 28, 2006 6:09:00 PM

Comments have been disabled for this content.