Performance Issue of a website which is running at the server

Question

0.00/5 (No votes)

See more:

Dear All,

We have two web sites created using ASP.Net(vs2008) and sql server 2008.

We hosted these web sites in the same server. But the speed of one site is good and the other is too slow in performance.

Can any one please tell me what might be the issue?

Regards,

Posted 9-Aug-11 1:17am

Raj.rcr

Add a Solution

Comments

Herman<T>.Instance 9-Aug-11 7:30am

what are the difference between both websites and both databases?

Raj.rcr 9-Aug-11 7:36am

In website1, we are using sql parameters in code behind file of a page, where as in website2, we are using sql parameters function in BLL file which is referenced by the Page.. This is the only difference at the coding side.

R. Giskard Reventlov 9-Aug-11 8:18am

Have you created appropriate indexes? Have you profiled the application? There are so many things you can or should do to ensure that a site runs at optimal speed. It would be impossible to guess what bit you have missed or got wrong without spending time looking at the apps. I would imagine that is what you are paid to do. Look on CP: there are some very good articles relating to optimisation and speed.

[no name] 9-Aug-11 9:09am

Is loading problem in whole website or a particular page?

Raj.rcr 9-Aug-11 9:11am

Actually we have some reports in both the web sites.. while generating the reports, it takes too much time in website2.. i.e., in all the pages.

Raj.rcr 9-Aug-11 9:09am

In the website1, we are making use of xml and in website2, we are not using the xml.. could that be a issue?

2 solutions

Solution 2

Execute the queries in Database and use profiler to analyse it.
Analyse the ASP for round trips from server.
Also good to check if database views are used properly

Posted 9-Aug-11 2:59am

josephbhaskar

Comments

Raj.rcr 9-Aug-11 9:08am

In the website1, we are making use of xml and in website2, we are not using the xml.. could that be a issue?

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Dylan Morley · Accepted Answer · 2011-08-09T02:17:00

It's impossible to tell you exactly what the problem is, however - you can definitely do some performance analysis yourself.

It sounds like the database the slow website is accessing might have some issues. Try and rule out data access as a bottle neck.

Are your queries executing well? Are all the tables indexed correctly? Perhaps run SQL profiler against the database and see if there are any slow running queries, any table scans occurring ??

Maybe run query profiler against some SQL you know is being executed. (in SQL Management Studio, put SQL in query window and choose Query -> Display Estimated Execution Plan). Look at the query plan, can you see any statistics where queries are spending a lot of time?

You need to make sure this is running as fast as possible - Bad table or ineffiecient queries will really slow down your site

If you can totally rule out the database as the culprit, then we'll move onto looking at the differences between the websites!