> Hi Pete -
>
> I'm not familiar with the Notification Workflow Solution Accelerator
> application so I cannot offer much assistance there.
>
> I can tell you that SQLNS is cluster aware so at least from that
> perspective you should be fine.
>
> One point of clarification: the NSMain database is the instance
> database and it contains subscriber and subscriber device information
> whereas the application database,
> NotificationWorkflowNotificationWorkflowApp in your case I believe,
> contains the subscription, event, and notification information.
>
> Have you created subscriptions that match the events you're
> collecting?
>
> HTH...
>
> ~~~
> Get up to speed quickly with SQLNS
> http://www.amazon.com/exec/obidos/tg/detail/-/0972688811
> I support PASS, the Professional Association for SQL Server.
> (www.sqlpass.org)
>
> On Tue, 31 Jan 2006 19:59:08 +0000 (UTC), Pete Zerger
> <pete.zerger@gmail.com> wrote:
>
>> Let me provide additional information that may assist.
>>
>> In the event someone participating in this group is familiar with the
>> Notification Workflow Solution Accelerator application, I see lots of
>> activity to the NotificationWorkflowNotificationWorkflowApp database
>> (which means event data is being pulled across from Onepoint), but no
>> activity whatsoever (even at a filesystem level) to
>> NotificationWorkflowNSMain, which holds all the subscriber and
>> subscription data. This is further supported by the
>> NS$NotificationWorkflow performance counters, which show the Quanta
>> processed counter incrementing every 15 seconds, but still shows 0
>> subscribers and 0 subscriptions, even though we have created several
>> and the information is present in the NotificationWorkflowNSMain
>> database.
>>
>> Kind Regards,
>>
>> Pete Zerger MCSE(Messaging)
>> mail:pete.zerger@nospam.gmail.com
>> BLOG:http://www.it-jedi.net/
>>> I am working with the Notification Workflow Solution Accelerator (a
>>> solution accelerator for MOM), and I am not finding any official
>>> support statement or guidance on running the application on a
>>> clustered SQL instance, and have found conflicting claims of support
>>> in the MS newsgroups. Since this app is based on SQL Notification
>>> Survices, which is cluster-capable to my knowledge, I wanted to
>>> determine if this application is capable of running successsfully on
>>> a clustered SQL instance. Thus far, we have been unable to make it
>>> do so
>>>
>>> In the interest of the best use of our time, clarification would be
>>> most appreciated.
>>>
>>> This post from an MS resource implies support for named and
>>> clustered SQL
>>>
>>> instances:
>>>
>>> http://groups.google.com/group/microsoft.public.mom/browse_thread/th
>>> re
>>> ad/476b1481594918d9/bdf47f67763c1a19?lnk=st&q=sql+notification+servi
>>> ce
>>> s+logging&rnum=3&hl=en&utoken=1asA1zcAAACAT_kPml7nPanGq5_khmjXp082g2
>>> jF HE-R0j7gEQoqfnvDyIr2trlnwjbGeK6z6-U5QvIbA_SapvijBBSQFbov
>>>
>>> This post from a supposed former MS resource claims it is
>>> unsupported:
>>>
>>> http://groups.google.com/group/microsoft.public.mom/browse_thread/th
>>> re
>>> ad/8c2b2be5d2e01837/9dcf822ffa2bdfd5?lnk=st&q=MOM+notification+workf
>>> lo w+cluster&rnum=1&hl=en#9dcf822ffa2bdfd5
>>>
>>> Any thoughts or official stance would be most appreciated.
>>>
>>> Kind Regards,
>>>
>>> Pete Zerger MCSE(Messaging)
>>> mail:pete.zerger@nospam.gmail.com
>>> BLOG:http://www.it-jedi.net/
>>> Kind Regards,
>>> Pete Zerger MCSE(Messaging)
>>> mail:pete.zerger@nospam.gmail.com
>>> BLOG:http://www.it-jedi.net/