Query SQL Server 2008 Total Memory Usage
The quick and easy way to determine how much memory your SQL Server is using is to look at the Task Manager on the server and find “sqlservr.exe” in the process list, and look at the “Mem Usage” column. But what if you are not on the server, or if you want to grab this information programmatically from an application, …