Eleventh Commandment.


Thou Shall not visualize my SQL Server in a SharePoint Farm.

 I have noticed with many clients that use virtualization technologies, that after 8 month to a year or usage , they come back complaining from performance.

I have seen and known about those problems for years but it is a multi faceted  issue.

 [1] Infrastructure Decision makers are not the application developers nor the users nor have any experince with the baseline performance of “the application” but only focused on the Disater Recovery ( of disasters that never happen ) ( and if it happens they will never recover from ) . Also they are very focused on uptime of the OS and that is all not even the performance of the OS.

[2] Not Provisioing the correct virtual resources of the proper types.

SQL Server and his Cousin Mr. Exchange Server like to eat lots of Disk I/O , hence we have to isolate the high frequency Disk io consumers from each other.

[1] Windows Disk Cache.

[2] TempDB database location.

[3] Database storage disk.

[4] Database Log Storage.

[5] Backup storage.

With that being said, I am totally for having the SharePoint Web Front End (WFE) servers on virual machines,

performance of IIS on those machines is screaming fast. and will enhance your Fram’s overall performance.

But if you are looking for the real ten commandments click the link.

Advertisements

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