RE: Increase in Memory Usage

Hi Kevin,

Thanks for your reply.

I am not share which database you backup in D:\Data\SQL\MSSQL\BACKUP.

In Microsoft SQL Management Studio, you can backup the database of SBS
instance on disk. By default, there are stored in

C:\Program Files\Microsoft SQL Server\MSSQL$InstanceName\backup folder.

If you ensure the files D:\Data\SQL\MSSQL\BACKUP are backup file of SBS
instance, you can move the file to other storage media such as USB disk.

I'd like to give you additional information on how to increase the disk
size:

For the monitoring database:

If you are running SBS Standard, you'd 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>)").

Meanwhile, you can purge SBSmonitoring.mdf data if you want. To purge the
SBSmonitoring.mdf data, we need to reconfigure the Monitoring and Reporting
wizard.


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.

You can also delete the unneeded WSUS patches on SBS server. If I am
off-base: To do this:

Step 1: Run wsusutil deleteunneededrevisions to make database cleanup

Step 2: Download the Server Diagnostic Tool (WSUS Server Debug Tool.EXE
<http://download.microsoft.com/download/7/7/4/7745a34e-f563-443b-b4f8-3a289e
995255/WSUS%25>) from
<http://www.microsoft.com/windowsserversystem/updateservices/downloads/defau
lt.mspx>

Step 3: Extract the WsusDebugTool.exe to your computer From a command
prompt type:

WsusDebugTool.exe /Tool:PurgeUnneededFiles

For more information, please refer to:

WSUS Server Administration Issues
http://technet2.microsoft.com/windowsserver/en/library/2bb761d4-80c7-48fa-89
9e-4d1515daba851033.mspx?mfr=true

Hope the information helps.

If you need further assistance, please don¡¯t hesitate to let me know.

Best regards,

Robert Li(MSFT)

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.

--------------------
<Thread-Topic: Increase in Memory Usage
<thread-index: AcfqdPKUVyiDtW1SRn+XpP3Ls3xbCw==
<X-WBNR-Posting-Host: 207.46.192.207
<From: =?Utf-8?B?S2V2aW4gR2Fs?= <KevinGal@xxxxxxxxxxxxxxxxxxxxxxxxx>
<References: <555D29B3-1060-461E-BC1A-BAA2A3FEDD64@xxxxxxxxxxxxx>
<yXgq1sj2HHA.5204@xxxxxxxxxxxxxxxxxxxxxx>
<Subject: RE: Increase in Memory Usage
<Date: Wed, 29 Aug 2007 12:44:01 -0700
<Lines: 127
<Message-ID: <4CEE4F8C-CAB0-4EAD-8668-6E683233DBAA@xxxxxxxxxxxxx>
<MIME-Version: 1.0
<Content-Type: text/plain;
< charset="Utf-8"
<Content-Transfer-Encoding: 7bit
<X-Newsreader: Microsoft CDO for Windows 2000
<Content-Class: urn:content-classes:message
<Importance: normal
<Priority: normal
<X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2826
<Newsgroups: microsoft.public.windows.server.sbs
<Path: TK2MSFTNGHUB02.phx.gbl
<Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.windows.server.sbs:59558
<NNTP-Posting-Host: tk2msftsbfm01.phx.gbl 10.40.244.148
<X-Tomcat-NG: microsoft.public.windows.server.sbs
<
<Hi... Sorry for the delay,
<
<The biggest file is under D:\Data\SQL\MSSQL\BACKUP it is taking up about
80G.
<
<PS I am talking about hard drive space...Thanks Kevin
<
<The
<
<"Robert Li [MSFT]" wrote:
<
<> Hi Kevin,
<>
<> Thanks for posting in our newsgroup and also for Larry's input.
<>
<> Before we go further on this subject, please let me know the following
to
<> make the situation more clearly:
<>
<> 1. Do you have problem on Memory or Disk usage?
<> 2. What important change did you make before the problem first
reoccurred?
<>
<> Based on research, to find out which makes the disk usage increasing, we
<> need to monitor the size of folder in this disk. This is really tough
<> because there are so many folders there. But there is no other tool to
do
<> this automatically.
<>
<> There are many folders in disk, for example:
<>
<> C:\Users Shared Folders
<> C:\WSUS
<> C:\Document and settings
<>
<> Please write down the size of each folder, after several hours,
comparing
<> the older size with the new one, you can identify which folder grows
<> faster. Then do the same thing on the subfolders
<> If you find out the problematic folder, please check which application
<> handles this folders and then change the application setting.
<>
<> Also, please try the following:
<>
<> Step 1: If you user SBS Folder redirection, please check if the some
users
<> save big files to My Documents. By default the users have disk quota of
<> 1024 M.
<>
<> Step 2: Please take the following steps to free disk space.
<>
<> To free up some disk space, you may click Start, point to Programs,
point
<> to Accessories, point to System Tools, and then click Disk Cleanup,
click
<> OK and then follow the wizard.
<>
<> More info:
<>
<> Moving Data Folders for Windows Small Business Server 2003
<>
http://download.microsoft.com/download/1/1/6/11671e4d-fb21-489c-870f-db36fd2
<> 1a7d2/SBS_MoveDataFolders.DOC
<>
<> Help this helps.
<>
<> If you need further assistance, please don't hesitate to let me know.
<>
<> Best regards,
<>
<> Robert Li(MSFT)
<>
<> 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.
<>
<> --------------------
<> <Thread-Topic: Increase in Memory Usage
<> <thread-index: AcfZ4b/1g8qZEecVRZaYbZAdQEEzlA==
<> <X-WBNR-Posting-Host: 207.46.19.197
<> <From: =?Utf-8?B?S2V2aW4gR2Fs?= <KevinGal@xxxxxxxxxxxxxxxxxxxxxxxxx>
<> <Subject: Increase in Memory Usage
<> <Date: Wed, 8 Aug 2007 10:30:01 -0700
<> <Lines: 4
<> <Message-ID: <555D29B3-1060-461E-BC1A-BAA2A3FEDD64@xxxxxxxxxxxxx>
<> <MIME-Version: 1.0
<> <Content-Type: text/plain;
<> < charset="Utf-8"
<> <Content-Transfer-Encoding: 7bit
<> <X-Newsreader: Microsoft CDO for Windows 2000
<> <Content-Class: urn:content-classes:message
<> <Importance: normal
<> <Priority: normal
<> <X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2826
<> <Newsgroups: microsoft.public.windows.server.sbs
<> <Path: TK2MSFTNGHUB02.phx.gbl
<> <Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.windows.server.sbs:55275
<> <NNTP-Posting-Host: tk2msftsbfm01.phx.gbl 10.40.244.148
<> <X-Tomcat-NG: microsoft.public.windows.server.sbs
<> <
<> <I have notice a large increase in the size of the data used on our
SBS2003
<> <SP2 Prem (not using ISA). It has increased by over 30% in the past
<> month...
<> <What is the easiet way to find out what is taking up the space and fix
<> <it...It seems to me that the back up is the problem; thanks kevin
<> <
<>
<>
<

.

Loading