Thanks for the reply.

I am just having sqlserver instance level access and i dont have access to the node.Hence is there anyway to get the details with TSQL itself:

1) Total memory allocated in the windows machine where a sqlserver instances are installed.

-- Check for teh system info.---Any TSQL to get the value

2) Total memory allocated to each sqlserver instances in the machine.

-- Check server properties.---Do you mean to say max and min memory?

Appriciate your help.

Mithra.