Slow MSQL Response. Why?

[iloveu]

I have a database driven shopping site composed by ASP and MSQL. Before I used Access, the site ran slowly. You guys suggested me to use MSQL, I changed the db to MSQL following you guy' suggestion. Since then, the site runs fast most of times. But sometiems, I get emails from my site watchdog indicating the site is temporarily down due to server error without details. I clicked my site, the site runs very slowly but not down. I double checked my source code and found I closed all data connection in the code. Do you guys have similar experience? Where is the problem? How can I solve the problem completely.

[TheNige]

Maybe it is your stored procedures or sql queries. Indexes might help.

With the details given there is really no way anyone can guess.

[sql-server-performance.com...]

[Easy_Coder]

Too, your not doing stuff like this on all of your queries are you?

select *

[aspdaddy]

Could be any number of things. Collect some data showing times of problems then check out the event logs, & IIS logs should pinpoint whats going on.

Are you running Win 2K or 2K3, shared or dedicated server, How much RAM?