I will be Presenting at South East Asia SharePoint Conference – Maintaining SQL Server at Optimal Performance for Blazing Fast SharePoint Site. I am very excited beuse this is going to be my very first series of presentations at SharePoint Conference. Since I posted details about the event, I have been asked many times about the kind of demo I will be having in the session.
If you are a regular reader of this blog, you know that my core area is performance tuning. I am going to focus on the same subject when I present at the SharePoint Conference. I will share with you the slide decks and demos once I am back from the session. However, I have seen that there is a good amount of curiosity on the subject that I am going to tackle in the upcoming session, so here are a few details of the demo that I’ll present there:
Demo 1: Importance of File Subsystem and Its Effect on Performance
In this demo, I will have three various examples to be presented in front of the attendees. The examples will enable us to see various configuration options and optimal configuration for SQL Server data files and log files.
Demo 2: Importance of Filegrowth settings
Pre-configuration of the data files and filegrowth is usually ignored in default SharePoint installations. I will go over this concept and will make it interesting for all.
Demo 3: Important of Statistics
Does Statistics matter for SharePoint as well? It does, and we will see the effect of Statistics on performance using this demo.
Let me know if you have any idea so I could probably create a fourth demo that would capture the interest of SharePoint developers. I will give complete credit to anyone who can give me a great idea.
Reference: Pinal Dave (https://blog.sqlauthority.com)