Every SharePoint site runs on SQL Server and most of the SharePoint sites face issues with performance due to suboptimal configuration of underlying SQL Server. Recently, I presented a session on SharePoint and SQL Server Performance at Singapore on Oct 26-27, 2010. It was South East Asia SharePoint Conference, and I must say, the event was a blast!
This was very a unique event in Asian Sub-Continent and also one of the best managed conferences that I have attended thus far. The location of the event was very good, and the rooms were large enough to accommodate a huge crowd. Mike Fitzmaurice presented the keynote on the history of the amazing product and the factors that were involved in taking SharePoint to a 1st class Collaboration Platform. There were 42 sessions in 04 different tracks followed by the keynote and I noticed that all the sessions had the room brimming with crowd, and during some sessions, we even had people standing at the back of the room.
Besides delegates and speakers, the credit of this successful event goes to Debbie Ireland, Randy Williams and Steve Sofian. They had put in lot of efforts to make this event successful. Every single aspect was properly organized.
I presented a session on Maintaining SQL Server at Optimal Performance for Blazing Fast SharePoint Site!
My session was slightly different than my previous sessions. I started with a slightly pessimistic talk about how one cannot achieve many functionalities and performance aspects in SQL Server when SharePoint Server is installed. After this 2-minute talk, I explained why there are so many restrictions. Right after this, I demonstrated few concepts and ideas to attendees, which they could apply right away to their database and obtain the desired performance instantly. I promised the attendees that if they follow my suggestions right after they walk out of the session, they will surely achieve the desired performance of their SharePoint box instantly.
The details of the demo are as follows:
Demo 1: Importance of File Subsystem and Its Effect on Performance
In this demo, I had three various examples to be presented in front of the attendees. The examples enabled 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 explained this concept and tried to make it interesting for all the attendees.
Demo 3: Important of Statistics
Does Statistics matter for SharePoint as well? It does, and we noted the effect of Statistics on performance using this demo.
Reference: Pinal Dave (https://blog.sqlauthority.com)