BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 07-01-2008, 12:11 PM   #1 (permalink)
Thumbs Must Hurt
 
Join Date: Apr 2006
Model: 8350i
Carrier: Nextel
Posts: 194
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default SBS Server perf report showing high memory use

Please Login to Remove!

After installing Pro 4.1.4 and configuring it for 1 user I began to get critical alerts in my daily server performance report. The BES software is installed on my single BES server which also houses exchange.

The critical alert is as follows:

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.

Looking at the memory usage for the server it's showing sqlservr is using 742 megs of memory and appears to be growing. That is definetly much higher than it was before I installed BES.

I also think it's growing each day. Remember, I only have 1 user on BES.

Is there something I should check or change, or stop and restart?

Thanks,

Roveer
Offline  
Old 07-01-2008, 12:17 PM   #2 (permalink)
BlackBerry Genius
 
hdawg's Avatar
 
Join Date: Aug 2006
Model: hdawg
PIN: port3101.org
Carrier: hdawg
Posts: 6,632
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

How much memory was it using before? SQL using 742meg isn't anything to worry about.

I guess just make sure the server is patched properly.
Offline  
Old 07-02-2008, 04:38 PM   #3 (permalink)
Thumbs Must Hurt
 
Join Date: Apr 2006
Model: 8350i
Carrier: Nextel
Posts: 194
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

It was using anywhere between 91-250 megs for the sql process. That's almost 2/3rds less than it's using now. I rebooted the server to see if it grabs that much memory again. Strange thing is, it was running with BES at 91-250 megs for a few days then suddenly jumped up over 700. Let's see what happens after the roboot. I'll keep an eye on it this time.

Roveer
Offline  
Old 07-02-2008, 07:10 PM   #4 (permalink)
BlackBerry Genius
 
hdawg's Avatar
 
Join Date: Aug 2006
Model: hdawg
PIN: port3101.org
Carrier: hdawg
Posts: 6,632
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Perhaps look through the SQL logs ... or enable performance monitor logging and see when the increase in RAM occurs. It could happen during backups or other maintenance.
Offline  
Old 07-03-2008, 10:44 AM   #5 (permalink)
Thumbs Must Hurt
 
Join Date: Apr 2006
Model: 8350i
Carrier: Nextel
Posts: 194
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Well the server reboot seems to have backfired. I looked at my performance report this morning and sql is now using 971 megs of memory. This is 25% of the servers total memory.

I just looked at my taskmgr and it's showing the sql server at 208mb so I'm guessing something is causing it to spike up when the performance data is gathered. I'll take a look at the schedules & logs and see whats happening.

Roveer
Offline  
Old 07-07-2008, 12:36 PM   #6 (permalink)
Thumbs Must Hurt
 
Join Date: Apr 2006
Model: 8350i
Carrier: Nextel
Posts: 194
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Might have been looking at the wrong instance of SQL server. For that matter I can't tell which instance of SQLSERVER belongs to which process.

When looking in taskmgr I see 3 instances of sqlserver one at 50 megs, one at 45 megs and one at 945 megs. Before I go and blame BES I think I better figure out which one is which. Any ideas how I can do this? Of course I never received these messages in my daily performance report until I installed BES so It is seeming like the culprit but I have to know that.

Roveer
Offline  
Old 07-07-2008, 02:53 PM   #7 (permalink)
Thumbs Must Hurt
 
Join Date: Apr 2006
Model: 8350i
Carrier: Nextel
Posts: 194
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Not BES!!!

Turns out it was the SBS$MONITORING instance of SQLServr and a quick post to the SBS news group yielded this description and fix:

Allocated Memory Alert Revisited - THE OFFICIAL BLOG OF THE SBS "DIVA"

Made the changes and memory usage dropped from the 800+mb range to 117mb for that service.

Roveer
Offline  
Old 07-07-2008, 05:56 PM   #8 (permalink)
BlackBerry Genius
 
hdawg's Avatar
 
Join Date: Aug 2006
Model: hdawg
PIN: port3101.org
Carrier: hdawg
Posts: 6,632
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

... Love Susan Bradley. Thanks for the follow-up and link!
Offline  
Closed Thread


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On





Copyright 2004-2014 BlackBerryForums.com.
The names RIM and BlackBerry are registered Trademarks of BlackBerry Inc.