BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 12-14-2006, 09:00 AM   #1 (permalink)
Thumbs Must Hurt
 
only1eagle's Avatar
 
Join Date: Nov 2005
Model: 7290
Carrier: T-mobile
Posts: 113
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default Benefit of using SQL over MSDE?

Please Login to Remove!

Small company with only 39 users on the BES. I will be upgrading/building new server in the new year and was wondering what the benefit would be to use SQL over MSDE?

thanks
Offline  
Old 12-14-2006, 10:00 AM   #2 (permalink)
Knows Where the Search Button Is
 
Join Date: Nov 2006
Model: 8100
Carrier: Tmobile
Posts: 15
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

With 39 user, MSDE should be fine. When you grow to about 150 users you will noticed a speed difference. Like opening Blackberry manager. When it slows to a crawl you reboot the bes with the posibility of corrupting the msde database.
Offline  
Old 12-14-2006, 11:39 AM   #3 (permalink)
CrackBerry Addict
 
bertiebassett's Avatar
 
Join Date: Aug 2005
Location: London, UK
Model: 9700
Carrier: O2
Posts: 961
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Personally I'd stick with MSDE unless you're already a SQL server shop as the licenses cost $$$$ the advantages of SQL are really around speed as HMAN posted, but also around 'large scale' deploymnet, ease of backup etc etc. Having one central DB on a separate server and a couple of BES is handier when doing upgrades or for DR but for 39 users I'd stick with MSDE unless really mission critical...
__________________
LOTS of answers here: Main Page - BlackBerryFAQ
Offline  
Old 12-14-2006, 11:55 AM   #4 (permalink)
Thumbs Must Hurt
 
Join Date: Apr 2005
Location: Montreal
Model: 8300
Carrier: Telus/Bell/Rogers
Posts: 59
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi... We made the change from MSDE to SQL about a year ago.. At that time we had about 60-70 users.. Let's say that for the reboot/recover time.. it was night and day. SQL is much more faster and didnt gived us any trouble.. With MSDE we had some issue.
Offline  
Old 12-14-2006, 12:24 PM   #5 (permalink)
Thumbs Must Hurt
 
Join Date: Aug 2006
Model: 8100
Carrier: T-Mobile
Posts: 111
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

I would recommend looking at a 1-year plan at least for your company. How many users do you expect to have in 1 year? I dont know your company... maybe you have 500 employees, maybe you have 45. If you had 45, stick with MSDE. If you have a lot that could potentially get a BB in the next year... do yourself a favor and do it now, that way you save a lot of potential problems moving later. I run a few BES's w/ 1K+ users.. SQL2005 is nice
__________________
"I take off my robe and wizard hat...."
Offline  
Old 12-14-2006, 01:30 PM   #6 (permalink)
CrackBerry Addict
 
qc_metal's Avatar
 
Join Date: Mar 2005
Location: Rockford, IL
Model: 9530
OS: 4.7.x
Carrier: Verizon
Posts: 590
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Really the MSDE limitation comes down to:
  • simultaneous connections to the database at once
  • 2Gb size limitation on the database (4Gb for WMSDE and SQL Express)
  • MSDE can take advantage of only 2Gb of RAM
  • MSDE can take advantage of 2 processors

We actually had all 320 our users on MSDE before our conversion to Notes and moved to SQL - no one experienced any troubles with item delivery (or delivery time), but we weren't heavy attachment users, either.

The more features you use, i.e. the more items that the BES has to translate on its end, the more it will impact performance, so SQL is better in cases like this.

I would monitor your CPU and memory performance of your MSDE server to see how it does during a few normal workdays. My gut feeling (since I don't know the stats of your server) is that most likely, if your box is somewhat respectable, it should do just fine.
__________________
Provision, maintain, and report on users via web: the NEW BerryStats | FAQ

Last edited by qc_metal : 12-14-2006 at 07:48 PM.
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.