SQLAuthority News – Presenting at South East Asia SharePoint Conference – Oct 26, 27, 2010 – Singapore

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!

SQLAuthority News – Presenting at South East Asia SharePoint Conference – Oct 26, 27, 2010 – Singapore SharePointConference (1)
Pinal Dave presenting at SharePoint Conference at Singapore

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.

SQLAuthority News – Presenting at South East Asia SharePoint Conference – Oct 26, 27, 2010 – Singapore SharePointConference (2)
Pinal Dave presenting at SharePoint Conference at Singapore

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.

SQLAuthority News – Presenting at South East Asia SharePoint Conference – Oct 26, 27, 2010 – Singapore SharePointConference (3)
Pinal Dave presenting at SharePoint Conference at Singapore

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.

SQLAuthority News – Presenting at South East Asia SharePoint Conference – Oct 26, 27, 2010 – Singapore SharePointConference (4)
Pinal Dave presenting at SharePoint Conference at Singapore

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.

SQLAuthority News – Presenting at South East Asia SharePoint Conference – Oct 26, 27, 2010 – Singapore SharePointConference (5)
Pinal Dave presenting at SharePoint Conference at Singapore

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.

SQLAuthority News – Presenting at South East Asia SharePoint Conference – Oct 26, 27, 2010 – Singapore SharePointConference (6)
Pinal Dave presenting at SharePoint Conference at Singapore

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.

SQLAuthority News – Presenting at South East Asia SharePoint Conference – Oct 26, 27, 2010 – Singapore SharePointConference (7)
Pinal Dave presenting at SharePoint Conference at Singapore

Reference: Pinal Dave (https://blog.sqlauthority.com)

Best Practices, SharePoint, SQLAuthority Author Visit
Previous Post
SQLAuthority News – Last Day to Participate in my Questions at SQL Quiz
Next Post
SQLAuthority News – Why I am Going to Attend PASS Summit Unite 2010 – Seattle

Related Posts

2 Comments. Leave new

  • Debbie Ireland
    November 8, 2010 5:48 am

    Great to have you at the conference, thank you for contributing and presenting, we have already had excellent feedback from your session – will welcome you back in 2011! Regards, Debbie

    Reply
  • Dear Sir,

    May I have a copy of your demo steps that your suggested in
    Maintaining SQL Server at Optimal Performance for Blazing Fast SharePoint Site that in Singapore?

    Many thanks,
    Edwin

    Reply

Leave a Reply