• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2072
  • Last Modified:

store.exe, memory alerts and slow performance

What do I do here?  We are experiencing very slow performance with Franklin Estimator that uses MSDE database.  Franklin support said that we needed more memory so we increased from 1gig to 2gig and that seemed to resolve the problem for a week or two, but now the problem is back.  Is this an Exchange problem or SQL problem, or a combination.  We are running SBS 2003 SP1 and Exchange SP2 with two processors.  Below is the alert we are getting.  Of course restarting store.exe and sql helps but only temporarily.  What can I do to resolve permanently?  

Alert on SERVER1 at 11/16/2006 6:21:10 PM

A large amount of memory is committed to applications and processes. Consistently high memory usage can cause performance problems.

To determine which processes and applications are using the most memory, use Task Manager. Monitor the activity of these resources over a few days. If they continue to use a high level of memory and are less critical processes or services, try stopping and then restarting them.

You can disable this alert or change its threshold by using the Change Alert Notifications task in the Server Management Monitoring and Reporting taskpad.

Server Specifications
Operating System: Microsoft(R) Windows(R) Server 2003 for Small Business Server Service Pack 1
Processor: Intel(R) Xeon(TM) CPU 3.06GHz, Intel(R) Xeon(TM) CPU 3.06GHz, Intel(R) Xeon(TM) CPU 3.06GHz, Intel(R) Xeon(TM) CPU 3.06GHz
Frequency: 2.3 GHz, 2.3 GHz, 2.3 GHz, 2.3 GHz
Amount of RAM: 2048 MB

Performance Summary
Performance Counters Today Last Month Rate of Growth
Memory in use 2,112 MB  1,160 MB 82 %
Free disk space (C:) 53,751 MB  55,445 MB -3 %
Free disk space (D:) 63,388 MB  67,108 MB -6 %
Busy disk time (0 C:) 3 %  2 % 22 %
Busy disk time (1 D:) 8 %  9 % -12 %
CPU Use (0) 2 %  2 % 36 %
CPU Use (1) 2 %  1 % 26 %
CPU Use (2) 2 %  2 % 40 %
CPU Use (3) 2 %  1 % 61 %

Top 5 Processes by Memory Usage
Process Name - ID Memory Usage
store - 9544 551 MB      
sqlservr - 1592 497 MB      
SMEX_Master - 2136 76 MB      
sqlservr - 1660 73 MB      
QBDBMgrN - 572 64 MB      
Top 5 Processes by CPU Usage
Process Name - ID CPU Time
svchost - 1356 1.8 %      
wmiprvse - 4448 0.9 %      
SMEX_SystemWatcher - 2176 0.6 %      
services - 744 0.5 %      
sqlservr - 1660 0.5 %      

  • 2
  • 2
1 Solution
--Franklin Estimator that uses MSDE database.--

MSDE? are you not using the SQL server software that comes with your SBS software as opposed to desktop engine?

Are all of these packages the ones that ship with SBS?? or are they some that you have installed from somewhere else?

with a bit more information we can help you....

Jweaver57Author Commented:
Its Sbs standard so sql didn't come with it.  The Frnklin software installed the MSDE but as of yesterday my client upgraded to a newer version of Franklin with sql express and it still takes almost ten minutes to open an estimate.  They then uploaded the database to Franklin support and ran it on their server and it opened estimates with no delay.  That makes it sound like its the server.  Maybe they have problems running on SBS.


Sorry for the delay I honestly thought I had replied to this one...

I'm not sure that this will be solved here in the SQL topic, it looks like exchange is more of the issue to me.. You can set the amount of memory to be used by sql server, but I'm not sure if you can do that in exchange... it may be worth posting a question in the exchange forum to see if you can limit the amount of hard memory exchange gobbles up.... This used to be a common problem in the days of NT based SBS server, even with the 2 products 'designed to be on the same server' although Microsoft at the time never recommended that you have both on the same server, THe exchange software will take everything it can get its claws on in the way of system resources and I dont think the new versions are any different.... I'd ask the exchange bods if you can limit exchange in some way to give the sql some room to work. if it is possible then its a balancing act to find a set of parameter that will give reasonable resources to both software systems....

Sorry I can;t be more helpful with this one.

Jweaver57Author Commented:

Thanks for trying.  At least you pointed me in another direction.  
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now