RE: Allocated Memory Alert on DOMAIN
- From: v-chacez@xxxxxxxxxxxxx (chace zhang)
- Date: Wed, 21 Jun 2006 11:18:53 GMT
Hi,
Thank you for posting here.
From the description, you noticed that the MSDE instance MSSQL$MSFW usedlarge amount of the system memory. If I'm off base, please do let me know.
Generally speaking, the large memory usage is an expected behavior. When we
install the ISA server 2004 with the default installation options, the MSDE
will be installed onto the ISA server and the ISA will be configured to log
the firewall logs to the MSDE database. The ISA server creates separate
MSDE database files for daily logging. With the increment of logging
entries, the MSDE instance will use more and more memory to handle the
databases.
More info:
838241 How to configure logging in ISA Server 2004
http://support.microsoft.com/?id=838241
You may perform the following steps to solve this issue; run the osql
command to limit the maximum memory usage for the MSDE instance. In
addition, the commands can also be used to limit the memory usage of other
MSDE instance. For example, if you think the SharePoint MSDE instance takes
too much memory, you can use these commands to limit the memory usage of
the SharePoint instance.
After performing the research, I found that we could assign the minimum and
maximum memory allocation value by using osql utility. To do that:
1. Open a Command Prompt window.
2. Input the following osql command and press Enter to open the SQL
instance:
osql -E -S <ISA ServerName>\msfw
You will enter the osql console.
3. Follow the commands below:
1> EXEC sp_configure ''show advanced options'', 1
2> reconfigure
3> go
1> EXEC sp_configure ''min server memory'', 0
2> reconfigure
3> go
1> EXEC sp_configure ''max server memory'', 1000
2> reconfigure
3> go
4. After doing the above steps, you may input:
1> EXEC sp_configure
2> go
Then you will see the configuration values for the SQL instance.
5. Restart the MSSQL$MSFW instance from ''Services.msc'' console.
Actually, this is a SQL related task. If you still have any questions
regarding the SQL memory usage, you may need to post the issue to
microsoft.private.directaccess.sqlserver newsgroup. The reason why we
recommend posting appropriately is you will get the most qualified pool of
respondents, and other partners who read the newsgroups regularly can
either share their knowledge or learn from your interaction with us.
For more information, please see the article below:
321363 INF: SQL Server Memory Usage
http://support.microsoft.com/?id=321363
If you have any other questions or concerns, please feel free to let us
know.
Have a nice day!
Best Regards,
Chace Zhang (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.
.
- Prev by Date: Re: SBS 2003 After Service Pack 1 for SBS
- Next by Date: Re: Exchange 2003 out of office settings.
- Previous by thread: Problems with SBS monitoring web site, Part 2
- Next by thread: Re: Trying to get SBS server connect using PPPOE directly using DSL mo
- Index(es):
Relevant Pages
|
