8

"SqlTracingAllowed" setting in service tier is not not enabling SQL Tracing for OnPrem Dynamics 365 Business Central.


Since Debugger.EnableSqlTrace is supported in OnPrem and when using this feature we are now getting "Sorry, we can't proceed with the operation for app 'xxxxxxx' by 'yyyyy' for tenant 'default' because the app doesn’t meet our Universal Code requirement." error. Can you please make "SqlTracingAllowed" setting in the service tier (ie Get-NAVServerConfiguration) to enable / disable SQL tracing and make this property turned on as default as this feature is a must have feature to troubleshoot performance for Business Central.

STATUS DETAILS
Needs Votes
Ideas Administrator

Thank you for this suggestion! Currently this is not on our roadmap. We are tracking this idea and if it gathers more votes and comments we will consider it in the future. Best regards, Business Central Team

Comments

R

Hi all,I just wanted to bump this once more, because I also believe that this feature is basically mandatory when doing any kind of performance tuning where blocks between different processes are involved.Without it, it is extremely cumbersome to identify the process that holds a lock on a ressource and makes analyzing it a huge timesink.I also wanted to mention that via Application insights, this feature is.. kind of there still? You can get the Callstack of the blocking process, but only if the process that runs into the lock timeout is on the same service tier as the blocking process.In an environment with multiple service tiers this is useless, as we do not know the process that holds the lock, and the sql tracing allowed us to quickly identify the process by simply turning it on and activate the "Debugger.EnableSqlTrace" for all sessions.Best regards,Stefan

Category: Tenant Administration

R

"SQL Tracing" turned out to be an essential feature to support many busy and big live installations especially with LS Retail customers. Microsoft needs to fix this bug / issue for partners like us to support them better especially to improve performance, concurrency and scalability to give better customer and user experience using Business Central.

Category: Tenant Administration