SQL failover cluster instance
The following example shows a component configuration in JSON format for SQL failover cluster instance.
{ "subComponents" : [ { "subComponentType" : "AWS::EC2::Instance", "alarmMetrics" : [ { "alarmMetricName" : "CPUUtilization", "monitor" : true }, { "alarmMetricName" : "StatusCheckFailed", "monitor" : true }, { "alarmMetricName" : "Processor % Processor Time", "monitor" : true }, { "alarmMetricName" : "Memory % Committed Bytes In Use", "monitor" : true }, { "alarmMetricName" : "Memory Available Mbytes", "monitor" : true }, { "alarmMetricName" : "Paging File % Usage", "monitor" : true }, { "alarmMetricName" : "System Processor Queue Length", "monitor" : true }, { "alarmMetricName" : "Network Interface Bytes Total/sec", "monitor" : true }, { "alarmMetricName" : "PhysicalDisk % Disk Time", "monitor" : true }, { "alarmMetricName" : "Bytes Received/sec", "monitor" : true }, { "alarmMetricName" : "Normal Messages Queue Length/sec", "monitor" : true }, { "alarmMetricName" : "Urgent Message Queue Length/se", "monitor" : true }, { "alarmMetricName" : "Reconnect Count", "monitor" : true }, { "alarmMetricName" : "Unacknowledged Message Queue Length/sec", "monitor" : true }, { "alarmMetricName" : "Messages Outstanding", "monitor" : true }, { "alarmMetricName" : "Messages Sent/sec", "monitor" : true }, { "alarmMetricName" : "Database Update Messages/sec", "monitor" : true }, { "alarmMetricName" : "Update Messages/sec", "monitor" : true }, { "alarmMetricName" : "Flushes/sec", "monitor" : true }, { "alarmMetricName" : "Crypto Checkpoints Saved/sec", "monitor" : true }, { "alarmMetricName" : "Crypto Checkpoints Restored/sec", "monitor" : true }, { "alarmMetricName" : "Registry Checkpoints Restored/sec", "monitor" : true }, { "alarmMetricName" : "Registry Checkpoints Saved/sec", "monitor" : true }, { "alarmMetricName" : "Cluster API Calls/sec", "monitor" : true }, { "alarmMetricName" : "Resource API Calls/sec", "monitor" : true }, { "alarmMetricName" : "Cluster Handles/sec", "monitor" : true }, { "alarmMetricName" : "Resource Handles/sec", "monitor" : true } ], "windowsEvents" : [ { "logGroupName" : "WINDOWS_EVENTS-Application-<RESOURCE_GROUP_NAME>", "eventName" : "Application", "eventLevels" : [ "WARNING", "ERROR", "CRITICAL"], "monitor" : true }, { "logGroupName" : "WINDOWS_EVENTS-System-<RESOURCE_GROUP_NAME>", "eventName" : "System", "eventLevels" : [ "WARNING", "ERROR", "CRITICAL", "INFORMATION" ], "monitor" : true }, { "logGroupName" : "WINDOWS_EVENTS-Security-<RESOURCE_GROUP_NAME>", "eventName" : "Security", "eventLevels" : [ "WARNING", "ERROR", "CRITICAL" ], "monitor" : true } ], "logs" : [ { "logGroupName" : "SQL_SERVER_FAILOVER_CLUSTER_INSTANCE-<RESOURCE_GROUP_NAME>", "logPath" : "\\\\amznfsxjmzbykwn.mydomain.aws\\SQLDB\\MSSQL**.MSSQLSERVER\\MSSQL\\Log\\ERRORLOG", "logType" : "SQL_SERVER", "monitor" : true, "encoding" : "utf-8" } ] }, { "subComponentType" : "AWS::EC2::Volume", "alarmMetrics" : [ { "alarmMetricName" : "VolumeReadBytes", "monitor" : true }, { "alarmMetricName" : "VolumeWriteBytes", "monitor" : true }, { "alarmMetricName" : "VolumeReadOps", "monitor" : true }, { "alarmMetricName" : "VolumeWriteOps", "monitor" : true }, { "alarmMetricName" : "VolumeQueueLength", "monitor" : true }, { "alarmMetricName" : "VolumeThroughputPercentage", "monitor" : true }, { "alarmMetricName" : "BurstBalance", "monitor" : true } ] } ] }