I need to find the size of all db's and server's processor and RAM info etc. Please share if you have any nice script which does that. I don't mind extra information, if not needed then I can hide those columns.
Also, please advise, how can I pull this information from 10 different instances on diff servers in one go? is there any way to do it in one go with PowerShell etc.? if no, then I will run the SQL/PS on each instance to get the information. I do see a problem with pulling in one go example, what is two different instances have same db name etc so this is optional.
Please share if you have any handy SQL or PS script.