Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 481
  • Last Modified:

Problem with slow-loading ASP pages

I have a problem with slow-loading ASP pages on my Windows 2003 Server, which is hosted by a hosting company in a data center. I have looked at some of the other solutions suggested and have implemented them:

1. Added Response.Buffer = True to the connection file.
2. Stopped Windows Indexing Service.

Both of these things seemed to help somewhat, but the pages still load too slowly. This is sporadic - they don't always load slowly, but only sometimes. Many of the pages pull data out of an MS SQL database, which could of course be the bottleneck. However, it is not only pages that display data from the database but pages that don't that load slowly. Sometimes the pages will load almost instantly, and other times they can take up to 20 seconds. I don't get a timeout error - it just takes forever for the page to load.

I had a look at the memory and CPU usage in the Task Manager, and the tasks that are taking a lot of memory are w3wp.exe, ReportingServicesServices.exe, sqlserver.exe, MCShield.exe (this is the Mcaffee virus scan program), and services.exe. The biggest memory user is sqlserver.exe, which is using almost 7 MB of memory. CPU usage is mostly between 0-3%, but jumps occasionaly to 30-40% and once jumped to 50% while I was watching it. I tried doing a search which requires heavy-duty database querying, and it caused CPU usage to jump momentarily by about 10%, but didn't seem to have any effect on memory. The Commit Charge stays around 1900/3945 M.

Here is some more info about the server:

PROCESSOR: Intel Xeon 3060 - 2 x 2.4GHz Cores
MEMORY: 2 GB
DISK: 2 x 250GB SATA II
UPLINK: 100 Mbps Public & Private Networks
OPERATING SYSTEM: Windows Server 2003 Standard R2 (32 bit)

If possible, I would like to avoid having to buy more memory from the hosting company as that is quite expensive. However, if it turns out that is really the problem I will have no choice.

Thanks!
Bill
0
VANCOUVER47
Asked:
VANCOUVER47
  • 8
  • 8
1 Solution
 
sybeCommented:
What about the network? Do you have reasonable ping times to you server?

Once I had a similar situation with a machine in a datacenter and we spend lots of time trying to figure out what the problem was. Even reinstalled the OS but nothing seemed to help.

In desperation one person decided to change the network cable on the machine. That magically helped.

Looking at the specs of the machine and supposing that it is a dedicated machine with only this application running, it might well be an obscure hardware problem.
0
 
Wayne BarronCommented:
One thing that I did within' my own network here.

Have 1 default site
&
Have 5 virtual sites running
(WinXP Pro testing server)

OK. All the other sites run great, no problems, load extremely fast.
But, this one last Virtual Site that I made, it would load SLOWWWWWWWWWWwwwwwwwwww
OK.
I run my own test to see what was going on, and this is what I could like for you to do.
Put a page on your server with nothing in it.
Name this page....    something.asp
Now, bring it open in your browser, and see if it loads slow.
If it does.
Then.
Have the IIS Admin do the following:

Remove your Entry in IIS to your Directory.
Then refresh/save
Then Have him to re-enter your information into IIS.

This SHOULD fix your issue, and have you back to performance standards.

What has happened (At least on my side, we will find out if it is on your side here after you do this)
You meta information within' IIS had become corrupted.
And with this comes slow lagging page load, even on nothing pages.
So.
Removing / Refreshing / Saving / re-Entering /
Should fix your problem.
As it creates a New Meta Data file for your site.

Good Luck
Wayne
0
 
VANCOUVER47Author Commented:
Reply to Carrzkiss:

I tried making the empty something.asp page and it loaded immediately even when I had a database-intensive task running on the server (during this time over 50% of the CPU was being used). I reloaded the file more than 50 times and had not problems.

Like I mentioned in my post, the problem is sporadic - many times pages will load very fast, and then other times they will be slow.

Do you have any other suggestions?

Thanks for you help,
Bill
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
VANCOUVER47Author Commented:
Reply to Sybe:

I tested 4 websites on the server, and got these ping times:

