###Looking for feedback
Please Share the NRQL
What are the main things SQL teams monitor in your company?
What are the monitors you use for Oracle?
I’m trying to work with my DBAs to determine what they would like to see monitored, provided, what they struggle with. For SQL I am providing servers with large amounts of free memory so they can investigate mis-configuration of Max Memory configuration.
SELECT Hostname, memoryFreeBytes/1024/1024/1024 as 'Free Mem GB', memoryTotalBytes/1024/1024/1024 as 'Total Mem GB', memoryUsedBytes/memoryTotalBytes*100 as '% Free' from SystemSample WHERE hostname LIKE '%pdbw00%' WHERE memoryFreeBytes > 32212254720 limit 100 SINCE 1 hour ago