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!

Pinal Dave presenting at SharePoint Conference at Singapore
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.

Pinal Dave presenting at SharePoint Conference at Singapore
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.

Pinal Dave presenting at SharePoint Conference at Singapore
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.

Pinal Dave presenting at SharePoint Conference at Singapore
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.

Pinal Dave presenting at SharePoint Conference at Singapore
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.

Pinal Dave presenting at SharePoint Conference at Singapore
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.

Pinal Dave presenting at SharePoint Conference at Singapore
Pinal Dave presenting at SharePoint Conference at Singapore

Reference: Pinal Dave (http://blog.SQLAuthority.com)

About these ads

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

  1. Pingback: SQLAuthority News – Community Tech Days – A SQL Legends in Ahmedabad – December 11, 2010 Journey to SQL Authority with Pinal Dave

  2. Pingback: SQLAuthority News – My Evaluation of Singapore SharePoint Conference Journey to SQL Authority with Pinal Dave

  3. 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

    Like

  4. Pingback: SQL SERVER – Beginning New Weekly Series – Memory Lane – #002 « SQL Server Journey with SQL Authority

  5. Pingback: SQLAuthority News – Speaking at Southeast Asia SharePoint Conference 2013 – Singapore « SQL Server Journey with SQL Authority

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s