Docs Home Pulumi IaC Pulumi ESC Pulumi Insights Pulumi Cloud Packages Tutorials
  1. Packages
  2. Tencentcloud Provider
  3. API Docs
  4. SqlserverStartXevent
tencentcloud 1.81.183 published on Wednesday, Apr 16, 2025 by tencentcloudstack
tencentcloudstack/terraform-provider-tencentcloud

tencentcloud.SqlserverStartXevent

Explore with Pulumi AI

tencentcloud logo
tencentcloud 1.81.183 published on Wednesday, Apr 16, 2025 by tencentcloudstack
tencentcloudstack/terraform-provider-tencentcloud

    Provides a resource to create a sqlserver start_xevent

    Example Usage

    import * as pulumi from "@pulumi/pulumi";
import * as tencentcloud from "@pulumi/tencentcloud";

const zones = tencentcloud.getAvailabilityZonesByProduct({
    product: "sqlserver",
});
const vpc = new tencentcloud.Vpc("vpc", {cidrBlock: "10.0.0.0/16"});
const subnet = new tencentcloud.Subnet("subnet", {
    availabilityZone: zones.then(zones => zones.zones?.[4]?.name),
    vpcId: vpc.vpcId,
    cidrBlock: "10.0.0.0/16",
    isMulticast: false,
});
const securityGroup = new tencentcloud.SecurityGroup("securityGroup", {description: "desc."});
const exampleSqlserverBasicInstance = new tencentcloud.SqlserverBasicInstance("exampleSqlserverBasicInstance", {
    availabilityZone: zones.then(zones => zones.zones?.[4]?.name),
    chargeType: "POSTPAID_BY_HOUR",
    vpcId: vpc.vpcId,
    subnetId: subnet.subnetId,
    projectId: 0,
    memory: 4,
    storage: 100,
    cpu: 2,
    machineType: "CLOUD_PREMIUM",
    maintenanceWeekSets: [
        1,
        2,
        3,
    ],
    maintenanceStartTime: "09:00",
    maintenanceTimeSpan: 3,
    securityGroups: [securityGroup.securityGroupId],
    tags: {
        test: "test",
    },
});
const exampleSqlserverStartXevent = new tencentcloud.SqlserverStartXevent("exampleSqlserverStartXevent", {
    instanceId: exampleSqlserverBasicInstance.sqlserverBasicInstanceId,
    eventConfigs: [{
        eventType: "slow",
        threshold: 0,
    }],
});

    import pulumi
import pulumi_tencentcloud as tencentcloud

zones = tencentcloud.get_availability_zones_by_product(product="sqlserver")
vpc = tencentcloud.Vpc("vpc", cidr_block="10.0.0.0/16")
subnet = tencentcloud.Subnet("subnet",
    availability_zone=zones.zones[4].name,
    vpc_id=vpc.vpc_id,
    cidr_block="10.0.0.0/16",
    is_multicast=False)
security_group = tencentcloud.SecurityGroup("securityGroup", description="desc.")
example_sqlserver_basic_instance = tencentcloud.SqlserverBasicInstance("exampleSqlserverBasicInstance",
    availability_zone=zones.zones[4].name,
    charge_type="POSTPAID_BY_HOUR",
    vpc_id=vpc.vpc_id,
    subnet_id=subnet.subnet_id,
    project_id=0,
    memory=4,
    storage=100,
    cpu=2,
    machine_type="CLOUD_PREMIUM",
    maintenance_week_sets=[
        1,
        2,
        3,
    ],
    maintenance_start_time="09:00",
    maintenance_time_span=3,
    security_groups=[security_group.security_group_id],
    tags={
        "test": "test",
    })
example_sqlserver_start_xevent = tencentcloud.SqlserverStartXevent("exampleSqlserverStartXevent",
    instance_id=example_sqlserver_basic_instance.sqlserver_basic_instance_id,
    event_configs=[{
        "event_type": "slow",
        "threshold": 0,
    }])

    package main

