Show database connections in Service Map
It would be extremely useful to be able to map an IIS worker process making a connection to a particular database rather than just a SQL Server.
An example, a web server with 5 (this could easily be 100 )unique and unrelated sites. These sites make connection to different databases, some of which are on a shared sql server and others may be on other shared sql servers. The existing solution will only show a connection to the sql server process, which makes the map less accurate than it could be.
Could the databases be presented grouped under the SQL Server process so that we could see connections to specific databases? This would be huge for Service Map functionality.
If you're a SCOM customer, you should check out Squared Up and their application mapping feature (called 'Visual Application Discovery & Analysis'). Don't quote me on this, but I believe they're planning on add specific SQL DB discovery to the feature shortly;
Darren Allen commented
This would be very useful. Hopefully this data can be included in one of the upcoming updates.