Thanks for the repsonse guys...
Today it went to 99.33%
Here's the alert info...
5/16/2013 3:36:32 AM, OS Memory Usage (Percent) on XXX is Warning.
SQL Server instance XXX - The operating system has 99.33% of memory in use.
OS Memory Usage (Percent): Percentage of total memory used on the SQL Server computer.
And there is no linked server on this instance, and CLR is enabled ( not sure if its using CLR )
we are using 64 bit
Available memory Details :
Total_Physical_Memory_In_MB
12277
Available_Physical_Memory_In_MB
12482
System_Memory_State_Desc ( dont know what this means )
Available physical memory is high
Used this query :
SELECT [total_physical_memory_kb] / 1024 AS [Total_Physical_Memory_In_MB]
,[available_page_file_kb] / 1024 AS [Available_Physical_Memory_In_MB]
,[total_page_file_kb] / 1024 AS [Total_Page_File_In_MB]
,[available_page_file_kb] / 1024 AS [Available_Page_File_MB]
,[kernel_paged_pool_kb] / 1024 AS [Kernel_Paged_Pool_MB]
,[kernel_nonpaged_pool_kb] / 1024 AS [Kernel_Nonpaged_Pool_MB]
,[system_memory_state_desc] AS [System_Memory_State_Desc]
FROM [master].[sys].[dm_os_sys_memory]
Please let me know how to proceed...