I use the IIS6.0 SQL2000 architecture in WIN 2003. Recent IIS always stops, the SQL statement is slow, and the server will be restored every day. How to set it now? ? Note: It is easy to happen in a stored procedure (execution time 2 seconds) that is particularly running several data. Later, after analysis, in fact, IIS stop reasons generally have the following reasons: 1. System hardware - CPU speed, memory size 2, program itself performance, there is a lot of giant resources algorithm or too frequent reading data 3, application pool Configuration, whether to recover idle memory 4, virus-specially blocked worms, etc. I put most energy in 1-3 reasons, add memory, optimize the stored procedures of the large operation, etc., reconfigure the application storage, but no Pay attention to the fourth reason, because the server just has been paid soon, I don't believe it soon, I will know that I use Rising to know that it is most likely that it is most likely that it is impossible!