import (
	"github.com/pulumi/pulumi-terraform-provider/sdks/go/tencentcloud/tencentcloud"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		zones, err := tencentcloud.GetAvailabilityZonesByProduct(ctx, &tencentcloud.GetAvailabilityZonesByProductArgs{
			Product: "sqlserver",
		}, nil)
		if err != nil {
			return err
		}
		vpc, err := tencentcloud.NewVpc(ctx, "vpc", &tencentcloud.VpcArgs{
			CidrBlock: pulumi.String("10.0.0.0/16"),
		})
		if err != nil {
			return err
		}
		subnet, err := tencentcloud.NewSubnet(ctx, "subnet", &tencentcloud.SubnetArgs{
			AvailabilityZone: pulumi.String(zones.Zones[4].Name),
			VpcId:            vpc.VpcId,
			CidrBlock:        pulumi.String("10.0.0.0/16"),
			IsMulticast:      pulumi.Bool(false),
		})
		if err != nil {
			return err
		}
		securityGroup, err := tencentcloud.NewSecurityGroup(ctx, "securityGroup", &tencentcloud.SecurityGroupArgs{
			Description: pulumi.String("desc."),
		})
		if err != nil {
			return err
		}
		exampleSqlserverBasicInstance, err := tencentcloud.NewSqlserverBasicInstance(ctx, "exampleSqlserverBasicInstance", &tencentcloud.SqlserverBasicInstanceArgs{
			AvailabilityZone: pulumi.String(zones.Zones[4].Name),
			ChargeType:       pulumi.String("POSTPAID_BY_HOUR"),
			VpcId:            vpc.VpcId,
			SubnetId:         subnet.SubnetId,
			ProjectId:        pulumi.Float64(0),
			Memory:           pulumi.Float64(4),
			Storage:          pulumi.Float64(100),
			Cpu:              pulumi.Float64(2),
			MachineType:      pulumi.String("CLOUD_PREMIUM"),
			MaintenanceWeekSets: pulumi.Float64Array{
				pulumi.Float64(1),
				pulumi.Float64(2),
				pulumi.Float64(3),
			},
			MaintenanceStartTime: pulumi.String("09:00"),
			MaintenanceTimeSpan:  pulumi.Float64(3),
			SecurityGroups: pulumi.StringArray{
				securityGroup.SecurityGroupId,
			},
			Tags: pulumi.StringMap{
				"test": pulumi.String("test"),
			},
		})
		if err != nil {
			return err
		}
		_, err = tencentcloud.NewSqlserverStartXevent(ctx, "exampleSqlserverStartXevent", &tencentcloud.SqlserverStartXeventArgs{
			InstanceId: exampleSqlserverBasicInstance.SqlserverBasicInstanceId,
			EventConfigs: tencentcloud.SqlserverStartXeventEventConfigArray{
				&tencentcloud.SqlserverStartXeventEventConfigArgs{
					EventType: pulumi.String("slow"),
					Threshold: pulumi.Float64(0),
				},
			},
		})
		if err != nil {
			return err
		}
		return nil
	})
}

    using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Tencentcloud = Pulumi.Tencentcloud;

return await Deployment.RunAsync(() => 
{
    var zones = Tencentcloud.GetAvailabilityZonesByProduct.Invoke(new()
    {
        Product = "sqlserver",
    });

    var vpc = new Tencentcloud.Vpc("vpc", new()
    {
        CidrBlock = "10.0.0.0/16",
    });

    var subnet = new Tencentcloud.Subnet("subnet", new()
    {
        AvailabilityZone = zones.Apply(getAvailabilityZonesByProductResult => getAvailabilityZonesByProductResult.Zones[4]?.Name),
        VpcId = vpc.VpcId,
        CidrBlock = "10.0.0.0/16",
        IsMulticast = false,
    });

    var securityGroup = new Tencentcloud.SecurityGroup("securityGroup", new()
    {
        Description = "desc.",
    });

    var exampleSqlserverBasicInstance = new Tencentcloud.SqlserverBasicInstance("exampleSqlserverBasicInstance", new()
    {
        AvailabilityZone = zones.Apply(getAvailabilityZonesByProductResult => getAvailabilityZonesByProductResult.Zones[4]?.Name),
        ChargeType = "POSTPAID_BY_HOUR",
        VpcId = vpc.VpcId,
        SubnetId = subnet.SubnetId,
        ProjectId = 0,
        Memory = 4,
        Storage = 100,
        Cpu = 2,
        MachineType = "CLOUD_PREMIUM",
        MaintenanceWeekSets = new[]
        {
            1,
            2,
            3,
        },
        MaintenanceStartTime = "09:00",
        MaintenanceTimeSpan = 3,
        SecurityGroups = new[]
        {
            securityGroup.SecurityGroupId,
        },
        Tags = 
        {
            { "test", "test" },
        },
    });

    var exampleSqlserverStartXevent = new Tencentcloud.SqlserverStartXevent("exampleSqlserverStartXevent", new()
    {
        InstanceId = exampleSqlserverBasicInstance.SqlserverBasicInstanceId,
        EventConfigs = new[]
        {
            new Tencentcloud.Inputs.SqlserverStartXeventEventConfigArgs
            {
                EventType = "slow",
                Threshold = 0,
            },
        },
    });

});

    package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.tencentcloud.TencentcloudFunctions;
