BlogPost

The official blog of the Microsoft SharePoint Product Group

2010

August 16

Database Maintenance for SharePoint Whitepaper

System Account on 8/16/2010 4:14 AM

Category: Scale storage SQL

Bill Baer’s white paper: Database Maintenance for SharePoint is now live. Here's a sneak peak into the contents. Kudos Bill! This level of content is outstanding!

CHECK FOR AND REPAIR CONSISTENCY ERRORS BY USING DBCC CHECKDB
About DBCC CHECKDB
DBCC CHECKDB and performance
MEASURE AND REDUCE FRAGMENTATION
Measure fragmentation in a SQL Server 2005 database (sys.dm_db_index_physical_stats)
Measure fragmentation in a SQL Server 2000 database (DBCC SHOWCONTIG)
Reducing Fragmentation for a Database
Reducing fragmentation for a specific table and its indexes
Using ALTER INDEX
Fine tuning index performance by setting fill factor
Shrinking data files
Shrinking a database by using Transact-SQL commands
Shrinking a database by using SQL Server 2005 Management Studio
CREATING SQL SERVER 2005 MAINTENANCE PLANS
Configure a SQL Server 2005 Database Maintenance Plan

Thanks,

Joel Oleson

8 Comment(s)

Comments

re: Database Maintenance for SharePoint Whitepaper

If someone would be intersted, you can see possible improvement results on typical actions in SharePoint after using proposals from Microsoft.
http://www.starsoft.com.pl/en/files/Windows%20SharePoint%20Services%20Content%20Databse%20performance%20results.pdf

Commented by <empty> on 4/12/2010 12:20:27 AM

System Account

on 4/12/2010 12:20 AM

re: Database Maintenance for SharePoint Whitepaper

Never, Ever, Ever shrink a database. This is SUCH dangerous advice!

Commented by <empty> on 3/29/2010 3:34:12 PM

System Account

on 3/29/2010 3:34 PM

I was with a customer one day (again)…

I guess I could make this a series huh? :-)   Here are some further documentation around performance

Commented by <empty> on 1/9/2009 7:25:53 PM

System Account

on 1/9/2009 7:25 PM

Best Practices - SharePoint Object Model for Performance Tuning

I am writing this post by inspired by couple of performance related cases that I had been worked with

Commented by <empty> on 10/26/2008 7:30:37 AM

System Account

on 10/26/2008 7:30 AM

TechEd08: Microsoft Office SharePoint Server 2007: Administrative Architecture, Deployment and Operations Fundamentals (Part Two)

Continuing our coverage of this pulse-pounding, double-sized SharePoint session extravaganza, we pick

Commented by <empty> on 6/11/2008 10:42:42 PM

System Account

on 6/11/2008 10:42 PM

Database Maintenance for SharePoint

