I have an asp.net website up and running in my production server. I want to get the possible ways of profiling an asp.net website in a production server because my application is really slow? As i say slow i don't mean the delivery of static content but the database operations and my c# code? So any suggestion?
(Full disclosure: I'm on the VS Profiler team)
Visual Studio 2010 Ultimate (and VS2008 Dev/Suite, and VS2005 Dev/Suite) includes a managed CPU profiler that works on ASP.NET websites. If you're profiling on a production machine, you'll want to use the standalone profiler package (small portable installer) that's available on the VS installation media.
If you have VS2010 Ultimate, you can also use the VSPerfASPNetCmd command-line tool to do your profiling. Otherwise, the process is a bit more manual, but it's documented well here.
You can't use VS's profiler in a shared hosting environment. My advice would be to replicate the scenario (load slow page) on your development system and identify and fix the performance problems there. The more expensive Visual Studio editions come with tools for load testing a web site.