Questions tagged [tsql]

Transact-SQL is the Microsoft extension of ANSI standard SQL.

Filter by
Sorted by
Tagged with
16
votes
1answer
48k views

How do you get the minimum and maximum memory allocation of a SQL instance using T-SQL?

I'm managing about 90 SQL Server instances and need a query to determine how much memory has been allocated to each instance. Please note, I'm not asking how to set it, just to see what it's currently ...