In the spirit of my earlier post ( http://dotnet.org.za/zlatan/archive/2008/03/09/sql-server-database

Commented by <empty> on 3/9/2008 7:26:50 PM

System Account

on 3/9/2008 7:26 PM

Database Maintenance for SharePoint Whitepaper

Did you see this post at blogs.msdn.com

Commented by <empty> on 2/28/2008 9:00:07 PM

System Account

on 2/28/2008 9:00 PM

BioSensorAB » Database Maintenance for SharePoint Whitepaper

PingBack from http://www.biosensorab.org/2008/02/28/database-maintenance-for-sharepoint-whitepaper/

Commented by <empty> on 2/28/2008 7:35:42 PM

System Account

on 2/28/2008 7:35 PM

View in Web Browser

/blog/_layouts/VisioWebAccess/VisioWebAccess.aspx?listguid={ListId}&itemid={ItemId}&DefaultItemOpen=1

0x0

0x1

FileType

vdw

255

Compliance Details

javascript:commonShowModalDialog('{SiteUrl}/_layouts/itemexpiration.aspx?ID={ItemId}&List={ListId}', 'center:1;dialogHeight:500px;dialogWidth:500px;resizable:yes;status:no;location:no;menubar:no;help:no', function GotoPageAfterClose(pageid){if(pageid == 'hold') {STSNavigate(unescape(decodeURI('{SiteUrl}'))+'/_layouts/hold.aspx?ID={ItemId}&List={ListId}'); return false;} if(pageid == 'audit') {STSNavigate(unescape(decodeURI('{SiteUrl}'))+'/_layouts/Reporting.aspx?Category=Auditing&backtype=item&ID={ItemId}&List={ListId}'); return false;} if(pageid == 'config') {STSNavigate(unescape(decodeURI('{SiteUrl}'))+'/_layouts/expirationconfig.aspx?ID={ItemId}&List={ListId}'); return false;}}, null); return false;

0x0

0x1

ContentType

0x01

898

Edit in Browser

/_layouts/images/icxddoc.gif

/blog/_layouts/formserver.aspx?XsnLocation={ItemUrl}&OpenIn=Browser&Source={Source}

0x0

0x1

FileType

xsn

255

Edit in Browser

/_layouts/images/icxddoc.gif

/blog/_layouts/formserver.aspx?XmlLocation={ItemUrl}&OpenIn=Browser&Source={Source}

0x0

0x1

ProgId

InfoPath.Document

255

Edit in Browser

/_layouts/images/icxddoc.gif

/blog/_layouts/formserver.aspx?XmlLocation={ItemUrl}&OpenIn=Browser&Source={Source}

0x0

0x1

ProgId

InfoPath.Document.2

255

Edit in Browser

/_layouts/images/icxddoc.gif

/blog/_layouts/formserver.aspx?XmlLocation={ItemUrl}&OpenIn=Browser&Source={Source}

0x0

0x1

ProgId

InfoPath.Document.3

255

Edit in Browser

/_layouts/images/icxddoc.gif

/blog/_layouts/formserver.aspx?XmlLocation={ItemUrl}&OpenIn=Browser&Source={Source}

0x0

0x1

ProgId

InfoPath.Document.4

255

View in Browser

/blog/_layouts/xlviewer.aspx?id={ItemUrl}&DefaultItemOpen=1

0x0

0x1

FileType

xlsx

255

View in Browser

/blog/_layouts/xlviewer.aspx?id={ItemUrl}&DefaultItemOpen=1

0x0

0x1

FileType

xlsm

255

View in Browser

/blog/_layouts/xlviewer.aspx?id={ItemUrl}&DefaultItemOpen=1

0x0

0x1

FileType

xlsb

255

View in Browser

/blog/_layouts/xlviewer.aspx?id={ItemUrl}&DefaultItemOpen=1

0x0

0x1

FileType

ods

255

Add Comment

Items on this list require content approval. Your submission will not appear in public views until approved by someone with proper rights. More information on content approval.

Title

Body *

Captcha

Please verify the text shown in the image

‭(Hidden)‬ Content Editor

Comments

re: Database Maintenance for SharePoint Whitepaper

re: Database Maintenance for SharePoint Whitepaper

I was with a customer one day (again)…

Best Practices - SharePoint Object Model for Performance Tuning

TechEd08: Microsoft Office SharePoint Server 2007: Administrative Architecture, Deployment and Operations Fundamentals (Part Two)

Database Maintenance for SharePoint

Database Maintenance for SharePoint Whitepaper

BioSensorAB » Database Maintenance for SharePoint Whitepaper

Add Comment

Title

Body *

Captcha

Commented By

Migrated Source URL

Commentator Name

Commentator Email

Attachments

‭(Hidden)‬ Content Editor

Comments

re: Database Maintenance for SharePoint Whitepaper

re: Database Maintenance for SharePoint Whitepaper

I was with a customer one day (again)…

Best Practices - SharePoint Object Model for Performance Tuning

TechEd08: Microsoft Office SharePoint Server 2007: Administrative Architecture, Deployment and Operations Fundamentals (Part Two)

Database Maintenance for SharePoint

Database Maintenance for SharePoint Whitepaper

BioSensorAB &raquo; Database Maintenance for SharePoint Whitepaper

Add Comment

Title

Body *

Captcha

Commented By

Migrated Source URL

Commentator Name

Commentator Email

Attachments

BioSensorAB » Database Maintenance for SharePoint Whitepaper