The SQL server is on a shared hosting provider, so I suspect I would not be able to attach a profiler to the sql server database (admin rights needed?). I do not have debug access to the sql server ...
We have a legacy setup that runs ASP and SQL2000, each on their own servers and each are on a fully patched SP'd Windows 2000 Server. This ASP web app is well known for hammering our SQL2000 server ...