What is the Application DWShellDb ?

Question

What is the Application DWShellDb ?

P 20

I am exporting the SQLAudit logs of my standalone Dedicated SQL Pool to an Event Hub and in some of the audit logs, I see the field "application_name" with the value "DWShellDb". I can't find any further information about this application out there. Is this an internal traffic client? The only reference I can find to it on through Google is a couple of files in this repository: https://github.com/microsoft/Azure_Synapse_Toolbox

Thank you.

Anonymous

2023-12-22T09:34:57.7766667+00:00

@P We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Anonymous

2023-12-25T03:43:05.1533333+00:00

@P just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
P 20 Reputation points

2024-01-02T18:29:48.11+00:00

Hi @Anonymous , thank you for your answer and for checking in, my apologies for the late response - it was a holiday time in my country :)

It would be ideal to know definitively whether logs where "application_name: DWShellDb" are due to internal traffic so that our application could handle them more appropriately, compared to user-generated traffic. So I will try the Microsoft Support or Azure Synapse community to be sure. Thanks again!

Answer accepted by question author

0 additional answers

Your answer

Anonymous

2023-12-22T09:34:57.7766667+00:00

@P We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Anonymous

2023-12-25T03:43:05.1533333+00:00

@P just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
P 20 Reputation points

2024-01-02T18:29:48.11+00:00

Hi @Anonymous , thank you for your answer and for checking in, my apologies for the late response - it was a holiday time in my country :)

It would be ideal to know definitively whether logs where "application_name: DWShellDb" are due to internal traffic so that our application could handle them more appropriately, compared to user-generated traffic. So I will try the Microsoft Support or Azure Synapse community to be sure. Thanks again!

Answer 1

@P

Thanks for reaching out to Microsoft Q&A.

The “application_name” field in SQLAudit logs typically represents the name of the client application that executed the statement causing the audit event. However, the specific value “DWShellDb” does not appear to be widely documented.

The Azure Synapse Toolbox, which you found on GitHub, is a collection of tools and scripts to help manage and monitor Azure Synapse Analytics. However, it doesn’t provide specific information about “DWShellDb”.

It’s possible that “DWShellDb” could be an internal traffic client, or a system process related to Azure Synapse or the Dedicated SQL Pool. For a definitive answer, I would recommend reaching out to Microsoft Support or the Azure Synapse community.

Hope this helps. Do let us know if you any further queries.

Share via

What is the Application DWShellDb ?

0 additional answers

Your answer