How to enable query monitoring for SQL Server in Stackdriver console?

[BSA]

for a  Cloud SQL (SQL Server 2017 Express) instance, I need to find the query execution time through logs in stack-driver monitoring.

For mysql I am able to find out by following these steps and enable the logs in stack-driver.

https://cloud.google.com/community/tutorials/stackdriver-monitor-slow-query-mysql.

I'm able to set logs through this command for Mysql:

gcloud sql instances create cloudsql001 --zone us-central1-a --root-password= *D*EDFDFD --database-flags=log_output='FILE',slow_query_log=on,long_query_time=2

However when I create a instance in Cloud SQL with a SQL Server database, I am not sure how to enable query execution time logs to be captured in cloud logging, I am not able to get the correct flags, for enabling query execution time logs in stackdriver console for SQL Server.

Can anyone please help?

[BSA]

I want to know, how to integrate Microsoft Sql Server with google stack driver, so that the queries executed from sql server are monitored in stackdriver console?

[Igor Peshansky]

Hi. The flags you are using are specific to managed MySQL. Sadly, there's no option today to get slow query logs for managed SQL Server in Cloud Logging.

        Igor

--
© 2021 Google Inc. 1600 Amphitheatre Parkway, Mountain View, CA 94043
 
Email preferences: You received this email because you signed up for the Google Stackdriver Discussion Google Group (google-stackdr...@googlegroups.com) to participate in discussions with other members of the GoogleStackdriver community.
---
You received this message because you are subscribed to the Google Groups "Google Stackdriver Discussion Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-stackdriver-d...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-stackdriver-discussion/e12436cf-9edf-49ed-9833-9dfe23f40530n%40googlegroups.com.