We have web application:
* Custom ISAPI filter handling web ui
* MS SQL 2008 DB - back end
Over time we have been noticing sluggishness...We have used profiler in the past to analyze and create indexes that have helped. Now it it time to revisit the indexes as some of the db request are taking too long and the web ui components are timing out and or consuming all available threads.
We need someone who can hit the ground running with MS SQL Profiler and help us to determent which indexes we should keep, rebuild and or refine.