?
Solved

Best Practices for Sharepoint 2010 preventative maintenance

Posted on 2012-04-04
2
Medium Priority
?
1,772 Views
Last Modified: 2012-04-17
Hi, just looking for a list or URL with best standard practices for preventative maintenance on Sharepoint 2010. Running on Server 2008 R2 and using SQL 2008 R2 for site content, config DB's.
0
Comment
Question by:Mayogroup
2 Comments
 
LVL 32

Accepted Solution

by:
Jamie McAllister MVP earned 1000 total points
ID: 37809832
0
 
LVL 1

Assisted Solution

by:DBengineer
DBengineer earned 1000 total points
ID: 37813723
Following are some of the very generic tips I would like to share, let me know if this was helpful.

Database related tasks:

Please do the following on the SQL server to maintain the database indexes.

1.      CREATE a utility database called DB_maintenance
CREATE DATABASE [DB_MAINTENANCE]

2.      Execute the attached “dba_indexDefrag_sp_v41” script on DB_MAINTENANCE database

3.      Now execute the attached “Create_Daily_DB_INDEX_Maintenance_job.sql” script.

Create a seperate SQL job to check database integrity.
Create a seperate SQL job to update statistics on all databases.

Sharepoint related tasks:
Use ULS log viewer to go through the SharePoint ULS log file to trouble shoot any issue.
Constantly monitor user profile sync
Constantly monitor Crawl job and the related database size.
Use perfmon to collect and monitor performance metrics.
Monitoring the farm and resolving problems using SharePoint Health Analyzer
dba-indexDefrag-sp-v41.txt
Create-Daily-DB-INDEX-Maintenanc.sql
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You finally migrated Public Folders to Office 365, decommissioned the Public Folder mailbox database and since then, when you send an email from on-premise to mail-enabled Public Folders, you get the following error: "Misconfigured public folder mai…
Exchange database can often fail to mount thereby halting the work of all users connected to it. Finding out why database isn’t mounting is crucial and getting the server back online. Stellar Phoenix Mailbox Exchange Recovery is a champion product t…
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…
In this Micro Video tutorial you will learn the basics about Database Availability Groups and How to configure one using a live Exchange Server Environment. The video tutorial explains the basics of the Exchange server Database Availability grou…
Suggested Courses

612 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question