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?

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

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

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

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

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

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

C&A Technology GW-Pro2 SAMSUNG OTP/MTP Gang Programmer
C&A Technology GW-Pro2 SAMSUNG OTP/MTP Gang Programmer picture1pcs Samsung servo motor CSMZ-A5DA1ABM3
1pcs Samsung servo motor CSMZ-A5DA1ABM3 picture1pcs Samsung servo motor CSMQ-02BA1ABM3
1pcs Samsung servo motor CSMQ-02BA1ABM3 picture1pcs Samsung servo drive CSDJ-10BX2
1pcs Samsung servo drive CSDJ-10BX2 picture1pc sansung PLC CPL93103
1pc sansung PLC CPL93103 picture

Copyright 2004-2016
The names RIM and BlackBerry are registered Trademarks of BlackBerry Inc.