I have 3.5 .net website. It's online billing website where clients download pdf, excel files.
Recently the table showing billing record got very slow. I ran the SQL query to database, the result comes up normally. I suspect the problem is somewhere in web server or the code itself because the code searches the client's directory and if there's pdf file, it doesn't create the receipt or excel file, but reuse it. In web server IIS, is there any way to find or test what is causing this problem?
2003 STD IIS, .NET 3.5