BlackBerry Forums Support Community

Noonien · 05-12-2009, 07:15 AM

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.

freakinvibe · 05-12-2009, 07:42 AM

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.

knottyrope · 05-12-2009, 09:23 AM

From what I have heard, MSDE can handle 500 users depending on hardware, after that you really want to go to SQL.

DarthBBerry · 05-12-2009, 01:56 PM

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

TargetIT · 05-12-2009, 07:26 PM

But then you run into licensing issues if you run full SQL ;)

buluks · 05-12-2009, 08:51 PM

MSDE capacity is 2 gb

knottyrope · 05-13-2009, 08:12 AM

Quote:

Originally Posted by TargetIT

But then you run into licensing issues if you run full SQL ;)

Knot with per processor license.

TargetIT · 05-13-2009, 10:36 AM

Quote:

Originally Posted by knottyrope

Knot with per processor license.

True - but you go from a $0 investment to a several thousand dollar solution.

TreeDude · 05-14-2009, 09:20 AM

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.

TargetIT · 05-14-2009, 10:59 AM

Quote:

Originally Posted by TreeDude

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.

stuwhite · 05-14-2009, 11:13 AM

Quote:

Originally Posted by TargetIT

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

TargetIT · 05-14-2009, 11:14 AM

Quote:

Originally Posted by stuwhite

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

stuwhite · 05-14-2009, 11:17 AM

Quote:

Originally Posted by TargetIT

I'm still running CTP

Shame on you Target! That's even worse than me running on RTM for ages and ages

.

TargetIT · 05-14-2009, 11:37 AM

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.

knottyrope · 05-14-2009, 01:03 PM

Quote:

Originally Posted by TargetIT

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.