BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 05-12-2009, 07:15 AM   #1 (permalink)
Thumbs Must Hurt
 
Join Date: Sep 2007
Model: ALL
PIN: N/A
Carrier: Different
Posts: 151
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default SQL Server Desktop Engine

Please Login to Remove!

Hi !

We dont have a seperate SQL Server, we use SQL Server Desktop Engine on the same server where the BES is installed.
Is this solution limited to a maximum number of users ? We have 370 users atm and will have around 700 users in near future.
Offline  
Old 05-12-2009, 07:42 AM   #2 (permalink)
BlackBerry Extraordinaire
 
Join Date: Aug 2008
Location: Basel
Model: 9780
PIN: N/A
Carrier: Swisscom
Posts: 1,579
Post Thanks: 5
Thanked 119 Times in 116 Posts
Default

Not that I am aware of. A new user is just another row in the users table, so there should be no hard limit. But...

For load and redundancy reasons, with 370 users, I would go for a separate SQL box.
Offline  
Old 05-12-2009, 09:23 AM   #3 (permalink)
BlackBerry Elite
 
knottyrope's Avatar
 
Join Date: Jan 2008
Location: Massachusetts
Model: Z30
OS: 10.2.1
PIN: t of blood has been taken
Carrier: AT&T-US with I dee ten tee errors
Posts: 6,722
Post Thanks: 272
Thanked 289 Times in 273 Posts
Default

From what I have heard, MSDE can handle 500 users depending on hardware, after that you really want to go to SQL.
__________________
irony : many old timer posters have de-evolved into the trolls they once fought
I am on http://supportforums.blackberry.com
BES 10 running sweet for my Z30, Z10 and Q10
Online  
Old 05-12-2009, 01:56 PM   #4 (permalink)
Wireless Sith Lord
 
DarthBBerry's Avatar
 
Join Date: Jan 2007
Location: Online
Model: iOS 6
Carrier: Verizon x2
Posts: 1,458
Post Thanks: 2
Thanked 27 Times in 22 Posts
Default

We used to run BESMGMT on the same box at the BES using the MSDE engine. Then we upgraded it to SQL 2005, and now finally off of the BES and on it's own server in it's own instance. You can run it on the same box as the BES, but if it goes *POP*, so goes your entire DB. You're better off running it on a separate box.

Put BES in a VM session and put the SQL engine and DB on the blade server.
Just my opinion....
__________________
DarthBBerry
6-Time BlackBerry World Champion (2007-2012)
BlackBerry® Certified Support Specialist v5.0
BlackBerry® Certified System Administrator v5.0
Offline  
Old 05-12-2009, 07:26 PM   #5 (permalink)
CrackBerry Addict
 
Join Date: Jan 2008
Model: 9700
PIN: N/A
Carrier: Rogers
Posts: 709
Post Thanks: 0
Thanked 8 Times in 8 Posts
Default

But then you run into licensing issues if you run full SQL ;)
Offline  
Old 05-12-2009, 08:51 PM   #6 (permalink)
Thumbs Must Hurt
 
Join Date: Jan 2008
Location: Indonesia
Model: 9700
PIN: N/A
Carrier: Indosat
Posts: 189
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

MSDE capacity is 2 gb
__________________
------------------------------------
http://2blackberry.blogspot.com
Offline  
Old 05-13-2009, 08:12 AM   #7 (permalink)
BlackBerry Elite
 
knottyrope's Avatar
 
Join Date: Jan 2008
Location: Massachusetts
Model: Z30
OS: 10.2.1
PIN: t of blood has been taken
Carrier: AT&T-US with I dee ten tee errors
Posts: 6,722
Post Thanks: 272
Thanked 289 Times in 273 Posts
Default

Quote:
Originally Posted by TargetIT View Post
But then you run into licensing issues if you run full SQL ;)
Knot with per processor license.
__________________
irony : many old timer posters have de-evolved into the trolls they once fought
I am on http://supportforums.blackberry.com
BES 10 running sweet for my Z30, Z10 and Q10
Online  
Old 05-13-2009, 10:36 AM   #8 (permalink)
CrackBerry Addict
 
Join Date: Jan 2008
Model: 9700
PIN: N/A
Carrier: Rogers
Posts: 709
Post Thanks: 0
Thanked 8 Times in 8 Posts
Default

