We have an application running in classic asp, sql server 2005 database, server houses both the database and application. Started out small, but now there are many queries and about 150 users. Users have began to experience Timeout expired errors when trying to access pages. The errors are occurring at irregular intervals, and not always on the same query/page.
Im pulling my hair out trying to monitor the server, check database indexes, etc. But nothing seems to help or point me in the right direction. The application has been in production for over a year, these timeouts starting occurring on Monday. If anyone can assist and point me in the right direction that would be great.