Solved

store.exe, memory alerts and slow performance

Posted on 2006-11-17
6
2,054 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
  • 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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

Suggested Solutions

I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
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 to return specific rows and columns, with various degrees of sorting and limits in place.

776 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