Can you use the Azure DiagnosticMonitor in an Azure Web Site (not a web role) ? Or does it need a compute role?
No, You can't use Windows Azure Diagnostics (DiagnosticsMonitor) in an Azure Website. You would need to use a compute role for that.