General discussion

Locked

Need Help!? - ASP ...UPDATE CONTENT

By rsp05 ·
hello:

I desperately need a way to do the following:
I have an asp script that takes all the servers (80+) on the network (from a SQL table) and returns the disk space information. This all works fine, BUT, IT IS TOO DARN SLOW - takes about 2-3 mins to load. This page shows a warning symbol if disk space on a certain Server is > 90%
So, what I would like to do is somewhere, someway, in the background, refresh its content say every few minutes, output results to another HTML file,and make this file available on line where the user would hit this page, and if open will be updated every few minutes as well.....
Any ideas, hints, code, etc. will be accepted and appreciated TIA!!

This conversation is currently closed to new comments.

9 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Need Help!? - ASP ...UPDATE CONTENT

by Peyison In reply to Need Help!? - ASP ...UPDA ...

You could write a VB app that would run on one of your servers that would pull the disk space info for each server. IT could either write out an HTML file, or write the results to the same database that it got the server list from. The VB app could be set to do this at any interval you want. You could probably use your code in your ASP script with a little modification.

If the VB app creates an HTML page, you could have the page refresh itself every few minutes. If it writes to the database,you could take your existing ASP code and modify it a little to read from the database. The ASP page should load pretty fast.

Hope this helps.

Collapse -

Need Help!? - ASP ...UPDATE CONTENT

by rsp05 In reply to Need Help!? - ASP ...UPDA ...

I already built a little VB app to generate the content, and outpt it to HTML thanks.

Collapse -

Need Help!? - ASP ...UPDATE CONTENT

by Blaine Moore In reply to Need Help!? - ASP ...UPDA ...

I would personally just write a script in perl and then run a cron job to update the HTML page however frequently you need it done. The same sort of thing could be done on any platform or with any language, however.

One option is to have your asp page keep track of when the job needs to be done and then redirect you to the generated output page, this would ensure that your application is running if you are using something like VB.

Collapse -

Need Help!? - ASP ...UPDATE CONTENT

by rsp05 In reply to Need Help!? - ASP ...UPDA ...

Poster rated this answer

Collapse -

Need Help!? - ASP ...UPDATE CONTENT

by agibbs In reply to Need Help!? - ASP ...UPDA ...

Is the ASP page looking up the disk space information in the SQL database, or is it actually polling the servers individually to get the available free space in real time? If you're polling from the database, I'd make sure you have it properly indexed for fast searching/sorting.

If you're polling the servers directly, I bet it is slow! :-) That's alot of grunt work for a single ASP page. My recommendation would be to schedule a job on the network (preferably your SQL server) to poll the servers at regular intervals (say, every 5 minutes), and insert the data you require (available disk space) into the SQL table. You can either do this using a trigger in the SQL database or just use Windows NT's AT command. Then you build your ASP page to query the SQL database. The ASP page should load fast if all it's doing is querying the SQL DB.

--Aaron

Collapse -

Need Help!? - ASP ...UPDATE CONTENT

by rsp05 In reply to Need Help!? - ASP ...UPDA ...

Poster rated this answer

Collapse -

Need Help!? - ASP ...UPDATE CONTENT

by gbworld In reply to Need Help!? - ASP ...UPDA ...

There are a variety of ways to monitor this type of activity. One is to create a VB program that gets the disk space information and stores it is SQL Server. You can then use AT to run the process about once an hour or so. The ASP page can retrieve the info from a single table in SQL very quickly. However, SQL can also be made to output HTML of the query if there is still a performance problem.

You can also set it up where any machine that goes over the disk space fires an alert to run the VB program and update the database.

The hardest part here is making a VB command line. Make a standard EXE and drop the form. Create a sub main() in a module to start the process running and set it in project properties. You can then add class modules to do the actual work.

I still do not understand the slowness of the app if it is pulling from SQL, unless it is checking all the servers at the time of load and then pulling the compiled info from SQL. I would relook at the process.

Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

Collapse -

Need Help!? - ASP ...UPDATE CONTENT

by rsp05 In reply to Need Help!? - ASP ...UPDA ...

Poster rated this answer

Collapse -

Need Help!? - ASP ...UPDATE CONTENT

by rsp05 In reply to Need Help!? - ASP ...UPDA ...

This question was closed by the author

Back to Web Development Forum
9 total posts (Page 1 of 1)  

Related Discussions

Related Forums