AWS RDS API Reference

AWS RDS API Reference

Some of the RDS API command usuage . Editable parameters list for SQL Server.

AWS RDS Options Group

aws rds  describe-option-group-options --engine-name sqlserver-se

AWS RDS SQLServer SE 12.0 Parameter Groups

aws rds describe-db-parameters --db-parameter-group-name default.sqlserver-se-12.0

AWS RDS Instance Details

aws rds describe-db-instances
aws rds describe-db-instances --db-instance-identifier ramblingsofraju-aws-prod

AWS RDS Options Group Options Result

aws rds  describe-option-group-options --engine-name sqlserver-se

Show entries

Search:

Description	EngineName	Name	gDescription	ApplyType	SettingName
SQLServer Database Mirroring	sqlserver-se	Mirroring
SQLServer Database Level Customer Backups and Restores	sqlserver-se	SQLSERVER_BACKUP_RESTORE	Specifies the IAM role ARN used by RDS to backup and restore to and from customer's S3 bucket(s)	DYNAMIC	IAM_ROLE_ARN
SQLServer Database Mirroring	sqlserver-se	Mirroring
SQLServer Database Level Customer Backups and Restores	sqlserver-se	SQLSERVER_BACKUP_RESTORE	Specifies the IAM role ARN used by RDS to backup and restore to and from customer's S3 bucket(s)	DYNAMIC	IAM_ROLE_ARN
SQLServer Database Mirroring	sqlserver-se	Mirroring
SQLServer Database Level Customer Backups and Restores	sqlserver-se	SQLSERVER_BACKUP_RESTORE	Specifies the IAM role ARN used by RDS to backup and restore to and from customer's S3 bucket(s)	DYNAMIC	IAM_ROLE_ARN

Showing 1 to 6 of 6 entries

Previous Next

AWS RDS SQLServer SE 12.0 Parameter Groups

aws rds describe-db-parameters --db-parameter-group-name default.sqlserver-se-12.0

Parameters Group Parameters Result

Show entries

Search:

Description	DataType	IsModifiable	Allowed	Value	ParameterName
Returns the resources and types of locks participating in a deadlock and also the current command affected.	boolean	true	0,1	0	1204
Disables lock escalation based on memory pressure, or based on number of locks. The SQL Server Database Engine will not escalate row or page locks to table locks.	boolean	true	0,1	0	1211
Returns the resources and types of locks that are participating in a deadlock and also the current command affected, in an XML format that does not comply with any XSD schema.	boolean	true	0,1	0	1222
Disables lock escalation based on the number of locks. However, memory pressure can still activate lock escalation.	boolean	true	0,1	0	1224
Disables parallel checking of objects by DBCC CHECKDB, DBCC CHECKFILEGROUP, and DBCC CHECKTABLE.	boolean	true	0,1	0	2528
Disable hardware compression for tape drivers.	boolean	false	0,1	0	3205
Suppress log entries for backup operations.	boolean	false	0,1	1	3226
Limits the amount of information returned in error messages.	boolean	false	0,1	0	3625
Controls multiple query optimizer changes previously made under multiple trace flags.	boolean	true	0,1	0	4199
Makes server-level metadata visible to application roles.	boolean	true	0,1	0	4616
Disables generation of a memory dump on the first occurrence of an out-of-memory exception in CLR integration.	boolean	true	0,1	0	6527
Enables a dedicated administrator connection (DAC) on SQL Server Express.	boolean	false	0,1	0	7806
Number of has buckets used by the internal access check result cache	integer	false	0-16384	0	access check cache bucket count
Number of entries used by the internal access check result cache	integer	false	0-2147483647	0	access check cache quota
Enable ad hoc distributed queries using OPENROWSET and OPENDATASOURCE	boolean	true	0,1	0	ad hoc distributed queries
Bind disk I/O to specified subset of CPUs	integer	false	-2147483648-2147483647	0	affinity i/o mask
Dynamically control CPU affinity	integer	false	-2147483648-2147483647	0	affinity mask
Enable the SQL Server Agent extended stored procedures on this serve	boolean	false	0,1	1	agent xps
Setting has no effect	boolean	false	0,1	0	allow updates
Default on whether to use compression during backups	boolean	false	0,1	1	backup compression default
Default on whether to use compression during backups	integer	true	0-86400	0	blocked process threshold (s)
Enable C2 auditing	boolean	true	0,1	0	c2 audit mode
Whether assemblies can be run by SQL Server	boolean	true	0,1	0	clr enabled
Enable contained databases authentication to create or attach contained databases to Database Engine without authenticating a login at the Database Engine level	boolean	true	0,1	0	contained database authentication
Threshold at which Microsoft SQL Server creates and runs parallel plans for queries	integer	true	0-32767	5	cost threshold for parallelism

Showing 1 to 25 of 76 entries

Previous Next

AWS RDS Instance Details

aws rds describe-db-instances
aws rds describe-db-instances --db-instance-identifier ramblingsofraju-aws-prod

Show entries

Search:

Instance Property	Value
PubliclyAccessible	FALSE
MasterUsername
MonitoringInterval	0
LicenseModel	license-included
VpcSecurityGroups/0/Status	active
VpcSecurityGroups/0/VpcSecurityGroupId
InstanceCreateTime
CopyTagsToSnapshot	TRUE
OptionGroupMemberships/0/Status	in-sync
OptionGroupMemberships/0/OptionGroupName
Engine	sqlserver-web
MultiAZ	FALSE
LatestRestorableTime
DBParameterGroups/0/DBParameterGroupName
DBParameterGroups/0/ParameterApplyStatus	in-sync

Showing 1 to 15 of 43 entries

Previous Next

References:

AWS RDS API Reference
http://docs.aws.amazon.com/AmazonRDS/latest/APIReference/API_Operations.html

You may also like...

Amazon RDS Information

Bulk Load Data Files in S3 Bucket into Aurora RDS

Launching AWS SQL Server RDS

Leave a Reply Cancel reply