How to speed up an ASP/MS SQL web application
I have an ASP with MS SQL 2008 web application.
It runs fine on some installations but for one or two it runs very slow, the settings are identical. This two have more data in the database but nothing that should slow it down.
What kind of things can I do to speed it up ?
Index the DB ? if so how ? How would I 'run a trace' and then index based on that ?
Anything else that I could do to make the system faster ? seems like only pages with connection to the database are slow.
It runs fine on some installations but for one or two it runs very slow, the settings are identical. This two have more data in the database but nothing that should slow it down.
What kind of things can I do to speed it up ?
Index the DB ? if so how ? How would I 'run a trace' and then index based on that ?
Anything else that I could do to make the system faster ? seems like only pages with connection to the database are slow.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
It runs fine on some installations but for one or two it runs very slow, the settings are identical.Are those installations in the same network?
ASKER
Different networks. I will spread the points. My client's IT will run a trace and index the DB and see if that helps.
Well indexed dB, good queries and throw your data to an array instead of a recordset are the biggest without seeing what you are doing.