get the max memory of all server on the linked server RRS feed

  • Question

  • Hiii 

    we have sevral servers that connecr with linked server ... i want to get the max memory of them ... i search and i konw , can get the max memmory with 'sys.configuration ' and if i write the name of server before that , can have the max memory of that server ... but i need to have all of my servers in an temp table .. i want to update a field in a table in my monitoring server .. can you help me 

    Friday, October 16, 2020 3:08 PM

All replies

  • Hi khatoon,
    For questions about SQL Server, it is recommended to ask the questions in Microsoft Q&A forum and you can get more professional answer.
    Thank you for your understanding.
    Best Regards,
    Daniel Zhang

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Monday, October 19, 2020 2:51 AM