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.