BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 06-26-2008, 05:01 PM   #1 (permalink)
Thumbs Must Hurt
 
jeffro01's Avatar
 
Join Date: Oct 2006
Location: 67235
Model: 9700
OS: 5.0.0.423
PIN: 2277C472
Carrier: At&t (Company)
Posts: 173
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default SQL Performance

Please Login to Remove!

I currently am running BPS with an MSDE SQL database in a virtual environment on the same virtual server. Everything is going great but I only have 2 users on the BES at this time so there aren't any concerns now. However, I am going to be adding more users and would like to know of any suggestions or ideas on how I can keep tabs of my SQL performance to make sure that I don't overwhelm the VM.

Thanks
Jeff
Offline  
Old 06-26-2008, 08:30 PM   #2 (permalink)
BlackBerry Genius
 
hdawg's Avatar
 
Join Date: Aug 2006
Model: hdawg
PIN: port3101.org
Carrier: hdawg
Posts: 6,631
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by jeffro01 View Post
I currently am running BPS with an MSDE SQL database in a virtual environment on the same virtual server. Everything is going great but I only have 2 users on the BES at this time so there aren't any concerns now. However, I am going to be adding more users and would like to know of any suggestions or ideas on how I can keep tabs of my SQL performance to make sure that I don't overwhelm the VM.

Thanks
Jeff
How many users are you going to be adding?
Are you adding additional virtual servers?
What sort of resources do you have dedicated to the SQL vm?
What Virtual Server software are you using?
Offline  
Old 06-27-2008, 10:03 AM   #3 (permalink)
Talking BlackBerry Encyclopedia
 
TreeDude's Avatar
 
Join Date: Apr 2008
Location: Western NY, USA
Model: iPn4S
OS: iOS 7.0.1
PIN: 76E5A626
Carrier: Verizon
Posts: 243
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Well BPS max is 30 users. With only 30 users I don't think you will have an issue. I had mine with a local SQL database initially and it seemed fine (it was virtual). I did not run it that long though. The only reason we made the database remote was for consistency. We wanted anything with an SQL database to be on one of our SQL servers for easy back up.

I think you will be ok. Keep in mind I use Lotus Domino though, I do not have any experience with exchange.
__________________
Technical Engineer III

BES was decommissioned. Currently using iPhones with Lotus Notes Traveler 9.0.
Offline  
Old 06-27-2008, 01:46 PM   #4 (permalink)
Thumbs Must Hurt
 
jeffro01's Avatar
 
Join Date: Oct 2006
Location: 67235
Model: 9700
OS: 5.0.0.423
PIN: 2277C472
Carrier: At&t (Company)
Posts: 173
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by hdawg View Post
How many users are you going to be adding?
Are you adding additional virtual servers?
What sort of resources do you have dedicated to the SQL vm?
What Virtual Server software are you using?
1. Right now only up to 12 total
2. Not at this time due to overall performance limitations of the hardware
3. The sole VM being MSDE and BPS has 2GB of ram running on 2 single core Xeon processors (its a dual CPU system although only a total of 2 cores) running at 3.2GHz per processor.
4. VMWare Server which is running on top of Server 2003 R2 SP2, the guest OS also has 2GB ram and shares the CPUs with the BES, and both OSs share the data RAID which is a RAID 1 across 2 drives. There is also another RAID 1 in this system and I am thinking of moving the BPS\SQL VM to that RAID to seperate the 2 OSs somewhat.

Thoughts on all of this?

Thanks
Jeff
Offline  
Old 06-27-2008, 02:08 PM   #5 (permalink)
Talking BlackBerry Encyclopedia
 
Join Date: Oct 2007
Model: 8830
PIN: N/A
Carrier: Sprint, Alltel
Posts: 262
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Does your host only have 2 cpus? If so, I would recommend that you do not give the VM session 2 cpus. It might not be a problem if that is the only VM you will run on the host and the host isn't doing anything else.

As I understand it, VMWare Server requires a lock on the number of processors you assign it - so, if you assign it 2, it needs to lock 2 processors and so on. So, if your VM server is always waiting on getting 2 processors, you could see an adverse effect on performance.

We have seen performance problems on some of our servers we have running in VMWare Server with more than 1 processor and multiple VMs on the host.
Offline  
Old 06-27-2008, 02:15 PM   #6 (permalink)
Thumbs Must Hurt
 
jeffro01's Avatar
 
Join Date: Oct 2006
Location: 67235
Model: 9700
OS: 5.0.0.423
PIN: 2277C472
Carrier: At&t (Company)
Posts: 173
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Yeah the host OS and guest VM share the 2 cpus, the host other then running the VMWare software functions as a print server so the load is not heavy on the host OS.

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