import com.pulumi.tencentcloud.inputs.GetAvailabilityZonesByProductArgs;
import com.pulumi.tencentcloud.Vpc;
import com.pulumi.tencentcloud.VpcArgs;
import com.pulumi.tencentcloud.Subnet;
import com.pulumi.tencentcloud.SubnetArgs;
import com.pulumi.tencentcloud.SecurityGroup;
import com.pulumi.tencentcloud.SecurityGroupArgs;
import com.pulumi.tencentcloud.SqlserverBasicInstance;
import com.pulumi.tencentcloud.SqlserverBasicInstanceArgs;
import com.pulumi.tencentcloud.SqlserverStartXevent;
import com.pulumi.tencentcloud.SqlserverStartXeventArgs;
import com.pulumi.tencentcloud.inputs.SqlserverStartXeventEventConfigArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;

public class App {
    public static void main(String[] args) {
        Pulumi.run(App::stack);
    }

    public static void stack(Context ctx) {
        final var zones = TencentcloudFunctions.getAvailabilityZonesByProduct(GetAvailabilityZonesByProductArgs.builder()
            .product("sqlserver")
            .build());

        var vpc = new Vpc("vpc", VpcArgs.builder()
            .cidrBlock("10.0.0.0/16")
            .build());

        var subnet = new Subnet("subnet", SubnetArgs.builder()
            .availabilityZone(zones.applyValue(getAvailabilityZonesByProductResult -> getAvailabilityZonesByProductResult.zones()[4].name()))
            .vpcId(vpc.vpcId())
            .cidrBlock("10.0.0.0/16")
            .isMulticast(false)
            .build());

        var securityGroup = new SecurityGroup("securityGroup", SecurityGroupArgs.builder()
            .description("desc.")
            .build());

        var exampleSqlserverBasicInstance = new SqlserverBasicInstance("exampleSqlserverBasicInstance", SqlserverBasicInstanceArgs.builder()
            .availabilityZone(zones.applyValue(getAvailabilityZonesByProductResult -> getAvailabilityZonesByProductResult.zones()[4].name()))
            .chargeType("POSTPAID_BY_HOUR")
            .vpcId(vpc.vpcId())
            .subnetId(subnet.subnetId())
            .projectId(0)
            .memory(4)
            .storage(100)
            .cpu(2)
            .machineType("CLOUD_PREMIUM")
            .maintenanceWeekSets(            
                1,
                2,
                3)
            .maintenanceStartTime("09:00")
            .maintenanceTimeSpan(3)
            .securityGroups(securityGroup.securityGroupId())
            .tags(Map.of("test", "test"))
            .build());

        var exampleSqlserverStartXevent = new SqlserverStartXevent("exampleSqlserverStartXevent", SqlserverStartXeventArgs.builder()
            .instanceId(exampleSqlserverBasicInstance.sqlserverBasicInstanceId())
            .eventConfigs(SqlserverStartXeventEventConfigArgs.builder()
                .eventType("slow")
                .threshold(0)
                .build())
            .build());

    }
}

    resources:
  vpc:
    type: tencentcloud:Vpc
    properties:
      cidrBlock: 10.0.0.0/16
  subnet:
    type: tencentcloud:Subnet
    properties:
      availabilityZone: ${zones.zones[4].name}
      vpcId: ${vpc.vpcId}
      cidrBlock: 10.0.0.0/16
      isMulticast: false
  securityGroup:
    type: tencentcloud:SecurityGroup
    properties:
      description: desc.
  exampleSqlserverBasicInstance:
    type: tencentcloud:SqlserverBasicInstance
    properties:
      availabilityZone: ${zones.zones[4].name}
      chargeType: POSTPAID_BY_HOUR
      vpcId: ${vpc.vpcId}
      subnetId: ${subnet.subnetId}
      projectId: 0
      memory: 4
      storage: 100
      cpu: 2
      machineType: CLOUD_PREMIUM
      maintenanceWeekSets:
        - 1
        - 2
        - 3
      maintenanceStartTime: 09:00
      maintenanceTimeSpan: 3
      securityGroups:
        - ${securityGroup.securityGroupId}
      tags:
        test: test
  exampleSqlserverStartXevent:
    type: tencentcloud:SqlserverStartXevent
    properties:
      instanceId: ${exampleSqlserverBasicInstance.sqlserverBasicInstanceId}
      eventConfigs:
        - eventType: slow
          threshold: 0
