But it stuck when run from application on the above simple query with the wait PREEMPTIVE_OS_QUERYREGISTRY for hours.
Just this specific query performance slow? Have you checked the query plan?
For more details about performance of SQL Server on Linux, see below tech docs:
Performance best practices and configuration guidelines for SQL Server on Linux;
Walkthrough for the performance features of SQL Server on Linux.
Best regards,
Cosmog Hong
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".