I have developed a web based application with ASP.Net (VB) and SQL server 2000. Version of .Net framework is 1.1 and .Net SDK is 2002. Everything was running smoothly but offlate the application is behaving abnormally. suddenly a report is not generating but if I generate the same report after sometime or another day the report is generating smoothly. Sometimes it gives java script error. But these errors are not encountered everytime.
I believe that these errors are encountered because of the growing database and SQLServer is not able to handle the load. At a time more 50 - 75 users will be accessing the application across different location.