1      42.01 ms
2      91.16 ms
3      899.59 ms
4      133.48 ms

So there was a wide variation, though even the worst one is less than a second - but it kind of shows the kind of wide variability we get.

It is a dedicated server, but have multiple websites, which all have their own specific web applications running. The applications are also pulling data out of an MS SQL database on the server itself.

Thanks for your help!
Bill
0
 
Wayne BarronCommented:
Do you have a lot of [Table | Fields] that are indexed?
That can cause a lag, if you get a lot of hits (Traffic) at a given time, this will slow
Down the load time.

I have a post on EE from a few years ago.
I will try to find it and see if it ever got resolved.
0
 
VANCOUVER47Author Commented:
Reply to carrzkiss:

Yes, we have several table fields in particular in a couple of the databases that have huge amounts of content - 1000's of characters in each entry, and these are indexed. However, it is not always pages that pull data from these fields or tables that are slow. It is often simple asp search forms with no database content in them.

Bill
0
 
Wayne BarronCommented:
I cannot find my other post?
Strange.
I have to reboot, I will check into this in a few, and see if I can find that information for you.
0
 
Wayne BarronCommented:
Bill

Can you provide some of your code, maybe from the Search?
So we can have a look at it, maybe there is something wrong with the way that
The search is being performed?
0
 
VANCOUVER47Author Commented:
Hi Carrzkiss,

I've attached the code for our job search page at http://www.engcen.com/JobSearch.asp. This is only one of 20 or 30 pages that performs search functions on the server. This is one that would be used a lot, though.

Your previous post was:

***********************
Do you have a lot of [Table | Fields] that are indexed?
That can cause a lag, if you get a lot of hits (Traffic) at a given time, this will slow
Down the load time.

I have a post on EE from a few years ago.
I will try to find it and see if it ever got resolved.
*************************

Thanks,
Bill
<%Phead="Search jobs"%>
<!--#INCLUDE FILE="files/2connect.asp"-->
<!--#INCLUDE FILE="files/allfunctions.asp"-->
<%
	keywords = CheckHTMLEncode(trim(Request("keywords")))
	searchfor = trim(Request("searchfor"))
	state = trim(Request("state"))
	city = CheckHTMLEncode(Trim(Request("city")))
	disciplines = trim(Request("disciplines"))
	postdate = clng(Request("postdate"))
	compname = CheckHTMLEncode(trim(Request("compname")))
 
	OpenCon
	If Session("JobSeekerID") <> "" then
		sql = "select count(JobSeekerID) as count from JobAgents where JobSeekerID="& Session("JobSeekerID")
		OpenRS
		rs.open sql,con,adopenkeyset,adlockreadonly
		If not rs.eof then
			If rs("count") >= 5 then
				OverJobAgents = "Y"
			Else
				OverJobAgents = "N"
			End if
		End if	
		CloseRS
	Else
		OverJobAgents = "N"	
	End if
	
%>
<HTML>
<HEAD>
<!--BEGIN Pop-up Windows Script------------------------------------------>
<SCRIPT Language="JavaScript">
<!--
// Copyright 1999 - 2002 by Ray Stott, Pop-up Windows Script ver 2.0
// OK to use if this copyright is included
// Script is available at http://www.crays.com/jsc          
 
var popWin = null    // use this when referring to pop-up window
var winCount = 0
var winName = "popWin"
function openPopWin(winURL, winWidth, winHeight, winFeatures, winLeft, winTop){
  var d_winLeft = 20  // default, pixels from screen left to window left
  var d_winTop = 20   // default, pixels from screen top to window top
  winName = "popWin" + winCount++ //unique name for each pop-up window
  closePopWin()           // close any previously opened pop-up window
  if (openPopWin.arguments.length >= 4)  // any additional features? 
    winFeatures = "," + winFeatures
  else 
    winFeatures = "" 
  if (openPopWin.arguments.length == 6)  // location specified
    winFeatures += getLocation(winWidth, winHeight, winLeft, winTop)
  else
    winFeatures += getLocation(winWidth, winHeight, d_winLeft, d_winTop)
  popWin = window.open(winURL, winName, "width=" + winWidth 
           + ",height=" + winHeight + winFeatures)
  }
function closePopWin(){    // close pop-up window if it is open 
  if (navigator.appName != "Microsoft Internet Explorer" 
      || parseInt(navigator.appVersion) >=4) //do not close if early IE
    if(popWin != null) if(!popWin.closed) popWin.close() 
  }
function getLocation(winWidth, winHeight, winLeft, winTop){
  return ""
  }
//-->
</SCRIPT>
<SCRIPT Language="JavaScript1.2">  // for Netscape 4+ and IE 4+
<!--
function getLocation(winWidth, winHeight, winLeft, winTop){
  var winLocation = ""
  if (winLeft < 0)
    winLeft = screen.width - winWidth + winLeft
  if (winTop < 0)
    winTop = screen.height - winHeight + winTop
  if (winTop == "cen")
    winTop = (screen.height - winHeight)/2 - 20
  if (winLeft == "cen")
    winLeft = (screen.width - winWidth)/2
  if (winLeft>0 & winTop>0)
    winLocation =  ",screenX=" + winLeft + ",left=" + winLeft	
                + ",screenY=" + winTop + ",top=" + winTop
  else
    winLocation = ""
  return winLocation
  }
//-->
</SCRIPT>
<!--END Pop-up Windows Script------------------------------------------->
 
<script language="javascript">
function chkdiscipline(obj)
{
//	alert(obj[0].selected);
	if(obj[0].selected==true)
	{
		for(i=1;i<obj.length;i++)
		{
			obj[i].selected=false;
		}
	}	
}
 
function Validate(theForm)
{
	if(document.all("C1"))
	{
		if(theForm.C1.checked)
		{
			if(theForm.agenttitle.value=="")
			{
				alert("<%= GetErrorText(1110)%>");
				theForm.agenttitle.focus();
				return false;
			}
		}
	}
}
</script>
 
<TITLE>Engineering job search civil chemical mechanical electrical industrial manufacturing employment</TITLE>
<META NAME="description" CONTENT="Engineering job search for jobs for engineers on EngCen.com (Engineering Central) - engineers can search for jobs and post their resumes to find engineering jobs with engineering companies">
<META NAME="Keywords" CONTENT="job search posting resume engineering engineer post jobs place job ad advertising advertise employment career civil chemical structural electrical mechanical industrial jobsearch manufacturing position online">
<link rel="stylesheet" type="text/css" href="include/engcen.css">
<link rel="shortcut icon" href="images/favicon.ico">
</head>
<BODY onUnload="closePopWin()" BGCOLOR="#ffffff" TOPMARGIN="0" LEFTMARGIN="0" MARGINWIDTH="0" MARGINHEIGHT="0" TEXT="#000000"  ALINK="#003399" LINK="#003399" VLINK="#003399">
 
<div align="center">
<center>
<table width="100%" bgcolor="#000000" CELLPADDING="0" CELLSPACING="0" BORDER="0" style="border-collapse: collapse" bordercolor="#111111">
<tr><td width="33%" valign=top><CENTER>
<A HREF=index.asp><img src="<%=Rootpath%>/images/logo.jpg" ALT="Engineering Jobs" border=0 width="231" height="84"></A></CENTER>
</td>
<td align=middle valign=middle width="67%" height="89">
 
<CENTER>
<script type="text/javascript"><!--
google_ad_client = "pub-8985427271660573";
google_alternate_ad_url = "http://www.engcen.com/AltGoogleAd.htm";
google_ad_width = 468;
google_ad_height = 60;
google_ad_format = "468x60_as";
google_ad_type = "text_image";
google_ad_channel ="5427666521";
google_color_border = "578A24";
google_color_bg = "CCFF99";
google_color_link = "00008B";
google_color_url = "00008B";
google_color_text = "000000";
//--></script>
<script type="text/javascript"
  src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>
