Optimizing SQL database - Consulting project

Hi, I have developed a very large web application (regarding online assessments) in ASP (classic ASP not ASPX) and SQL Server 2005. The application has ~ 200 .asp pages and the database has ~50 tables and ~200 stored procedures. The application is working well. However when the application is used for some time after installation (so the database grows) and/or there are a lot of concurrent users, the application becomes **very** slow, some pages go in timeout and the server CPU is always 100% (the application is hosted on its own dedicated server, together with SQL 2005). While I am redeveloping some .asp pages for better performances, I also noted the tables in the database do not have indexes, so this may be one of the causes of poor performances. I'm not fluent in optimizing SQL tables and stored procedures, so I am looking for a **very** expert SQL database optimizer that can help me to improve the application. The selected coder should know **very well** classic asp, SQL 2005, stored procedures, indexes, keys, optimization, normalization, etc. He/she will receive a Remote Desktop access to a demo server, where he/she can view the application source code and the database. The database should be optimized (e.g. adding indexes) so that it can become quicker even with a lot of users. The coder may also recode .asp pages, if he/she thinks this would improve performances. Also stored procedures should be analyzed and optimized. Of course, in order to do this work, the coder should understand **very well** the logic of the application. A coder with a Microsoft Certification in SQL Server is preferred. [CONTINUES IN ATTACHED FILE, PLEASE CHECK IT] ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). ## Platform Windows 2003 / SQL Server 2005