Data Management Strategies for the CIOAccess "SharePoint performance sinks, swims with SQL Server throughput "
This article is part of the August 2012 issue of Open source add-ons enhance Sharepoint 2010 collaboration
When things slow down in a SharePoint system, the initial fix is often to add more Web servers to better handle the load. But those front-end servers rely on the same back-end database server, and the back end is where SharePoint usually encounters the most performance problems. That’s because it essentially relies on SQL Server as both a database and a file system. It’s not that SQL Server isn’t a speed demon; it can be. But SharePoint’s processing demands tend to highlight SQL Server’s most common bottleneck: disk I/O. It’s important to keep that in mind when planning for long-term SharePoint performance management. So what can you do to mitigate, or even avoid, the logjams that can snarl SQL Server throughput? Start by getting SharePoint’s binary large objects, or blobs -- typically file attachments if you’re a SharePoint person -- out of the SQL Server database. Both SharePoint and SQL Server support Microsoft’s Remote BLOB Storage (RBS) technology, which enables SQL Server to put all of those Word, Excel and other documents back on the NTFS file system... Access >>>
Access TechTarget
Premium Content for Free.
What's Inside
Features
-
-
Open source tools level SharePoint 2010 collaboration playing field
by Shawn Shell, Contributor
SharePoint 2010 collaboration can be beefed up with open source add-ons that offer organizations with tight budgets a leg up in addressing the shortcomings of the platform’s built-in capabilities.
-
SharePoint performance sinks, swims with SQL Server throughput
by Don Jones, Contributor
To help ensure that SharePoint performance doesn’t get bogged down, organizations need to build and maintain a scalable back-end database system that can eliminate SQL Server disk I/O issues.
-
Open source tools level SharePoint 2010 collaboration playing field
by Shawn Shell, Contributor
-
-
Well-planted SharePoint 2010 backup strategy could help save the farm
by Brien M. Posey, Contributor
A SharePoint farm backup as part of an enterprise SharePoint 2010 backup strategy is simple, but on its own might not be enough. Brien M. Posey points out the other important considerations.
-
Well-planted SharePoint 2010 backup strategy could help save the farm
by Brien M. Posey, 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 ...