I'm trying to figure out how to display cpu/mem utilization of all databases on a particular sql server. My DB guys would like to be able to go to the page for a particular server and see a list.... similar to the one where all the components are listed, with their cpu/mem utilization.
Is this possible ? I've been researching WMI and possibly an sql query, but haven't found the right combo yet.
As of right now, I'm thinking the only way to do this to possibly create a component for each db instance on the server ? not sure if that will even work like I want it to...
thoughts anyone ? appreciate it!