</CENTER>
 
</td>
</table>
</center>
</div>
 
<!--#include file="include/top2.asp"-->
 
<table cellspacing=10 cellpadding=0 border=0>
<tr>
 
<td width="130" valign=top align=center>
 
<table cellspacing=3 cellpadding=0 border=0 id="table1">
 
<tr><td class="SubHeading">Job Seekers</td></tr>
<% If instr(1,Request.ServerVariables("SCRIPT_NAME"),"jobbank.asp") > 0 or instr(1,Request.ServerVariables("SCRIPT_NAME"),"index.asp") > 0 then %>
<%end if%>
<% If instr(1,Request.ServerVariables("SCRIPT_NAME"),"jobbank.asp") > 0 then %>
	<tr><td><CENTER><a href="jobbank.asp#featured">
	<img src="<%=Rootpath%>/images/featuredjobs01.gif" ALT="Engineering Jobs" border=0 width="130" height="30"></CENTER></a></td></tr>
	<tr><td><CENTER><a href="jobbank.asp#category">
	<img src="<%=Rootpath%>/images/categories01.gif" ALT="Engineering Careers" border=0 width="130" height="30"></CENTER></a></td></tr>
<% Else %>
	<tr><td><CENTER><a href="jobbank.asp">
	<img src="<%=Rootpath%>/images/mainjob01.gif" ALT="Engineering Jobs" border=0 width="130" height="30"></CENTER></a></td></tr>
<% End if %>
 
<tr><td><CENTER><a href="JobSearch.asp">
<img src="<%=Rootpath%>/images/searchjobs01.gif" ALT="Engineering Jobsearch" border=0 width="130" height="30"></a></CENTER></td></tr>
<% If Session("JobSeekerID") = "" then %>
<tr><td><CENTER><a href="CanLogin.asp">
<img src="images/login01.gif" ALT="Engineering Jobs" border=0 width="130" height="30"></a></td></tr>
<% Else %> 
<tr><td><CENTER><a href="CanAccountPage.asp">
<img src="images/account01.gif" ALT="Engineering Careers" border=0 width="130" height="30"></a></td></tr>
<% End if %>
 
<tr><td><CENTER><a href="ResumeSubmission.asp">
<img src="<%=Rootpath%>/images/submitresume01.gif" ALT="Engineering Jobs" border=0 width="130" height="30"></a></CENTER></td></tr>
 
<tr><td><CENTER><a href="http://engcen.employment911.com/?a=1047&b=5000">
<img src="<%=Rootpath%>/images/reswrite01.gif" ALT="Engineering Central - Help in writing an engineering resume for any kind of engineer - chemical, manufacturing, electrical, civil, or mechanical engineers" border=0 width="130" height="30"></CENTER></a></td></tr>
 
<tr><td><CENTER><a href="http://engcen.employment911.com/resumeblasting.asp">
<img src="<%=Rootpath%>/images/resdist01.gif" ALT="Resume Distribution for Engineers" border=0 width="130" height="30"></CENTER></a></td></tr>
 
<tr><td><CENTER><a href="entry.asp">
<img src="<%=Rootpath%>/images/entrylevel01.gif" ALT="Entry Level Engineering Jobs" border=0 width="130" height="30"></a></CENTER></td></tr>
 
<tr><td>
<CENTER><a href="http://engineeringcentral.salary.com" target="_blank"><img src="http://www.engcen.com/images/salary01.gif" width=130 height=30 ALT="Engineering Salary" border=0></CENTER></a></td></tr>
 
<tr><td class="SubHeading">Employers</td></tr>
<tr><td><CENTER><a href="posting/whyus.asp">
<img src="<%=Rootpath%>/images/information01.gif" ALT="Find Engineers" border=0 width="130" height="30"></a></CENTER></td></tr>
 
