Wednesday, March 15, 2006 2:39 PM Jan Tielens

SharePoint Portal Server 2003 Performance Tip: Use SQL Server 2005

[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%

Filed under:

Comments

# re: SharePoint Portal Server 2003 Performance Tip: Use SQL Server 2005

Wednesday, March 15, 2006 9:55 AM by Dion

I am assuming same would be true for WSS?

# re: SharePoint Portal Server 2003 Performance Tip: Use SQL Server 2005

Wednesday, March 15, 2006 12:41 PM by Shane Young [SPS MVP]

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

# re: SharePoint Portal Server 2003 Performance Tip: Use SQL Server 2005

Wednesday, March 15, 2006 3:11 PM by SBC

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..

# re: SharePoint Portal Server 2003 Performance Tip: Use SQL Server 2005

Monday, March 20, 2006 5:46 PM by Steve Savage

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

# re: SharePoint Portal Server 2003 Performance Tip: Use SQL Server 2005

Wednesday, March 22, 2006 11:38 PM by Luis

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.

# re: SharePoint Portal Server 2003 Performance Tip: Use SQL Server 2005

Tuesday, March 28, 2006 2:09 PM by Giles Gregg

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?

# gaba: P??rgess??k fel a SharePointot SQL Server 2005-tel

Monday, December 11, 2006 3:13 PM by gaba: P??rgess??k fel a SharePointot SQL Server 2005-tel

PingBack from http://gaba.lenard.hu/2006/03/16/porgessuk-fel-a-sharepointot-sql-server-2005-tel/

# stefan @ decatec - Sharepoint performance benchmarking standards

Wednesday, January 10, 2007 3:09 PM by stefan @ decatec - Sharepoint performance benchmarking standards

PingBack from http://www.decatec.it/blogs/PermaLink,guid,dfa9c82e-1bfa-4f1a-a571-7aba4042b37b.aspx

# stefan @ decatec - Sharepoint performance benchmarking standards

Friday, January 12, 2007 6:29 AM by stefan @ decatec - Sharepoint performance benchmarking standards

PingBack from http://www.decatec.it/blogs/2007/01/10/Sharepoint+Performance+Benchmarking+Standards.aspx

# re: SharePoint Portal Server 2003 Performance Tip: Use SQL Server 2005

Wednesday, May 02, 2007 12:18 PM by Premachandu vutla

Hi Jon,

       I have done a lot of search over the net but i cant get any comprised document that can tell me the benifits that can be found when MOSS is deployed over an SQL Server 2005 rather than over an SQL server 2000.

If you have some reference for the above mentioned scenario, can you please share that over your blog.

Thanks & Regards,

Premchand.

# P??rgess??k fel a SharePointot SQL Server 2005-tel - lenardgabor.hu

Monday, August 17, 2009 11:44 AM by P??rgess??k fel a SharePointot SQL Server 2005-tel - lenardgabor.hu

Pingback from  P??rgess??k fel a SharePointot SQL Server 2005-tel - lenardgabor.hu