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
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

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

Question has a verified solution.

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

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

718 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