<% If trim(Session("EmployerID")) = "" then %>
<tr><td><a href="EmpLogin.asp">
<img src="images/login01.gif" ALT="Engineering Resumes" border=0 width="130" height="30"></a></td></tr>
<% Else %>
<tr><td><a href="EmpAccountPage.asp">
<img src="images/account01.gif" ALT="Engineering Candidates" border=0 width="130" height="30"></a></td></tr>
<% End if %>
 
<tr><td><CENTER><a href="PreJobSub.asp">
<img src="<%=Rootpath%>/images/submitanad01.gif" ALT="Post an Engineering job" border=0 width="130" height="30"></a></CENTER></td></tr>
<tr><td><CENTER><a href="ResumeSearch.asp">
<img src="<%=Rootpath%>/images/searchresumes01.gif" ALT="Search Engineering resumes" border=0 width="130" height="30"></a></CENTER></td></tr>
 
<tr><td class="SubHeading">Links</td></tr>
<tr><td><CENTER><a href="englinx.asp">
<img src="<%=Rootpath%>/images/resources02.gif" ALT="Engineering" border=0 width="130" height="30"></CENTER></a></td></tr>
<tr><td><CENTER><a href="software.asp">
<img src="<%=Rootpath%>/images/software02.gif" ALT="Engineering Software" border=0 width="130" height="30"></CENTER></a></td></tr>
<tr><td><CENTER><a href="http://engcen.tradepub.com" target="_blank">
<img src="<%=Rootpath%>/images/freepubs01.gif" ALT="Click here to order free trade publications!" border=0 width="130" height="30"></CENTER></a></td></tr>
 
<tr><td class="SubHeading">Other</td></tr>
<tr><td><CENTER><a href="mailto:admin@engcen.com">
<img src="<%=Rootpath%>/images/emailus01.gif" ALT="Email Engineering Central" border=0 width="130" height="30"></CENTER></a></td></tr>
<tr><td><CENTER><a href="refer.asp">
<img src="<%=Rootpath%>/images/referfriend01.gif" ALT="Refer a friend to Engineering Central" border=0 width="130" height="30"></CENTER></a></td></tr>
 
<tr><td>&nbsp;</td></tr>
 
<tr><td>
<CENTER>
<a href="http://engcen.tradepub.com/free/oe/" target="_blank" >
<img src="images/offshoreengineer.gif" width="112" height="150" alt="Free Subscription to Offshore Engineer Magazine!" border="0">
<font size="2">Get a free subscription to Offshore Engineer Magazine!</a></font>
</CENTER>
</td></tr>
 
<% If instr(1,Request.ServerVariables("SCRIPT_NAME"),"refer.asp") < 0 then %>
 
<% End if %>
 
</table>
 
</td>
 
<td background="images/verticalbar.gif">&nbsp;</td>
 
<td VALIGN="TOP" align="center">
 
<form action="JobResultsList.asp" method="get" onsubmit="return Validate(this)">
 
<p style="font-size: 10pt; line-height: 17px" align="left">
<b>Search for an engineering job on Engineering Central!</b> 
<p class="text" align="center">
 
<span style="font-weight: 700"><font face="Trebuchet MS" size="2">K</font></span><font style="font-weight:700" face="Trebuchet MS" size="2">eywords:</font><font style="font-size: 11pt; font-weight:700" face="Trebuchet MS">&nbsp;&nbsp;&nbsp; </font>
<font face="Trebuchet MS" size=2><A HREF='JavaScript:openPopWin("help/keywords.asp", 350, 350, "scrollbars,resizable", 100, 20)'> 
<img border="0" src="images/question01.gif" align="absmiddle" vspace="10" width="22" height="22"></a></font><table border="0" cellpadding="4" cellspacing="0" bordercolor="#111111" width="100%" id="AutoNumber2">
  <tr>
    <td width="50%" style="border-style: none; border-width: medium" align="right" class="text">
    <font face="Trebuchet MS" size=2>Enter keywords or a phrase:</font></td>
    <td width="50%" style="border-style: none; border-width: medium" class="text"><font style="font-size: 11pt" face="Verdana">
  <input type="text" name="keywords" size="35" value="<%=keywords%>"></font></td>
  </tr>
  <tr>
    <td width="50%" style="border-style: none; border-width: medium" align="right" class="text">
    <font face="Trebuchet MS" size=2>What do you want to search for?</font></td>
    <td width="50%" style="border-style: none; border-width: medium" class="text"><font style="font-size: 11pt" face="Verdana"> 
    <select size="1" name="searchfor">
	<%=GetKeyWordTypeList(searchfor)%>
	</select></font></td>
  </tr>
