patternsqlMinor
Is there a way to acquire metadata about an Amazon RDS database instance using only SQL?
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.