© Stacy Simpkins 2017

Stacy Simpkins, Troubleshooting SharePoint, https://doi.org/10.1007/978-1-4842-3138-8_5

5. SQL

Stacy Simpkins

(1)Brandon, Florida, USA

SQL is the backbone of SharePoint. And, when SQL is properly configured, SharePoint will perform at its best, assuming the servers are properly sized. We’ll talk about overall sizing recommendations for a farm toward the end of this chapter, taking the SQL server and the SharePoint servers into account.

In the previous four chapters, I spoke about the base build for a basic, least-privileged, SharePoint farm and we looked at the settings that need to, at the very least accompany; or better yet, be incorporated into, an automated build. As part of this, we looked at a build with PowerShell and ...

Get Troubleshooting SharePoint: The Complete Guide to Tools, Best Practices, PowerShell One-Liners, and Scripts now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.