Quote:
Originally Posted by knottyrope View Post
Knot with per processor license.
True - but you go from a $0 investment to a several thousand dollar solution.
Offline  
Old 05-14-2009, 09:20 AM   #9 (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

MDSE is limited to 5 concurrent I/Os at a time. So the more users you have the more likely you are to run into performance issues.

Like Knotty said, once you hit around 500 users you are going to run into trouble. If your BES is on a VM it is even more important that the database be on a SQL server as the I/O from the BES will effect performance on other VMs as well.
__________________
Technical Engineer III

BES was decommissioned. Currently using iPhones with Lotus Notes Traveler 9.0.
Offline  
Old 05-14-2009, 10:59 AM   #10 (permalink)
CrackBerry Addict
 
Join Date: Jan 2008
Model: 9700
PIN: N/A
Carrier: Rogers
Posts: 709
Post Thanks: 0
Thanked 8 Times in 8 Posts
Default

Quote:
Originally Posted by TreeDude View Post
MDSE is limited to 5 concurrent I/Os at a time. So the more users you have the more likely you are to run into performance issues.
Replace that with Express and you don't have that restriction. I've been running SQL2005 Express on te BES server from day 1.
Offline  
Old 05-14-2009, 11:13 AM   #11 (permalink)
Feeling Blue, Bigly ;->
 
stuwhite's Avatar
 
Join Date: Jan 2007
Location: U to the K
Model: 9000
PIN: 3, it's the magic number
Carrier: Most of them, it's a Global Village man!
Posts: 1,273
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by TargetIT View Post
Replace that with Express and you don't have that restriction. I've been running SQL2005 Express on te BES server from day 1.
Yeah I have got around 200 users on each BES and both run SQL Server Express fine. Just make sure you get the latest SP if you install it (SP3 right now).
__________________
I was a BES and Exchange admin once.
Then my world turned Blue.
Offline  
Old 05-14-2009, 11:14 AM   #12 (permalink)
CrackBerry Addict
 
Join Date: Jan 2008
Model: 9700
PIN: N/A
Carrier: Rogers
Posts: 709
Post Thanks: 0
Thanked 8 Times in 8 Posts
Default

Quote:
Originally Posted by stuwhite View Post
Yeah I have got around 200 users on each BES and both run SQL Server Express fine. Just make sure you get the latest SP if you install it (SP3 right now).
I'm still running CTP
Offline  
Old 05-14-2009, 11:17 AM   #13 (permalink)
Feeling Blue, Bigly ;->
 
stuwhite's Avatar
 
Join Date: Jan 2007
Location: U to the K
Model: 9000
PIN: 3, it's the magic number
Carrier: Most of them, it's a Global Village man!
Posts: 1,273
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by TargetIT View Post
I'm still running CTP
Shame on you Target! That's even worse than me running on RTM for ages and ages .
__________________
I was a BES and Exchange admin once.
Then my world turned Blue.
Offline  
Old 05-14-2009, 11:37 AM   #14 (permalink)
CrackBerry Addict
 
Join Date: Jan 2008
Model: 9700
PIN: N/A
Carrier: Rogers
Posts: 709
Post Thanks: 0
Thanked 8 Times in 8 Posts
Default

I just didn't want to chance it and break it :( The first BES Setup we had was a nightmare because it wasn't a dedicated box, so when this actually got up and running (on an old PIII no less), we just left it alone.
Offline  
Old 05-14-2009, 01:03 PM   #15 (permalink)
BlackBerry Elite
 
knottyrope's Avatar
 
Join Date: Jan 2008
Location: Massachusetts
Model: Z30
OS: 10.2.1
PIN: t of blood has been taken
Carrier: AT&T-US with I dee ten tee errors
Posts: 6,722
Post Thanks: 272
Thanked 289 Times in 273 Posts
Default

Quote:
Originally Posted by TargetIT View Post
True - but you go from a $0 investment to a several thousand dollar solution.
CRM project was cancelled from lack of interest from sales group.

I get me a nice 2 quad core 2.8 ghz xeon with 10 15k 73 gig drives. Sales dept ate the cost and I get the goodies.

Funny how only 1% of resources are ever used with BES DB and 4 40 meg DBs.
__________________
irony : many old timer posters have de-evolved into the trolls they once fought
I am on http://supportforums.blackberry.com
BES 10 running sweet for my Z30, Z10 and Q10
Online  
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.