variables:
  zones:
    fn::invoke:
      function: tencentcloud:getAvailabilityZonesByProduct
      arguments:
        product: sqlserver

    Create SqlserverStartXevent Resource

    Resources are created with functions called constructors. To learn more about declaring and configuring resources, see Resources.

    Constructor syntax

    new SqlserverStartXevent(name: string, args: SqlserverStartXeventArgs, opts?: CustomResourceOptions);
    @overload
def SqlserverStartXevent(resource_name: str,
                         args: SqlserverStartXeventArgs,
                         opts: Optional[ResourceOptions] = None)

@overload
def SqlserverStartXevent(resource_name: str,
                         opts: Optional[ResourceOptions] = None,
                         event_configs: Optional[Sequence[SqlserverStartXeventEventConfigArgs]] = None,
                         instance_id: Optional[str] = None,
                         sqlserver_start_xevent_id: Optional[str] = None)
    func NewSqlserverStartXevent(ctx *Context, name string, args SqlserverStartXeventArgs, opts ...ResourceOption) (*SqlserverStartXevent, error)
    public SqlserverStartXevent(string name, SqlserverStartXeventArgs args, CustomResourceOptions? opts = null)
    public SqlserverStartXevent(String name, SqlserverStartXeventArgs args)
public SqlserverStartXevent(String name, SqlserverStartXeventArgs args, CustomResourceOptions options)

    type: tencentcloud:SqlserverStartXevent
properties: # The arguments to resource properties.
options: # Bag of options to control resource's behavior.

    Parameters

    name string
    The unique name of the resource.
    args SqlserverStartXeventArgs
    The arguments to resource properties.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    resource_name str
    The unique name of the resource.
    args SqlserverStartXeventArgs
    The arguments to resource properties.
    opts ResourceOptions
    Bag of options to control resource's behavior.
    ctx Context
    Context object for the current deployment.
    name string
    The unique name of the resource.
    args SqlserverStartXeventArgs
    The arguments to resource properties.
    opts ResourceOption
    Bag of options to control resource's behavior.
    name string
    The unique name of the resource.
    args SqlserverStartXeventArgs
    The arguments to resource properties.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    name String
    The unique name of the resource.
    args SqlserverStartXeventArgs
    The arguments to resource properties.
    options CustomResourceOptions
    Bag of options to control resource's behavior.

    SqlserverStartXevent Resource Properties

    To learn more about resource properties and how to use them, see Inputs and Outputs in the Architecture and Concepts docs.

    Inputs

    In Python, inputs that are objects can be passed either as argument classes or as dictionary literals.

    The SqlserverStartXevent resource accepts the following input properties:

    EventConfigs List<SqlserverStartXeventEventConfig>
    Whether to start or stop an extended event.
    InstanceId string
    Instance ID.
    SqlserverStartXeventId string
    ID of the resource.
    EventConfigs []SqlserverStartXeventEventConfigArgs
    Whether to start or stop an extended event.
    InstanceId string
    Instance ID.
    SqlserverStartXeventId string
    ID of the resource.
    eventConfigs List<SqlserverStartXeventEventConfig>
    Whether to start or stop an extended event.
    instanceId String
    Instance ID.
    sqlserverStartXeventId String
    ID of the resource.
    eventConfigs SqlserverStartXeventEventConfig[]
    Whether to start or stop an extended event.
    instanceId string
    Instance ID.
    sqlserverStartXeventId string
    ID of the resource.
    event_configs Sequence[SqlserverStartXeventEventConfigArgs]
    Whether to start or stop an extended event.
    instance_id str
    Instance ID.
    sqlserver_start_xevent_id str
    ID of the resource.
    eventConfigs List<Property Map>
    Whether to start or stop an extended event.
    instanceId String
    Instance ID.
    sqlserverStartXeventId String
    ID of the resource.

    Outputs

    All input properties are implicitly available as output properties. Additionally, the SqlserverStartXevent resource produces the following output properties:

    Id string
    The provider-assigned unique ID for this managed resource.
    Id string
    The provider-assigned unique ID for this managed resource.
    id String
    The provider-assigned unique ID for this managed resource.
    id string
    The provider-assigned unique ID for this managed resource.
    id str
    The provider-assigned unique ID for this managed resource.
    id String
    The provider-assigned unique ID for this managed resource.

    Look up Existing SqlserverStartXevent Resource

    Get an existing SqlserverStartXevent resource’s state with the given name, ID, and optional extra properties used to qualify the lookup.

    public static get(name: string, id: Input<ID>, state?: SqlserverStartXeventState, opts?: CustomResourceOptions): SqlserverStartXevent
    @staticmethod
