BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 07-06-2008, 06:18 PM   #1 (permalink)
Thumbs Must Hurt
 
Join Date: Oct 2007
Model: 9000
OS: 4.6.0.266
PIN: N/A
Carrier: AT&T
Posts: 59
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default SQL on same server as BES

Please Login to Remove!

We're planning an emergency upgrade of our BES to move it from MSDE to SQL 2005. After adding a new mail store, MAGT 2 refuses to start up after reboots. Probably related to us having more Exchange servers than agents.

Is there a good reason to not put SQL 2005 on the same server as BES? It's not a VM and we'll make sure the hardware specs can handle both.

I saw one forum post recommending against it, but I haven't found any documentation or solid reasons to support it. Any thoughts?
Offline  
Old 07-06-2008, 06:56 PM   #2 (permalink)
CrackBerry Addict
 
vinmontRD's Avatar
 
Join Date: Jul 2007
Location: NJ, USA
Model: 8900
OS: 5.0.0.238
Carrier: T-Mobile
Posts: 726
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by adamli9 View Post
We're planning an emergency upgrade of our BES to move it from MSDE to SQL 2005. After adding a new mail store, MAGT 2 refuses to start up after reboots. Probably related to us having more Exchange servers than agents.

Is there a good reason to not put SQL 2005 on the same server as BES? It's not a VM and we'll make sure the hardware specs can handle both.

I saw one forum post recommending against it, but I haven't found any documentation or solid reasons to support it. Any thoughts?
In general, you'll do better keeping MS SQL on it's own server, unless it development server that doesn't get stressed much. If you're using it for production, and there's any kind of load on it, you'll have more options to optimize performance if it's on its own box. Also- when you start putting multiple production services on the same physical server, you lose the flexibility of restarting one when needed, without having to also take down whatever else is on the box. For example: you may find reasons throughout the year to restart BES, but if SQL 2005 is on the same box, and supporting multiple applications, you will NOT want to have to bring it down every time you restart the machine that BES is installed on.

Also: SQL Server, especially 2005, can multi-thread well if it has access to all the CPU's / cores on your server. If it has to complete with other processes, that's another opportunity for optimization that you pass up.

In general - best practices suggest that such diverse production services should have their own machine.

- Jon
Offline  
Old 07-06-2008, 07:39 PM   #3 (permalink)
Thumbs Must Hurt
 
Join Date: Oct 2007
Model: 9000
OS: 4.6.0.266
PIN: N/A
Carrier: AT&T
Posts: 59
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

That's good info. Our BES will always be on its own physical server, but SQL might be shared if it's on another physical server. It'll ultimately be up to the windows server group, but I'll tell them what you said. Thanks.
Offline  
Old 07-06-2008, 07:50 PM   #4 (permalink)
CrackBerry Addict
 
vinmontRD's Avatar
 
Join Date: Jul 2007
Location: NJ, USA
Model: 8900
OS: 5.0.0.238
Carrier: T-Mobile
Posts: 726
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by adamli9 View Post
That's good info. Our BES will always be on its own physical server, but SQL might be shared if it's on another physical server. It'll ultimately be up to the windows server group, but I'll tell them what you said. Thanks.
OK... while you're passing along suggestion to them - a couple of other considerations that are significant:

Depending on the database and the applications hitting it, SQL Server performance can improve dramatically given more RAM. In general, it makes excellent use of RAM, and can cache indexes in RAM when there's enough space, making lookups (as in queries, joins, etc) dramatically faster.

Other consideration is I/O: SQL performance is heavily dependent on disk I/O, and this is an area that is often ignored. Fast I/O makes a huge difference, and the drive controller configuration is important as well. Multi-threading controllers, large amounts of cache memory on the controller, and minimum contention on the drive/controller all help SQL performance.

Good idea, before all is locked in stone, to get some input from an MS SQL tuning guru re: hardware / network configuration for your server. I've been in IT/technology a LONG time, and been amazed at some of performance hits resulting simply from a lack of proper information at the right point in the decision making process.

Good luck with all of this...

- Jon
Offline  
Old 07-06-2008, 11:07 PM   #5 (permalink)
Thumbs Must Hurt
 
Join Date: Oct 2007
Model: 9000
OS: 4.6.0.266
PIN: N/A
Carrier: AT&T
Posts: 59
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

We've learned about SQL performance the hard way with 12,000 nodes in our Altiris environment. In that situation, we had our SQL db on a SAN with some slow disks. It's since been overhauled, but yeah, disk performance is critical to SQL. Thanks again for the tips. Hopefully we can get the other half of the BES users up tomorrow.
Offline  
Old 07-07-2008, 12:54 AM   #6 (permalink)
New Member
 
Peter_Fitzsimmons's Avatar
 
Join Date: Aug 2007
Location: Australia
Model: 8100
PIN: N/A
Carrier: Optus
Posts: 8
Post Thanks: 0
Thanked 0 Times in 0 Posts
Post Auto Signature Not appearing on email after being set

please dis-regard this reply becasue I meant this to be a new post. My apologises.

Last edited by Peter_Fitzsimmons : 07-07-2008 at 06:04 PM.
Offline  
Old 07-07-2008, 09:33 AM   #7 (permalink)
Thumbs Must Hurt
 
Join Date: Oct 2007
Model: 9000
OS: 4.6.0.266
PIN: N/A
Carrier: AT&T
Posts: 59
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

It turns out that it was directly related to our Exchange environment having issues. We still need to plan that DB upgrade this summer though.. ;)
Offline  
Old 07-07-2008, 06:29 PM   #8 (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 adamli9 View Post
It turns out that it was directly related to our Exchange environment having issues. We still need to plan that DB upgrade this summer though.. ;)
When you do upgrade ... please read this: KB12247 - How to move from an MSDE database to a Microsoft SQL Server database
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.