SharePoint Tidbit – Optimizing SQL for SharePoint on-prem

Hello All, First of all, these steps will be true for both SharePoint 2013 or SharePoint 2016 unless mentioned otherwise, as well the steps will be true for all supported versions of SQL unless stated otherwise. I’m sure you realize this but let it be said SQL is the heart, brain, and body of SharePoint…

1

Reminder about SQL Aliases

Hello All, Recently I was working with a customer as they migrated between SQL servers, and was implementing a SQL alias and after sending them instructions to implement via Registry key they saw performance issues when they hit approx. 5,000 concurrent user connections.  The problem was that they missed implementing one of the registry keys…

0

What can I do about the deadlocks?

Hello All, Since I seem to be discussing this all the time, I thought I would put it in writing for everybody.  When dealing with SharePoint and Deadlocks there is little we can do to directly change the behavior since we are very limited in what can be done to the databases, the Product Group does work to eliminate…

0