Comming across a question of a colleague of mine, the following script can be used to determine the (available / assigned) amount of memory for an instance / machine. Notice that the DMVs are only available on SQL Server 2005, for using the script on
Read More...