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

Big & Tall High Back Extra Wide Memory Foam Office Chair Supports 400 pounds
$195.0
Big & Tall High Back Extra Wide Memory Foam Office Chair Supports 400 pounds pictureSONY IPELA PCS-PG70 Video Confence PCSA-CG70 MCU Memory
$2999.0
SONY IPELA PCS-PG70 Video Confence PCSA-CG70 MCU Memory pictureSmith Corona SD650 Memory Portable Electronic Typewriter w/Cover
$24.0
Smith Corona SD650 Memory Portable Electronic Typewriter w/Cover picture2pcs MC145100CP IC MC145100 DIP-16 Motorola Control Memory
$12.5
2pcs MC145100CP IC MC145100 DIP-16 Motorola Control Memory pictureSiemens Simatic S7 6ES7 951-0KF00-0AA0 Memory Card
$21.5
Siemens Simatic S7 6ES7 951-0KF00-0AA0 Memory Card picture






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