Solved

Alert Program, with SQL Server backend

Posted on 2007-03-29
6
232 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
Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

 
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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

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…
Entering time in Microsoft Access can be difficult. An input mask often bothers users more than helping them and won't catch all typing errors. This article shows how to create a textbox for 24-hour time input with full validation politely catching …
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

706 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now