I want to monitor all queries on ms sqlserver database.

How to see and trace microsoft sql server logs via tail command in linux?

I use the following command to see postgresql logs:

sudo tail -f /var/log/postgresql/postgresql-10-main.log

CodePudding user response：

I want to monitor all queries on ms sqlserver database.

SQL Server doesn't log all queries by default. You could do that with an extended event trace (perhaps filtered for long-running ones to avoid unwanted noise) or enable the query store for historical aggregate query stats.

CodePudding user response：

I use azure-data-studio profiler extension to tracing queries.