Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



ASP, SQL Consultant needed

Software Development


Reply
 
Thread Tools Search this Thread
  #1  
Old 07-08-2010
Member
 
Join Date: Dec 2009
Posts: 12
ASP, SQL Consultant needed
  

We have a web portal done with asp (classic) and sql 2005(std) loaded on windows 2003 32 bit. We are facing lot of problems due to high usage on CPU+Memory.

We are looking for a consultant for our project specially for guidance in asp,sql code optimization to improve speed and reduce load on server (to utilize least possible CPU and memory).

Reply With Quote
  #2  
Old 09-08-2010
Member
 
Join Date: Nov 2008
Posts: 1,054
Re: ASP, SQL Consultant needed

Quote:
We are looking for a consultant for our project specially for guidance in asp,sql code optimization
By that are you referring to some person or some online help over here?

BTW regarding your problem, which machine are you referring to: client or server? Does this happen in any particular browser? Are you using flash in your website? High usage of CPU as well as memory can be due to too much of javascript files that should be loaded.
Reply With Quote
  #3  
Old 09-08-2010
Member
 
Join Date: Dec 2009
Posts: 12
Re: ASP, SQL Consultant needed

We prefer online help.

Actually our web hosting company told us that our web site is taking high cpu as well as memory. On the server when we checked the various processes through task manager we found w3wp.exe and sqlservr.exe both are highest consumer of CPU and highest memory is consumed by sqlservr.exe The plain html pages are not taking too long but some database driven asp pages are taking time so we felt its not the client side but server side processing that is creating problem. We often get query timeout and deadlock errors.

We are not using flash
Java script is used but not too much
Reply With Quote
  #4  
Old 09-08-2010
Member
 
Join Date: May 2008
Posts: 4,559
Re: ASP, SQL Consultant needed

Are you able to login into DNP? The error that you have posted is related to user application. Most probably it's trying to instantiate some COM component. You need to make sure DNPEnterpriseServer database is not imported in DNP and also make sure ES database is not in the list. Otherwise, detach it (do not delete, but detach).
Reply With Quote
  #5  
Old 10-08-2010
Member
 
Join Date: Dec 2009
Posts: 12
Re: ASP, SQL Consultant needed

Hi Glenny

Thanks for the reply
Can you please explain the terms DNPEnterpriseServer, DNP, ES database
Reply With Quote
  #6  
Old 10-08-2010
Member
 
Join Date: Nov 2008
Posts: 1,054
Re: ASP, SQL Consultant needed

What does your Event Manager say about this processes (w3wp.exe and sqlservr.exe)? Did you find anything strange in your Event Manager? Download and install CPU-Z on the server and see what it says. Also post the result in the attachment.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "ASP, SQL Consultant needed"
Thread Thread Starter Forum Replies Last Post
IS SAP consultant is a good career. amitweb007 Education Career and Job Discussions 2 26-09-2011 05:46 PM
Looking for Citrix Netscaler Consultant ewayshank Education Career and Job Discussions 1 16-10-2010 12:57 AM
MCA/MSC IT/ MSC TT/ MBA-Help needed aneet Education Career and Job Discussions 2 21-10-2009 01:45 AM
Carrier Consultant in Chennai alagubharathy Education Career and Job Discussions 2 11-08-2009 01:15 PM
TCP Acknowledgement Frequency Configuration and Need Consultant in San Jose Area Will Windows Server Help 4 30-03-2007 04:55 AM


All times are GMT +5.5. The time now is 08:27 PM.