Solved

What maintenance is needed for the Sharepoint database?

Posted on 2009-04-05
5
952 Views
Last Modified: 2012-05-06
Hi, I recently came across an excellent post on how to reindex the WSUS database as part of monthly maintenance and was wondering if there is any maintenane tasks such as this that should be performed on the WSS (sharepoint/companyweb) database to keep things healthy.

if there is such a task, is there any chance someone could direct me to or post a script for this, as I would be happy to share the WSUS reindex script I have discovered in return.

0
Comment
Question by:solutionone
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 39

Expert Comment

by:Philip Elder
ID: 24074143
As a rule, no.

The WSUS maintenance has to do with the need to clean up the database of old entries as well as remove any updates taking up space that are no longer needed. The tools for that are in the WSUS console under options for version 3. It is the WSUS Cleanup Wizard.

Unless there is a specific need to get into the database bits, things should run just fine.

WSS V3 with SP2 will have built-in tools to fine tune the SQL 2005 Express instance.

Philip
0
 

Author Comment

by:solutionone
ID: 24074169
thanks Philip, I try to keep on top of these things as much as possible, but I am relatively new to the world of SQL.

by the way I received your Blueprint book last month and have been loving, looking forward to the advanced blueprint.
0
 
LVL 39

Expert Comment

by:Philip Elder
ID: 24074276
Thanks for the compliment on the book! :)

Philip
0
 

Author Comment

by:solutionone
ID: 24114247
Hi Philip, I finally found the blog that made me think that SQL maintenance needed to be done on WSUS.

it can be found at
http://duitwithsbs.wordpress.com/2009/02/01/re-index-the-wsus-30-database-via-a-gui/

is this post still relevant when the WSUS cleanup wizard  is run, or does this need to be done as well as...

0
 
LVL 39

Accepted Solution

by:
Philip Elder earned 50 total points
ID: 24123485
It is not a factor in the overall performance of your SBS.

If you run the cleanup wizard from within WSUS v3 on a regular basis, you can expect top performance out of WSUS.

Philip
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering 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

Introduction At 19:33 (UST) on Tuesday 21st September the long awaited email arrived with the subject title of “ANNOUNCING THE AVAILABILITY OF WINDOWS SBS 7 PREVIEW”.  It was time to drop whatever I was doing and dedicate as much bandwidth as possi…
Because virtualization becomes more and more common, and, with Microsoft Hyper-V included in Windows Server at no additional costs, and, most server hardware nowadays is more than capable of running a physical Small Business Server (SBS) 2008 or 201…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
This video shows how to use Hyena, from SystemTools Software, to update 100 user accounts from an external text file. View in 1080p for best video quality.

738 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