Let me see If I can recollect all. Hope you have Visual studio 2008 or greater. To attach to a remote process, you would have to rely on the debugger in your machine's Visual Studio.
To begin with, you need the "Visual Studio Remote Debuggin Monitor" application on the actual web server (production webservers in your case). You can do a xCopy of this from the X:\Program Files\Microsoft Visual Studio 9.0\Common7\IDE\Remote Debugger\x86 folder from the machine where this is installed. You will see files named "msvmon.exe" in this folder. Place this on the webserver under a known path. Also make sure, you have the right version of the msvmon utility copied - x86/x64/IA64.
In the webserver, open the MSVmon.exe file that you just copied. You may get some warnings, if your firewall blocks remote debugging. Choose to let remote debugging.
Then, in the MSVMon.exe interface, go to Tools- Options. You will a screen like below. Set "No authentication" and check the box that reads "Allow any user to debug". Note that this is a quick way of avoiding authentication issues.
Remote debugging is now set on the web server.
Now, open the Visual studio, and go to Tools - Attach to process. The processes dialog shows up. Change "Transport" options to "Remote - native with no authentication", and give the webserver name in the "Qualifier" text box. Under the processes listed, choose the worker process, and you should be good to go.
Hope this helps.