I am trying to show memory information in a graph from a few remote servers using SSRS.
I think that I can run the job every minute to fetch that information from each remote server.
Is it usual to run multiple jobs every minutes? Is it Okay to do in MS SQL?
Also what's other elements people wants to see from the server when they are working on performance issues?