</table>
 
<hr size=1>
<p class="text" align="center">
 
<font style="font-weight:700" face="Trebuchet MS" size="2">Job 
location:</font><font style="font-size: 11pt; font-weight:700" face="Trebuchet MS">&nbsp;&nbsp;&nbsp; </font>
<font face="Trebuchet MS" size=2><A HREF='JavaScript:openPopWin("help/locationsearch.asp", 350, 350, "scrollbars,resizable", 100, 20)'>
<img border="0" src="images/question01.gif" align="absmiddle" vspace="10" width="22" height="22"></a></font><table border="0" cellpadding="4" cellspacing="0" bordercolor="#111111" width="100%" id="AutoNumber1">
  <tr>
    <td width="50%" style="border-style: none; border-width: medium" align="right" class="text">
    <font face="Trebuchet MS" size=2>State or Province:</font></td>
    <td width="50%" style="border-style: none; border-width: medium" class="text"><font style="font-size: 11pt" face="Verdana"> 
	<select size="1" name="state">
	<option value="">Any</option>
	<%=StateList(state)%>
	</select></font></td>
  </tr>
  <tr>
    <td width="50%" style="border-style: none; border-width: medium" align="right" class="text">
    <font face="Trebuchet MS" size=2>City or Area:</font></td>
    <td width="50%" style="border-style: none; border-width: medium" class="text"><font style="font-size: 11pt" face="Verdana">
  <input type="text" name="city" size="35" value="<%=city%>" maxlength=40></font></td>
  </tr>
</table>
 
<hr size=1>
<p style="font-size: 13px" align="center">
<b>Discipline &amp; posting date:</b>&nbsp; <A HREF='JavaScript:openPopWin("help/discipdate.asp", 350, 350, "scrollbars,resizable", 100, 20)'> 
<img border="0" src="images/question01.gif" align="absmiddle" vspace="10" width="22" height="22"></a>
<table border="0" cellpadding="4" cellspacing="0" bordercolor="#111111" width="100%" id="AutoNumber1">
  <tr>
    <td width="50%" style="border-style: none; border-width: medium" align="right" class="text" valign="top">
    <font face="Trebuchet MS" size=2>Engineering discipline:</font><p class="text"><font face="Trebuchet MS" size=2>
    (Select multiple categories by clicking<br> &nbsp;while holding down the Control key)</font></td>
    <td width="50%" style="border-style: none; border-width: medium" class="text"><font style="font-size: 11pt" face="Verdana">
	<select name="disciplines" multiple size="10" onkeydown="return chkdiscipline(this)">
	<%=DisciplineListMultiple(disciplines)%>
	</select></font></td>
  </tr>
  <tr>
    <td width="50%" style="border-style: none; border-width: medium" align="right" class="text"><font face="Trebuchet MS" size=2>Posting date:</font></td>
    <td width="50%" style="border-style: none; border-width: medium" class="text"><font style="font-size: 11pt" face="Verdana"> 
	<select size="1" name="postdate">
	<option selected value="60" <%=SelectDropDown(postdate,60)%>>Less than 60 days old</option>
	<option value="30" <%=SelectDropDown(postdate,30)%>>Less than 30 days old</option>
	<option value="14" <%=SelectDropDown(postdate,14)%>>Less than 14 days old</option>
	<option value="7" <%=SelectDropDown(postdate,7)%>>Less than 7 days old</option>
	<option value="3" <%=SelectDropDown(postdate,3)%>>Less than 3 days old</option>
	<option value="1" <%=SelectDropDown(postdate,1)%>>Less than 24 hours old</option>
	</select></font></td>
  </tr>
  <tr>
    <td width="50%" style="border-style: none; border-width: medium" align="right" class="text">
    <font face="Trebuchet MS" size=2>Company name:</font></td>
    <td width="50%" style="border-style: none; border-width: medium" class="text"><font style="font-size: 11pt" face="Verdana">
  <input type="text" name="compname" size="35" value="<%=compname%>" maxlength=50></font></td>
  </tr>
  
 <% 
	x = 0
	if x = 1 then 
