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.
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 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 %