LIGHTWEIGHT_QUERY_PROFILING is enable on database level by default in SQL Server 2019 .
If I disable it , will there still be results in querying sys.dm_exec_query_profiles ?
I have tried to disable LIGHTWEIGHT_QUERY_PROFILING , but there is still results in dm_exec_query_profiles , is it normal ??