Solved

Alert Program, with SQL Server backend

Posted on 2007-03-29
6
237 Views
Last Modified: 2013-11-27
I am going to attempt a small project to create a warning system for my company... I have in mind a small program that would reside in the system tray and when a central SQL Server is updated with a message, the program would flash and show that message. Problem is there are almost 30,000 computers in my company and I dont know if a SQL Server could handle that many computers constantly hitting it requesting if there are any new messages...

does anybody have any thoughts on the right way to go about setting something similar up?
0
Comment
Question by:NickJPhillips
  • 3
  • 2
6 Comments
 
LVL 30

Expert Comment

by:nmcdermaid
ID: 18821028
Do the warnings go to specific groups of computers?

i.e. would there be a single warning to, say, 300 computers? Or is it a global broadcasting system?

You can actually use NET SEND (a dos command line program) to send pop up messages to computers or users. That way you don't need to roll out a desktop application.

Are you doing this on SQL 2000 or SQL 2005? SQL 2005 has a message queue service that would let you push out messages to desktop applications.


If your server, and more importantly, network supports it, it SQL Server will have no problem doing this. The main issue is the network - you could flood it with packets and cause havoc if there is not enough bandwidth.

The main idea is to push the messages out to the client. Don't have a zillion people polling SQL Server every second.
0
 

Author Comment

by:NickJPhillips
ID: 18821279
The Backend would be SQL 2005. I thought of actually developing something in Express for testing. I am not envisioning anything to large or fancy... My initial thought is this would be a broad-based global warning system... and maybe in the future I could refine it to allow warnings to specific groups, people, etc...

I am very curious as to the "push-methods" you bring up. I am definately not familiar with this method or process...

Thanks in advance!!
0
 
LVL 42

Expert Comment

by:dqmq
ID: 18822044
Since you are using SS2005, I would refer you to notification services and .net alerts for that app. I've never used it, but conceptually it fits to a T (what does that mean, anyway?)

At a very high level, your application can issue an alert using notification services, which I'm almost certain is a message queueing application.  There would be almost no overhead to raise the alert. Client's would be sitting on a "hot read" as opposed to continuously polling for alerts, so there would be almost no client overhead, either.  Of course, there would be some load on the message server and a network burst to deliver the alert messages.  I doubt an occasional 30,000 messages would really be that much, but if it were, the messaging topology could always be configured so that far fewer messages are "pipelined" to intermediate message servers and distributed from there to spread the workload.
 
Here's the MS page to get you started:
http://www.microsoft.com/sql/technologies/notification/default.mspx 
0
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
LVL 30

Expert Comment

by:nmcdermaid
ID: 18827776
... what he said  :)

Any reason you don't want to just use email?
0
 

Author Comment

by:NickJPhillips
ID: 18829292
Problem with e-mail is people dont always read them when they come in. The program I would like to write would be an IMMEDIATE alert... for example,

a weather warning... "TORNADO WATCH IN EFFECT...STAY IN DOORS"

and any other type of warning or message that needed to go out to users immediately. I don't want to use NETSEND or something similar because I want to write a program that takes up 100% of the screen real estate and forces the user to focus on that before exiting it out.

I have beenr eading about the notification services, but I am still completley in the dark. I understand the buisness model for them... allows users to subscribe, send out updates, etc... makes sense. But to start programming a front end program that can communicate using notification services has be drawing a blank!!!
0
 
LVL 30

Accepted Solution

by:
nmcdermaid earned 500 total points
ID: 18831422
You just need to code something that listens for messages from SQL Server.

This link in the SQL Server help looks likea good place to start.

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/sqlntsv9/html/73a8501c-9d89-4f47-9735-020fe61b23a4.htm

0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A theme is a collection of property settings that allow you to define the look of pages and controls, and then apply the look consistently across pages in an application. Themes can be made up of a set of elements: skins, style sheets, images, and o…
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how the fundamental information of how to create a table.

685 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question