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.