Need a SQL Query for finding OS Version, RAM, etc
Check out Glenn Berry's Diagnostic Scripts. He includes a whole range of queries in there for accessing server information, including a basic health check.

You will need to download the set of scripts appropriate for the version of SQL Server you're diagnosing.