We run a moderate-traffic website (>10,000 per day visitors). Our application, which is written in classic asp, is fairly DB and resource intensive and as a result of recent traffic growth is slowing down or hanging at regular intervals throughout the day.
We are running on window server 2008 RS with IIS7.5 and Sql Server 2008RS.
We are looking for someone to do the following:
- Check and optimise our IIS settings and configuration
- Check and optimise our SQL server configuration and settings
- Run traces and do DB analysis to optimise SQL Server (indexes etc)
- Make suggestions on how to streamline the most common queries that are being run against the DB
In short - make it run faster and stop hanging.