We have a complex ecommerce website custom developed by our programmers which uses MS SQL Express 2005 edition. However, we have the following problems since a long time :
1) The website is running extremely slooooooowwww.
2) When we check the website server Windows Task Manager for the processes that are using maximum resources, we find that SQL server is using up 97-100% of the CPU time continuously. We have attached the screen shot for reference.
3) We believe the SQL queries and stored procedures used in ASP.net programs of our website need to be highly fine tuned so that it does not require such high CPU time usage.
4) Our programmers have already done their best to optimize the queries and now it is beyond their abilities to resolve the problem of high CPU time getting used up by SQL server for the website.
5) Hence we need a MS SQL Server Guru or Expert who has expertise in optimization of very very complex queries and website programming.
6) We will provide FTP and MS SQL Server and website server Access.
You must be atleast 8-10 years experienced in MS-SQL Server and must have very high level of expertise in SQL queries. Only then you will be able to help us because the website is complex and has already been optimized by coders with 5-6 years of experience but not successful.
We will pay only after we see a reduction of CPU usage time by the website and SQL server from existing 95-100% to less than 50%.
Our website url is [[login to view URL]][1]
## Deliverables
See the attached screen shots