HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

Is there a way to acquire metadata about an Amazon RDS database instance using only SQL?

Submitted by: @import:stackexchange-devops··
0
Viewed 0 times
acquiresqlwaydatabaseinstanceamazonaboutusingonlyrds

Problem

For example, if I have a SQL Server instance in RDS, and I have only a connection string to connect to the server, is there a sproc or some pre-configured tables I can access via SQL on the instance that would report the instance size string? (db.r5.xlarge)

Solution

I don't have a SQL Server on AWS to check, but you could see if it's in xp_msver, or figure it out from ProcessorCount, ProcessorType and PhysicalMemory in that sproc.

Context

StackExchange DevOps Q#8076, answer score: 1

Revisions (0)

No revisions yet.