Kazmarek

Free Site Analysis 1-858-952-5400
REMOTE ASSISTANCE
  • Home
  • OnGoing Management
  • IT Services
    • Microsoft 365, Exchange Services, and Consulting
    • Cloud Solutions
    • Virtualization
    • Mobility
    • Backup & Disaster Recovery
    • Server Installation/Migration
    • VoIP
    • Network & System Administration
    • Additional Solutions
  • Why Kazmarek
    • Case Studies
    • Testimonials
    • KTS Values
  • For Clients
    • O365 Log In
    • Client Portal
    • KTS Documents
    • SonicWALL VPN Client
  • News
    • Newsletters
  • Who We Are
    • Company
    • Team
    • KTS E-Award Winners
    • KTS Values
    • Charities We Support
  • Contact Us
    • Contact Us
    • Careers

Shrinking the SBSmonitoring database

July 20, 2007 by Tayla Dodson

http://msmvps.com/blogs/bradley/archive/2006/05/25/97044.aspx

First the caveat.. the SBSmonitoring database shouldn’t be that big.. if it is …. your monitoring program isn’t running properly and purging the database as it should so rerunning the monitoring wizard is probably the best plan of action… but if you need to clean up that monitoring file… here’s some info from the newsgroups…

1>	We can simple rerun the Monitoring wizard to purge the
SBSmonitoring.mdf database.

NOTE: After doing the following steps, the original performance and usage
data will be removed. The server will start to collect new counter value
from the beginning.

1. Open Server Management console, navigate to 'Monitoring and Reporting'
snap-in. In the right panel, click 'Set Up Monitoring Reports and Alerts'.

2. In the wizard, click 'Next'->Select 'Reinstall monitoring
features'->Select the options if you want to receive the report e-mails.
Check 'View the usage report in Server Management' option. If you want to
receive the usage report e-mail, also check the option below->Add the users
which you allow them to view the usage report to the authorized
list->Select the option if you want to receive the performance
alerts->Click 'Finish' button to complete the configurations.

3. After doing the above steps, the performance and usage data will be
reset. Please wait for 24 hours and then you will see the reports through
the Monitoring and Reporting console.

2>	If you are using SBS Premium and have SQL server installed:

You can use the SQL Client Utilities to try and shrink the database. In
SBS, there is a job SBS_Database_Cleanup that is scheduled to run at 3:00
AM everyday, to delete over 90 day old information from the monitoring
database.

You can manually run the SBS_Database_Cleanup job, and use DBCC
SHRINKDATABASE, DBCC SHRINKFILE or use Enterprise Manager
to reduce the size of the database.

3>	If you are running SBS Standard:

You need to use osql to connect to the WMSDE instance, and use transact SQL
commands manually to request the database be shrunk ("dbcc shrinkdatabase(
SBSMonitoring, <% free space target>)").

4>	If you need more space on your C drive, I would also suggest moving
available data from your C drive to other partition on your Server. The
following white paper demonstrates this scenario in detail.

Please refer to Step 5: Move the Monitoring Database in the following white
paper.
Moving Data Folders for Windows Small Business Server 2003
http://www.microsoft.com/technet/prodtechnol/sbs/2003/maintain/movedata.mspx

Categories

  • Active Directory
  • Backup Exec (All Versions)
  • Blackberry / Blackberry Enterprise Server
  • Citrix
  • Cool Tech Stuff
  • CRM
  • Dell
  • Exchange 2007
  • Exchange 2010
  • Exchange 2013
  • Exchange Hosted
  • Exchange Server
  • Group Policy
  • IIS
  • Kaseya
  • kazmarek
  • MacOS
  • Microsoft
  • Networking
  • newsletter
  • Office
  • Office 365
  • Office Communications Server
  • OfficeScan
  • Outlook
  • Printing
  • SBS 2003
  • SBS 2008
  • SBS 2011
  • Server 2003
  • Sharepoint
  • Spyware
  • SQL
  • Symantec
  • Terminal Server
  • Thawte
  • Trend Micro
  • Uncategorized
  • Virtual Server
  • Websense
  • Windows 7
  • Windows Mobile
  • Windows Server 2008
  • Windows Server 2012
  • Windows Vista
  • Windows XP Pro/Home
Copyrights: © 2023 Kazmarek. All rights reserved.

Designed by TinyFrog & N Halie Designs