%>
 <%' if Session("JobSeekerID") <> "" and OverJobAgents <> "Y" then %>
 <%' if OverJobAgents = "Y" then %>
  <tr>
    <td width="50%" style="border-style: none; border-width: medium" align="right" class="text" valign="top">
    <font face="Trebuchet MS" size=2><b>Save this search as an agent</b>&nbsp;&nbsp;</font></td>
    <td width="50%" style="border-style: none; border-width: medium" class="text"><input type="checkbox" name="C1" value="yes">&nbsp;&nbsp;<B>NOTE:</B> If you save this search as an agent, you are giving us permission to send you email. Please click on the question mark below for more information.<BR>
 
	<CENTER><A HREF='JavaScript:openPopWin("help/savejobsearchasagent.asp", 350, 350, "scrollbars,resizable", 100, 20)'>
	<IMG SRC ="images/question01.gif" BORDER=0 align="absmiddle" width="22" height="22"></A></CENTER></td>
  </tr>
  <tr>
    <td width="50%" style="border-style: none; border-width: medium" align="right" class="text">
    <font face="Trebuchet MS" size=2>Job Agent title (to help you remember what it is):</font></td>
    <td width="50%" style="border-style: none; border-width: medium" class="text"><font style="font-size: 11pt" face="Verdana">
  <input type="text" name="agenttitle" size="35" maxlength=100></font></td>
  </tr>
  <tr>
    <td width="50%" style="border-style: none; border-width: medium" align="right" class="text"><font face="Trebuchet MS" size=2>How often should results be sent?</font></td>
    <td width="50%" style="border-style: none; border-width: medium" class="text">
    <font style="font-size: 11pt; font-weight:700" face="Verdana">
    <select size="1" name="agentresults">
    <%=JobAgentResultList("")%>
    </select></font><b><font face="Trebuchet MS" size=2>&nbsp;&nbsp; </font>  
	<A HREF='JavaScript:openPopWin("help/jobagentresults.asp", 350, 350, "scrollbars,resizable", 100, 20)'>
    <font face="Trebuchet MS" size=2>
	<IMG SRC ="images/question01.gif" BORDER=0 align="absmiddle" width="22" height="22"></font></A></b></td>
  </tr>
<%' End if %>
<% End if %> 
 
</table>
<span style="font-size: 11pt">
<p align="center" class="text">
<input type="submit" value="Click here to search jobs!" style="font-weight:bold"></span></font></p>
</form>
 
</td>
 
</tr>
</center>
 
</table>
 
<hr size=1><center><P>
 
<CENTER>
<script type="text/javascript"><!--
google_ad_client = "pub-8985427271660573";
google_alternate_ad_url = "http://www.engcen.com/AltGoogleAd.htm";
google_ad_width = 728;
google_ad_height = 90;
google_ad_format = "728x90_as";
google_ad_type = "text_image";
google_ad_channel ="5427666521";
google_color_border = "336699";
google_color_bg = "FFFFFF";
google_color_link = "0000FF";
google_color_url = "008000";
google_color_text = "000000";
//--></script>
<script type="text/javascript"
  src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>
</CENTER>
 
