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

INTEL P28F010 1 Megs FLASH MEMORY EEPROMS ( Qty 4 ) *** NEW ***
$12.99
INTEL P28F010 1 Megs FLASH MEMORY EEPROMS ( Qty 4 )  *** NEW *** pictureIntel P28F010-200 128K X 8 FLASH MEMORY **NEW** ( 2 PCS ) *** NEW ***
$12.99
Intel P28F010-200 128K X 8 FLASH MEMORY **NEW** ( 2 PCS ) *** NEW *** pictureGE Fanuc IC693CPU363-DL 90-30 Series CPU Module 240K User memory
$1049.95
GE Fanuc IC693CPU363-DL 90-30 Series CPU Module 240K User memory pictureAMP 1MM DRO MEMORY SOCKET PN: 5390108-3 ( Qty 2 ) *** NEW ***
$12.99
AMP 1MM DRO MEMORY SOCKET PN: 5390108-3 ( Qty 2 ) *** NEW *** pictureUMC UM74HCT612 74HCT612 MEMORY MAPPER ( 2 PCS ) *** NEW ***
$14.99
UMC UM74HCT612 74HCT612 MEMORY MAPPER ( 2 PCS ) ***  NEW *** picture






Copyright 2004-2016 BlackBerryForums.com.
The names RIM and BlackBerry are registered Trademarks of BlackBerry Inc.