Solved

store.exe, memory alerts and slow performance

Posted on 2006-11-17
6
2,061 Views
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 %      
 
 



0
Comment
Question by:Jweaver57
[X]
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
6 Comments
 
LVL 7

Expert Comment

by:badbearontour
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....

0
 

Author Comment

by:Jweaver57
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.

0
 
LVL 7

Accepted Solution

by:
badbearontour earned 500 total points
ID: 18017962
Hi,

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.



0
 

Author Comment

by:Jweaver57
ID: 18019319
badbearontour

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

Featured Post

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

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

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
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…
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

623 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