def get(resource_name: str,
        id: str,
        opts: Optional[ResourceOptions] = None,
        event_configs: Optional[Sequence[SqlserverStartXeventEventConfigArgs]] = None,
        instance_id: Optional[str] = None,
        sqlserver_start_xevent_id: Optional[str] = None) -> SqlserverStartXevent
    func GetSqlserverStartXevent(ctx *Context, name string, id IDInput, state *SqlserverStartXeventState, opts ...ResourceOption) (*SqlserverStartXevent, error)
    public static SqlserverStartXevent Get(string name, Input<string> id, SqlserverStartXeventState? state, CustomResourceOptions? opts = null)
    public static SqlserverStartXevent get(String name, Output<String> id, SqlserverStartXeventState state, CustomResourceOptions options)
    resources:  _:    type: tencentcloud:SqlserverStartXevent    get:      id: ${id}
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    resource_name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    The following state arguments are supported:
    EventConfigs List<SqlserverStartXeventEventConfig>
    Whether to start or stop an extended event.
    InstanceId string
    Instance ID.
    SqlserverStartXeventId string
    ID of the resource.
    EventConfigs []SqlserverStartXeventEventConfigArgs
    Whether to start or stop an extended event.
    InstanceId string
    Instance ID.
    SqlserverStartXeventId string
    ID of the resource.
    eventConfigs List<SqlserverStartXeventEventConfig>
    Whether to start or stop an extended event.
    instanceId String
    Instance ID.
    sqlserverStartXeventId String
    ID of the resource.
    eventConfigs SqlserverStartXeventEventConfig[]
    Whether to start or stop an extended event.
    instanceId string
    Instance ID.
    sqlserverStartXeventId string
    ID of the resource.
    event_configs Sequence[SqlserverStartXeventEventConfigArgs]
    Whether to start or stop an extended event.
    instance_id str
    Instance ID.
    sqlserver_start_xevent_id str
    ID of the resource.
    eventConfigs List<Property Map>
    Whether to start or stop an extended event.
    instanceId String
    Instance ID.
    sqlserverStartXeventId String
    ID of the resource.

    Supporting Types

    SqlserverStartXeventEventConfig, SqlserverStartXeventEventConfigArgs

    EventType string
    Event type. Valid values: slow (set threshold for slow SQL ), blocked (set threshold for the blocking and deadlock).
    Threshold double
    Threshold in milliseconds. Valid values: 0(disable), non-zero (enable).
    EventType string
    Event type. Valid values: slow (set threshold for slow SQL ), blocked (set threshold for the blocking and deadlock).
    Threshold float64
    Threshold in milliseconds. Valid values: 0(disable), non-zero (enable).
    eventType String
    Event type. Valid values: slow (set threshold for slow SQL ), blocked (set threshold for the blocking and deadlock).
    threshold Double
    Threshold in milliseconds. Valid values: 0(disable), non-zero (enable).
    eventType string
    Event type. Valid values: slow (set threshold for slow SQL ), blocked (set threshold for the blocking and deadlock).
    threshold number
    Threshold in milliseconds. Valid values: 0(disable), non-zero (enable).
    event_type str
    Event type. Valid values: slow (set threshold for slow SQL ), blocked (set threshold for the blocking and deadlock).
    threshold float
    Threshold in milliseconds. Valid values: 0(disable), non-zero (enable).
    eventType String
    Event type. Valid values: slow (set threshold for slow SQL ), blocked (set threshold for the blocking and deadlock).
    threshold Number
    Threshold in milliseconds. Valid values: 0(disable), non-zero (enable).

    Package Details

    Repository
    tencentcloud tencentcloudstack/terraform-provider-tencentcloud
    License
    Notes
    This Pulumi package is based on the tencentcloud Terraform Provider.
    tencentcloud logo
    tencentcloud 1.81.183 published on Wednesday, Apr 16, 2025 by tencentcloudstack
    tencentcloudstack/terraform-provider-tencentcloud