The database required for most Microsoft products, including SharePoint
The new release of SQL Server introduces new features that will likely be of particular interest and relevance to content management solutions. Two sections worth reading in the Product Overview white paper: Occasionally Connected Systems (offline scenarios) and Beyond Relational Data. Beyond Relational Data includes two features of interest:
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% |
Full details at: http://office.microsoft.com/en-us/assistance/HA100993571033.aspx