1 / 3

Considerations for Large-Scale SharePoint Deployments on Microsoft SQL Server

Considerations for Large-Scale SharePoint Deployments on Microsoft SQL Server. Michael O’Donovan (and Gary Hope). Top Take Aways. Database usage characteristics Which databases are most IO intensive? Ways to improve performance RAM and x64 Misaligned Partitions

lance
Download Presentation

Considerations for Large-Scale SharePoint Deployments on Microsoft SQL Server

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Considerations for Large-Scale SharePoint Deployments on Microsoft SQL Server Michael O’Donovan (and Gary Hope)

  2. Top Take Aways • Database usage characteristics • Which databases are most IO intensive? • Ways to improve performance • RAM and x64 • Misaligned Partitions • Separate out log and data (raid 10 and raid 5) • Separate out TempDB and SearchDB • Multiple secondary files for TempDB • Fragmentation Kills • AutoGrow -> Set initial sizes on databases • ALTER INDEX REORGANIZE (> 5% and < = 30%) • ALTER INDEX REBUILD (> 30%)

  3. Top Take Aways • Perf monitoring • Perf counters • sys.dm_io_virtual_file_stats stored procedure • Iw.co.za • 98% fragmented indexes • Excel sheet to show IO on databases • Attempted to show all this through Excel Services

More Related