Go Premium for a chance to win a PS4. Enter to Win


store.exe, memory alerts and slow performance

Posted on 2006-11-17
Medium Priority
Last Modified: 2008-01-09
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 %      

Question by:Jweaver57
  • 2
  • 2

Expert Comment

ID: 17970983
--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....


Author Comment

ID: 17989256
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.


Accepted Solution

badbearontour earned 2000 total points
ID: 18017962

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.


Author Comment

ID: 18019319

Thanks for trying.  At least you pointed me in another direction.  

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

927 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question