Access "Does your SQL Server database improve SharePoint performance?"
This article is part of the November 2008 issue of Designing a Sharepoint governance plan
SharePoint lives and breathes by its SQL Server databases. With the introduction of Windows SharePoint Server, even a small company can end up with a database that is quite large. And a large company can end up with a database that quickly approaches a ridiculous size. Every page that the SharePoint portal displays is saved into a SQL database. So is every document uploaded into the document repository. SharePoint doesn't necessarily follow the SQL Server table design best practices. More on SharePoint performance tuning SharePoint performance demands finely tuned SQL Server, storage That, in addition to having these large databases, can mean that designing a highly scalable SQL Server to run your SharePoint environment can be a challenge. Smaller systems can work nicely on your existing SQL Server hardware This doesn't change if your current environment is running on the x86 hardware platform. (Note: In this article, "x64" refers to both x64 and Itanium platforms.) Larger systems will want to move into the x64 hardware platform. The x64 platforms give SQL ... Access >>>
Premium Content for Free.
Balancing SharePoint governance
by Joel Oleson
Service models work hand in hand with governance to shape each SharePoint deployment into a unique installation that meets business needs.
Creating a SharePoint site map using out-of-the-box features
by Paul Galvin, Contributor
Giving SharePoint site owners the power to manage their own part of the SharePoint site map frees up administrators to manage more critical areas of the SharePoint environment.
- Balancing SharePoint governance by Joel Oleson
Does your SQL Server database improve SharePoint performance?
by Denny Cherry, Contributor
Growing your SQL Server installation beyond a single server, and maintaining proper storage levels can greatly improve SharePoint Server performance.
- Does your SQL Server database improve SharePoint performance? by Denny Cherry, Contributor
More Premium Content Accessible For Free
Technology trends like mobile devices, cloud computing and remote workforces have brought new demands to the arena of enterprise content management. ...
Many organizations struggle to establish information governance policies in the face of cultural challenges, immature processes and tepid executive ...
There's much more to managing the customer experience than simply optimizing Web content management to make things more interactive. Effective ...