The below query runs almost every hour during the day.  It is the #1 query in terms of total execution time for our SQL server which

Spent a significant amount of time on these wait activities

• MEMORY_ALLOCATION_EXT (13 seconds)
• PREEMPTIVE_XE_GETTARGETSTATE (9 seconds)

SELECT target_data

FROM sys.dm_xe_session_targets xet

WITH

   (

      nolock

   )

JOIN sys.dm_xe_sessions xes

WITH

   (

      nolock

   )

ON xes.address = xet.event_session_address

WHERE xes.name = 'telemetry_xevents'

AND xet.target_name = 'ring_buffer'

I found that our SQL server has the default memory set (2147483647 MB).  I know that this is a bad practice.  Do you see that this may be the issue with DPA reporting the above?  I plan to allocate 80% to SQL and leaving 20% of total memory for OS.  Please advise if you have any information or encountered this before.  Thanks in advance.

Brian Tran