How can I check how much My SQL server is utilizing Physical Memory and How much we have allocated physical memory to my sql server

Hi,

You can use the following query to reconfigure the physical memory

USE master
EXEC sp_configure 'max server memory (MB)', '3'
RECONFIGURE WITH OVERRIDE


Or In the Enterprise Manager Section right click on the Instance and select properties and in the Memory Tab you can set the Required Memory Settings

Regards
Pradeep

Pradeep

Sorry,

I missed one thing Use EXEC sp_configure 'max server memory (MB)'
to see how much physical Memory is currently Used.

Regards
Pradeep

Pradeep

Hi,

No,I am looking for the procedure or any function in which it return me , how much physical memory SQL is utilizing

Hi,

a small guess if its not useful ignore it,in the server where sql server is installed go to task manages and in the processes tab you can see the memory used by sqlserver.exe

regards
Pradeep

Pradeep