how to shrink the monitoring database

SBS >> how to shrink the monitoring database

Hi All,

Just wondering if there is a way to shrink or purge the monitoring database.
Mine is over a GB and I see no need for it to be that large.

Appreciate and help.

Mike

Information Technology299

SBS >> how to shrink the monitoring database Hello Mike,

Thank you for posting to the SBS Newsgroup.

I understand your issue is the SBSmonitoring.mdf is too large and you want
to reduce the size of the database. If I have misunderstood your concern,
please let me know.

Please take your time to read through my suggestions and then perform the
steps:

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

Hope it helps! If you have any updates, please feel free to let me know. I
am looking forward to hearing from you!

Best regards,

Brandy Nee

Microsoft CSS Online Newsgroup Support

Get Secure! - www.microsoft.com/security
======================================================
This newsgroup only focuses on SBS technical issues. If you have issues
regarding other Microsoft products, you'd better post in the corresponding
newsgroups so that they can be resolved in an efficient and timely manner.
You can locate the newsgroup here:
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx

When opening a new thread via the web interface, we recommend you check the
"Notify me of replies" box to receive e-mail notifications when there are
any updates in your thread. When responding to posts via your newsreader,
please "Reply to Group" so that others may learn and benefit from your
issue.

Microsoft engineers can only focus on one issue per thread. Although we
provide other information for your reference, we recommend you post
different incidents in different threads to keep the thread clean. In doing
so, it will ensure your issues are resolved in a timely manner.

For urgent issues, you may want to contact Microsoft CSS directly. Please
check http://support.microsoft.com for regional support phone numbers.

Any input or comments in this thread are highly appreciated.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------

>Subject: how to shrink the monitoring database
>Date: Thu, 25 May 2006 07:48:10 -0700
>Lines: 10
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
>X-RFC2646: Format=Flowed; Original
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869

>Newsgroups: microsoft.public.windows.server.sbs
>NNTP-Posting-Host: rollesolutions.com 66.92.0.119
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP05.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.windows.server.sbs:270833
>X-Tomcat-NG: microsoft.public.windows.server.sbs
>
>Hi All,
>
>Just wondering if there is a way to shrink or purge the monitoring
database.
>Mine is over a GB and I see no need for it to be that large.
>
>Appreciate and help.
>
>Mike
>
>
>

SBS >> how to shrink the monitoring database Hi Brandy,
Thanks for the reply. I was hoping for a simpler way to perform the task. Is
there nothing possible with msde?

> Hello Mike,
>
> Thank you for posting to the SBS Newsgroup.
>
> I understand your issue is the SBSmonitoring.mdf is too large and you want
> to reduce the size of the database. If I have misunderstood your concern,
> please let me know.
>
> Please take your time to read through my suggestions and then perform the
> steps:
>
> 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
>
>
> Hope it helps! If you have any updates, please feel free to let me know. I
> am looking forward to hearing from you!
>
> Best regards,
>
> Brandy Nee
>
> Microsoft CSS Online Newsgroup Support
>
> Get Secure! - www.microsoft.com/security
> ======================================================
> This newsgroup only focuses on SBS technical issues. If you have issues
> regarding other Microsoft products, you'd better post in the corresponding
> newsgroups so that they can be resolved in an efficient and timely manner.
> You can locate the newsgroup here:
> http://www.microsoft.com/communities/newsgroups/en-us/default.aspx
>
> When opening a new thread via the web interface, we recommend you check
> the
> "Notify me of replies" box to receive e-mail notifications when there are
> any updates in your thread. When responding to posts via your newsreader,
> please "Reply to Group" so that others may learn and benefit from your
> issue.
>
> Microsoft engineers can only focus on one issue per thread. Although we
> provide other information for your reference, we recommend you post
> different incidents in different threads to keep the thread clean. In
> doing
> so, it will ensure your issues are resolved in a timely manner.
>
> For urgent issues, you may want to contact Microsoft CSS directly. Please
> check http://support.microsoft.com for regional support phone numbers.
>
> Any input or comments in this thread are highly appreciated.
> ======================================================
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
>
>
> --------------------

>>Subject: how to shrink the monitoring database
>>Date: Thu, 25 May 2006 07:48:10 -0700
>>Lines: 10
>>X-Priority: 3
>>X-MSMail-Priority: Normal
>>X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
>>X-RFC2646: Format=Flowed; Original
>>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869

>>Newsgroups: microsoft.public.windows.server.sbs
>>NNTP-Posting-Host: rollesolutions.com 66.92.0.119
>>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP05.phx.gbl
>>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.windows.server.sbs:270833
>>X-Tomcat-NG: microsoft.public.windows.server.sbs
>>
>>Hi All,
>>
>>Just wondering if there is a way to shrink or purge the monitoring
> database.
>>Mine is over a GB and I see no need for it to be that large.
>>
>>Appreciate and help.
>>
>>Mike
>>
>>
>>
>

SBS >> how to shrink the monitoring database Hello Mike,

Thank you for posting back!

In my previous reply I have included four methods to purge the monitoring
database, I understand that my previous reply is long, so please take your
time to read through it.

For your best convenience, I am going to answer your questions,
respectively. Please see:

>> I was hoping for a simpler way to perform the task.

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.

>> Is there nothing possible with msde?

I am sorry but I am not quite sure your concern. 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>)").

Hope it helps! If you have any further questions or concern on this issue,
please feel free to let me know. I am looking forward to hearing from you!

Best regards,

Brandy Nee

Microsoft CSS Online Newsgroup Support

Get Secure! - www.microsoft.com/security
======================================================
This newsgroup only focuses on SBS technical issues. If you have issues
regarding other Microsoft products, you'd better post in the corresponding
newsgroups so that they can be resolved in an efficient and timely manner.
You can locate the newsgroup here:
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx

When opening a new thread via the web interface, we recommend you check the
"Notify me of replies" box to receive e-mail notifications when there are
any updates in your thread. When responding to posts via your newsreader,
please "Reply to Group" so that others may learn and benefit from your
issue.

Microsoft engineers can only focus on one issue per thread. Although we
provide other information for your reference, we recommend you post
different incidents in different threads to keep the thread clean. In doing
so, it will ensure your issues are resolved in a timely manner.

For urgent issues, you may want to contact Microsoft CSS directly. Please
check http://support.microsoft.com for regional support phone numbers.

Any input or comments in this thread are highly appreciated.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------

>Subject: Re: how to shrink the monitoring database
>Date: Thu, 25 May 2006 21:53:44 -0700
>Lines: 144
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869
>X-RFC2646: Format=Flowed; Original

>Newsgroups: microsoft.public.windows.server.sbs
>NNTP-Posting-Host: rollesolutions.com 66.92.0.119
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP03.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.windows.server.sbs:271012
>X-Tomcat-NG: microsoft.public.windows.server.sbs
>
>Hi Brandy,
>Thanks for the reply. I was hoping for a simpler way to perform the task.
Is
>there nothing possible with msde?
>