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


website is getting slow after sometime.

Posted on 2010-01-10
Medium Priority
Last Modified: 2012-06-22
HI Experts,

I have two dedicated server on Godaddy. one is for web server and another if for Sql server 2005. The website has been running fine since a year but recently website get down sometime.
And after I reboot web server it works well and again after sometime latter it becomes slow.

I have only two websites running on the server. One is on ASP and another is on php(small website).

What could be the reason?
- I checked on CPU usuage, it has not used so much memory.

Thank you
Question by:saloj
LVL 57

Expert Comment

by:Raja Jegan R
ID: 26280447
What about your Index Reindexing..
If you don't have any job to update your Indexes on a regular basis, this might impact the performance of your database thus impacting your website..

Author Comment

ID: 26280520
Hi rriegan17, thanks for reply.
can you tell me how do i check index reindexing on my database and how do i set up job for it.
I have a question. if i reboot the web server then it works well, does the index reindexing can effect on it?

Thank you
LVL 10

Assisted Solution

itsmein earned 664 total points
ID: 26280766

this could happen for many reasons. You will need to setup performance counters on the servers to monitor each other or itself and then check the logs for the exact cause of server's sluggish performance.

see this if you are more into programming http://www.codeguru.com/columns/dotnet/article.php/c7279/

to monitor sql server http://knol.google.com/k/sql-server-performance-monitoring-with-perfmon

to mointor network http://www.windowsnetworking.com/articles_tutorials/Windows_2003_Performance_Monitor.html

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!

LVL 57

Expert Comment

by:Raja Jegan R
ID: 26280811
Hope you are aware of using Maintenance plans..
And the step by step guide below would help you to rebuild indexes effectively..


>> if i reboot the web server then it works well, does the index reindexing can effect on it?

Yes.. This might impact but depends on some other parameters too..
LVL 13

Accepted Solution

Springy555 earned 668 total points
ID: 26282081
This is unlikely a SQL issue, if after rebooting your webserver the performance is good.

You should setup application pool recycling on your web server.  On all your application pools in IIS manager console, right click and select properties.  On the recycling tab, ensure 'Recycle Worker processes' is checked, and set how often the worker process should recycle.

Every 24 hours should do the trick, which is 1440 minutes.  You can increase or decrease this value depending on how the performance pans out.

Author Comment

ID: 26299993

Hi All,
itsmein, rrjegan I have followed the links and set up maintenance job and run it too.

Springy555, I also think It is issue on webserver. When webserver reboot it loads very fast in 2-3 sec. But after 10-12 hrs it becomes very slow and almost dead.
I tried to recycle application pools but unless I reboot it becomes slow.
My IIS Application Pool settings.
- checked on, Recycle worker process 1500
- checked on, Recycle worker process(number of request) 35000
- checked on, Recycle worker process at following items
- checked on, Limit the kernel request queue (number of request) 4000
nothing checked on
Predefined Network service.

What else I should check.

Thank you All

Author Comment

ID: 26311474
Hi All,

I have got windows alert to check on IIS worker process on DEP.

I have checked on Data Execution Prevention > "Turn on DEP for all programs and services except those I select."

currently I have not checked on IIS workker process under DEP.
should I check it on and what will be effect ?

Thank you

LVL 57

Assisted Solution

by:Raja Jegan R
Raja Jegan R earned 668 total points
ID: 26314016
     We need to find out whether this slowness is caused by your Queries or Database or the Server itself..
Use profiler and perfmon to determine whether the problem lies in your Queries/ database or the Server..





Based upon the problematic areas found, we can tune/fix that one out..
LVL 57

Expert Comment

by:Raja Jegan R
ID: 26314100
Kindly have an eye over the following Physical Disk counters of Perfmon

# Physical Disk  % Disk Time
# Physical Disk  Avg. Disk Queue Length
# Physical Disk  Avg. Disk sec/Read
# Physical Disk  Avg. Disk sec/Write
# Physical Disk  Disk Reads/sec
# Physical Disk  Disk Writes/sec

because problems in Disk might also be responsible for Slowness in websites and applications..

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.

Question has a verified solution.

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

Prologue It is often required to host multiple websites on a single instance of IIS, mostly in development environments instead of on production servers. I am sure it is not much a preferred solution on production servers but this is at least a pos…
While rebooting windows server 2003 server , it's showing "active directory rebuilding indices please wait" at startup. It took a little while for this process to complete and once we logged on not all the services were started so another reboot is …
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
Integration Management Part 2

564 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