Skip to main content

lacework-global-820

6.3.6 Set '3625 (trace flag)' database flag for all Cloud SQL Server instances to 'on' (Automated)​

Description​

Best practices recommend setting 3625 (trace flag) database flag for Cloud SQL on SQL Server instance to on.

Remediation​

From Console:

  1. Go to the Cloud SQL Instances page in the Google Cloud Console by visiting: https://console.cloud.google.com/sql/instances.
  2. Select the SQL Server instance for which you want to enable to database flag.
  3. Click Edit.
  4. Scroll down to the Flags section.
  5. To set a flag that is new to the instance, click Add item, choose the flag 3625 from the drop-down menu, and set its value to on.
  6. Click Save to save your changes.
  7. Confirm your changes under Flags on the Overview page.

From Command Line:

  1. Configure the 3625 database flag for every Cloud SQL on SQL Server database instance using the below command.
gcloud sql instances patch <instance_name> --database-flags="3625"=on
info

This command overwrites all database flags previously set. To keep those and add new ones, include the values for all flags you want set on the instance; any flag not specifically included uses the default value. For flags that do not take a value, specify the flag name followed by an equals sign ("=").

References​

https://cloud.google.com/sql/docs/sqlserver/flags
https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-traceon-trace-flags-transact-sql?view=sql-server-ver15#trace-flags
https://github.com/ktaranov/sqlserver-kit/blob/master/SQL%20Server%20Trace%20Flag.md

Additional Information​

WARNING: This patch modifies database flag values, which may require you to restart your instance. The list of supported flags is on this page, along with details of which flags require a restart: https://cloud.google.com/sql/docs/sqlserver/flags.

info

Some database flag settings can affect instance availability or stability, and remove the instance from the Cloud SQL Service-Level Agreement (SLA). For information about these flags, see Operational Guidelines.

info

Configuring the preceding flag restarts the Cloud SQL instance.

Last updated on