BES Server and other application servers

Question

BES Server and other application servers

CGSJohnson

SSCertifiable

Points: 7208
More actions
May 23, 2007 at 3:01 pm

#68420

Good morning. Has anyone noticed how many connections the BES server has to the BES database? Is there anything that can be done to close some of these connections? I've noticed this problem with Great Plains, as well. It opens a ton of connections to the various databases. Any comments or help is appreciated. Thanks.
Chris

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

Linda Johanning SSCertifiable Points: 6727 More actions · Answer 1

I don't know why you would want to close any of the connections--are they causing any problems? I see connections from the various BES services or applications for synchronization, messaging, mobile data, etc. but they look normal to me. If you have lots of connections with workstation IDs instead of the server, then you might just have a lot of people with Blackberry Manager. Maybe those are the ones you should look at 🙂

CGSJohnson SSCertifiable Points: 7208 More actions · Answer 2

Thanks, Linda. I guess I was just wondering if they were all necessary since they all seem to be "sleeping". Thanks for the reply.

Rudyx - the Doctor SSC-Forever Points: 43695 More actions · Answer 3

I have this problem with our BES from time to time (and a few other applications as well. Many connections, no CPU and no memory allocated just hanging around. Our BES has 40 users and sometimes the BES connections rises into triple digits ! Here is a quick'n'dirty script ro add as a task to execute every 30 minutes to clean up those 'do nothing' spids (kill 'em discriminately):

exec sp_execresultset ' select ''kill '' + convert(char(4),spid)

--, convert(char(16),user_name(uid))

--, convert(char(16),db_name(dbid))

--, last_batch

from sysprocesses

where nt_username = ''sv-BESA''

-- where loginame = ''BESA''

and convert(char(20),last_batch,120) = convert(char(20),login_time,120)

and physical_io = 0

and memusage = 0

order by last_batch'

NOTE: all of the quotes in the code are single quotes

RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

CGSJohnson SSCertifiable Points: 7208 More actions · Answer 4

Thanks, Rudy. I just can't believe that many of these popular applications misuse databases like they do. I guess that just means that there will always be jobs for us, huh?!

Chris

Rudyx - the Doctor SSC-Forever Points: 43695 More actions · Answer 5

Here are a few other applications that have this same issue "big time":

MOM 2005
Orion Network Minortoring
Pathways Compliance Advisor from McKesson

Be wary of 3 tier applciations that utilize connection pooling. Incorrectly set connection pooling parameters coupled with bad code will also cause you a connection nightmare.

As for the offenders list of applications, I've found out the more developer 'friendly' that they make SQL Server, or other DBMS systems like UDB2, Sybase and Oracle, the more secure our futures as DBAs become !

RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."