|Development 01 September 2013 -|
Obviously, I am going to run my 30 days challenge of Microsoft SharePoint a little bit different than some readers might have expected it.
No, I'm not starting at the 'Chapter 1' of what SharePoint actually is but directly jump into the optimisation of how SharePoint and SQL Server should work together in best terms possible. Out of experience I can tell you that it is quite a bit frustrating to discover at any time later that your installation and configuration of a product is actually messed up out-of-the-box. And that's what actually happens all the time when you start to read a book from start to end; the best practices and optimised parameters for the working environment are only revealed after most of the work has been completed. Time to throw over everything and do it again from scratch but now with 'the expert's advice' at hand. Sticking to the DRY principle I am not a fan of re-doing my stuff all the time but prefer to learn the proper way at the beginning. Getting rid of wrong paradigms is more difficult than to avoid them in the first place.
Okay, let's have a look at what to expect from this great Jump Start session over at the Microsoft Virtual Academy:
The Jump Start is split into 4 modules and comes with the slide presentation as additional material. Personally, I like the fact that all four videos are available with closed captions which helps in some occassions to keep track of some words. Very helpful to non-native speakers of English language.
A proper and correct installation of SQL Server is not only essential but very crucial to a successful deployment of SharePoint. Some settings like the default collation setting can be specified during installation only and not changed any time later. Furthermore, due to the amount of databases that SharePoint uses (23 for version 2013) it is compulsory to provide a dedicated SQL instance - either default or named instance - for SharePoint. Modify the default values of initial size and auto-growth in Megabytes (MB) in the model database of SQL Server as this will put less stress and work on the installation during daily usage; or better said it will provide better performance than the default values.
And last but not least have a conversation with your Database Administrator (DBA) to avoid any manual optimisation in a SharePoint SQL instance. The results might (for almost sure) be contra-productive with future service packs, hotfixes or updates of SharePoint as your installation is going off-track from the expected environment by the SharePoint development team. So, don't be surprised in case your SharePoint goes nuts after your DBA applied some 'improvements'.
I'm glad that Bill and Brian provide the ultimate formula to calculate the Maximum Memory Setting: ;-)
Get your calculators ready. Of course, this all depends on the purpose of your machine and whether it is used exclusively for SharePoint or in correlation with other SQL instances and services running.
Despite having proper or better configuration settings for SQL Server it is also interesting to spent some time on the operating system, mainly the details of your hard drives, like NTFS allocation unit size. According to the experts of the Jump Start newer versions of Windows Server (2008 or higher) already should have a better setting but still run a chkdsk from your administrative command prompt and get to know.
Anything different than 64K should be changed (4096 is the usual default value). As for your data drives this might be an easy exercise but your system drive should have the optimal allocation unit size, too. Which in worst case means that you have to re-install the whole system. As I stated above: Do it correctly from the beginning and only once! Anyway, here's the command in order to get your drives ready:
In order to get an optimal environment to run a performant installation of Microsoft SharePoint there are quite a number of important settings to have a look at. Not too many after all but still some that need attention prior to installation or during installation of either operating system, SQL Server instance or SharePoint databases and services.
Very helpful insights in tuning your SQL Server 2012 for SharePoint 2013. Overall great a Jump Start and lots of funny jokes and comments. It's a real pleasure to follow those modules and the content provided. Honestly, I hope that Brian had good luck with his choice of hair growth products.
Day 2 - While reading some SharePoint blogs I came across the following whitepaper on Maximizing SQL 2012 Performance for SharePoint 2013 by Vlad Catrinescu. Thanks to Stephan Oetzel.