<P>
<a href="index.asp"><u>
<font face="Trebuchet MS" size=2>Home Page</font></u></a><font face="Trebuchet MS" size=2> | 
<% If Session("JobSeekerID") = "" then %>
<a href="CanLogin.asp">Log In</a> |
<% else %>
<a href="CanAccountPage.asp">Your Account</a> |
<% End if %>
 
<a href="jobbank.asp">Browse Jobs</a> |
<a href="JobSearch.asp">Search Jobs</a> | <a href="CanHelp.asp"><u>Help</u></a> |
</font>
<a href="mailto:admin@engcen.com"><u><font face="Trebuchet MS" size=2>Contact Us</font></u></a>
<p align="center" class="text"><font face="Trebuchet MS" size="2">Copyright &copy; <%=Year(Date())%>, Engineering Central Career Service Inc.</font></p>
</P>
 
</body>
</html>

Open in new window

0
 
Wayne BarronCommented:
I just went onto the page.
And did a search for   Test
And man, the site loads extremly fast
Less then a second.

I am not witnessing this drag.
Can you provide another page that does this drag?
As the search is FAST!!!!!!!!!
0
 
VANCOUVER47Author Commented:
One of the pages that loads slowly a lot of the time is the home page at http://www.engcen.com/index.asp - however it doesn't happen all the time. It's unlikely it's going to do it for you when you want to see it. Today the site seems to be loading pretty quickly, though nothing has been changed since yesterday.

There is a lot of database content in the home page, but that doesn't seem to slow it down too much on most occasions.

Bill
0
 
Wayne BarronCommented:
I hate it when it does that.
It is about like having a sick kid and taking them to the Dr. and then they are not sick no more.


It is going to be had to narrow down what it is, since it does not happen all the time.
If it was happening all the time, then it would be a
Database issue
IIS Issue (Like that I explained earlier)
ASP Code issue.

But neither of them seem to be an issue with what you have.
The only other thing that I can suggest, is that you try one of the ASP Monitors that are available.
http://www.advancescripts.com/detailed/1281.html

Now, I use to use this back years ago, but have not in well,,,, years.
So, I cannot really give no advice or information on it.

I can mention this as well.

Do you have a AntiVirus program installed?
Maybe it is trying to scan the database (or) the scripts folder during this time?
So, the next time that it happens, check your anti-virus program and see if it is doing anything.
ALSO
Do you run any additional programs like: Diskeeper?
I know that went Diskeeper runs on my computer, it lags on certain things, Even though
It takes just a few seconds.

Also. Check your Event Viewer during the time that it is going slow.
See if any error's show up.
See if something is happening?

let me know what you find out, and i will try my best to help you.

Wayne
0
 
VANCOUVER47Author Commented:
I do have an anti-hacker firewall (DotDefender) installed and some other programs, but nothing that seems to be taking a lot of memory if you look at task manager.

There are a lot of these errors in the Application section of the Event Viewer:

****************************
SQLVDI: Loc=CVDS::Cleanup. Desc=Release(ClientAliveMutex). ErrorCode=(288)Attempt to release mutex not owned by caller.
. Process=2908. Thread=7588. Client. Instance=SQLEXPRESS. VD=.
****************************

It sounds like some hacker ploy to me, but it obviously involves the database somehow. Do you know what it means?

Bill
0
 
VANCOUVER47Author Commented:
Hi Carrzkiss,

Thanks for all your help. I'm going to close off this question as I think it's already consumed enough of your time and you've been very helpful. I have downloaded the latest version of SQL Server 2005 (SP3) which supposedly includes all the hotfixes to date. I had some trouble installing it to start with, but got some technical assistance from Microsoft and was able to install it. I will see if that solves the problem.

Thanks again for your help!
Bill
0
 
VANCOUVER47Author Commented:
Carrzkiss was extremely helpful with a very difficult issue. Though it is not completely resolved, I believe I now have a good handle on what the various causes might be.
0
 
Wayne BarronCommented:
Anytime Bill.
I hope that it all works out for you.

Wayne
0

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 8
  • 8
Tackle projects and never again get stuck behind a technical roadblock.
Join Now