Run the below command to enabled detailed monitoring on a running EC2 Instance aws ec2 monitor-instances –instance-ids INSTANCEID Disable detailed
Continue reading![](https://i0.wp.com/awsbytes.com/wp-content/uploads/2020/07/ENABLE-DETAILED-MONITORING.jpg?resize=850%2C384&ssl=1)
Run the below command to enabled detailed monitoring on a running EC2 Instance aws ec2 monitor-instances –instance-ids INSTANCEID Disable detailed
Continue readingStep1: Stop the EC2 Instance: aws ec2 stop-instances –instance-ids INSTANCEID Step2: Set sriov-net-support to ‘simple’. aws ec2 modify-instance-attribute –instance-id INSTANCEID
Continue readingBy default the ‘DeleteOnTermination’ attribute of an EBS backed EC2 Instance is ‘True’. Root volume can be preserved on termination
Continue readingUse the below command to cancel a spot instance request where REQUESTID is the request id of the spot instance.
Continue readingYou can use one of the below commands to list all running spot instances. aws ec2 describe-instances –filters “Name=instance-lifecycle,Values=spot” aws
Continue readingRun the below command to perform full vacuum of a table to 95%.
Continue readingSyntax to create materialized view: create materialized view mv_name as (select statement); Syntax to refresh materialized view: REFRESH MATERIALIZED VIEW
Continue readingSyntax to create a view: create view viewname as (select statement );
Continue readingBelow is the syntax to drop a group from the Redshift databases where groupname is the name of the group
Continue readingBelow is the syntax to rename a group in Redshift database: ALTER GROUP groupname RENAME TO new_groupname;
Continue reading