BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 09-06-2009, 09:50 PM   #1 (permalink)
BlackBerry Extraordinaire
 
noname's Avatar
 
Join Date: Sep 2005
Location: Congested Islet of "Foreign Talents" (> 45% of workforce) - Singapore.
Model: Z10
OS: 10.0.0
PIN: NUKE(PAP)
Carrier: Singtel
Posts: 1,504
Post Thanks: 6
Thanked 9 Times in 9 Posts
Question QQ - Usefulness of the Database Notification System

Please Login to Remove!

Hi all,

Contemplating installing DBNS, just wanna gather experience for those who have installed it. Does it really works as it claims?

<SNIP>
The Database Notification System is designed to reduce the number of database queries made by the BlackBerry Enterprise Server to the BlackBerry Configuration Database. If running BlackBerry Enterprise Server version 4.1with a remote SQL server, install manually the Database Notification Systemby completing the following procedure:

1. Extract the BlackBerry Enterprise Server installation software to a temporary location.
2. Copy the RimEsp.dll file to C:\Program Files\Microsoft SQL Server\MSSQL\Binn.
3. In SQL Query Analyzer, browse to the \Database\DBInstallScripts\SQLServer\4.1 folder of the extracted installation software from Step 1.
4. Open the NotifyInstall.sql file and replace <_DATABASENAME_> with the name of your BlackBerry Configuration Database.
5. Run the script.
6. Confirm the Query Analyzer displays the message "Function dbo.xp_RIM_xxxx registered".
</SNIP>
__________________
Native but 4th class citizen of a nation governed by idiots who import congestions & contention.
Offline  
Old 09-08-2009, 08:31 PM   #2 (permalink)
BlackBerry Genius
 
hdawg's Avatar
 
Join Date: Aug 2006
Model: hdawg
PIN: port3101.org
Carrier: hdawg
Posts: 6,632
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

don't use it ... more trouble than it is worth. At WES in 2008 I was in a session where RIM's architecture at the time was explained and they didn't use DBNS then.
Offline  
Old 09-10-2009, 01:57 AM   #3 (permalink)
BlackBerry Extraordinaire
 
noname's Avatar
 
Join Date: Sep 2005
Location: Congested Islet of "Foreign Talents" (> 45% of workforce) - Singapore.
Model: Z10
OS: 10.0.0
PIN: NUKE(PAP)
Carrier: Singtel
Posts: 1,504
Post Thanks: 6
Thanked 9 Times in 9 Posts
Default

Thanks, hdawg! How does it supposed to work technically?
__________________
Native but 4th class citizen of a nation governed by idiots who import congestions & contention.
Offline  
Old 09-10-2009, 06:22 AM   #4 (permalink)
BlackBerry Genius
 
hdawg's Avatar
 
Join Date: Aug 2006
Model: hdawg
PIN: port3101.org
Carrier: hdawg
Posts: 6,632
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

It is a series of triggers that is supposed to help performance such that the BES has to do fewer table scans of the database, and instead events / actions are performed based on triggers.

Unfortunately in some environments it has caused more performance problems than performance benefit.
Offline  
Old 09-10-2009, 09:09 AM   #5 (permalink)
BlackBerry Extraordinaire
 
noname's Avatar
 
Join Date: Sep 2005
Location: Congested Islet of "Foreign Talents" (> 45% of workforce) - Singapore.
Model: Z10
OS: 10.0.0
PIN: NUKE(PAP)
Carrier: Singtel
Posts: 1,504
Post Thanks: 6
Thanked 9 Times in 9 Posts
Default

misfiring triggers I guess... LOL Thanks for the advise!
__________________
Native but 4th class citizen of a nation governed by idiots who import congestions & contention.
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.