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 >>>
Access TechTarget
Premium Content for Free.
What's Inside
Features
-
-
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
Creating an ECM strategy: Tips and advice
E-Handbook
Enterprise content management (ECM) systems can help organizations keep better track of documents, emails and other important unstructured ...
Developing a SharePoint collaboration strategy that gets results
E-Handbook
Consult this white paper to determine whether it's time to upgrade to a newer version of SharePoint now that SharePoint 2013 is available. Creating ...
Enterprise social: Building the business case and getting started
E-Handbook
While many organizations are realizing the benefits of enterprise social media and the tools that make it possible, it’s important to understand the ...