For anyone running Windows 2008 (or above), you can simply add the “Command Line” column to the Task Manager view. From there, the instance name will follow the “-s” startup option, for example: C:\…\Binn\sqlservr.exe” –sPREPROD If you’re on Windows 2000/2003 then it’s not quite as straight forward. You can either get the Process ID from
The nmon (Nigel’s Monitor) tool was written initially for AIX to monitor system performance, but there are plenty of distributions available now so people can use it on a variety of operating systems these days, including flavours of Linux and even the recent Raspberry Pi (mini ARM based computer). It’s one of my favourite performance monitoring tools
Generally speaking, the Java heap memory utilization for your Oracle Management Service (OMS) should be averaging at under 75%, and anything over this could mean the Garbage Collection starts impacting the performance of your Enterprise Manager experience. If you’re using the “out-of-the-box” notification rules, then an OMS suffering such symptoms may start churning out events like this: