sql server notification services: Two Questions;

1) Are there any differences between MS Notification Services that will
ship w/ SQL2005 as opposed to notification services that is available
for SQL2K?

2) I'm interested to know the kind of performance, reliability and
maximum throughput that can be expected in the current implementation
of notification svcs. Has anyone had any experiences good or bad?

Any comments are greatly appreciated.

Joe Arnone
Arizona Public Service Company

Joe,
In answer to your questions:

1.) SQL-NS 2005 offers several feature enhancements over SQL-NS 2000, as
well as performance, reliability, and security improvements. The list of new
features includes a management tool integrated into SQL Management Studio,
an Analysis Services event provider, support for end-user defined matching
rules, a management API, and more. As far as performance goes, we have made
several enhancements and in all scenarios, you should expect the same or
better performance than SQL-NS 2000.

2.) The following whitepaper should give you an idea of the performance you
can expect out of SQL-NS 2000:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/sql_nsperformance.asp?_r=1

We do not yet have numbers published for SQL-NS 2005 - those will be
available closer to the release.

Overall, you should be aware that SQL-NS was specifically designed to scale
well in high-volume applications. It has been deployed successfully in many
real-life production environments, from low volume (thousands of
events/subscriptions/notifications) to high volume (millions to tens of
millions of events/subscriptions/notifications) applications. So far, we
have not yet seen an application where SQL-NS performance does not meet
expectations.

Hope this helps
-shyam
--
Learn more about SQL-NS:
http://www.amazon.com/exec/obidos/tg/detail/-/0672326647/
---------------------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
---------------------------------------------
[quoted text, click to view]

Lots of cool new features in 2005, but I would be hesitant to postpone a
notification services project just for those new features. The obvious
exception is the new analysis services event provider. There is no point
in inventing a wheel that you know is coming soon.

I've found NS to be very reliable and highly scalable. No problems here.


HTH...
Joe Webb
SQL Server MVP

~~~
Get up to speed quickly with SQLNS
http://www.amazon.com/exec/obidos/tg/detail/-/0972688811




[quoted text, click to view]