Answers: <p>I don't have a SQL Server on AWS to check, but you could see if it's in <a href="https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/xp-msver-transact-sql?view=sql-server-2017" rel="nofollow noreferrer">xp_msver</a>, or figure it out from <code>ProcessorCount</code>, <code>ProcessorType</code> and <code>PhysicalMemory</code> in that sproc. </p>
  
Answers: CC BY-SA 4.0
Answers: 2019-05-12T12:07:09.540Z
Answers: 2019-05-12T12:07:09.540Z
Answers: Gaius
Body: <p>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)</p>
  
Tags: <amazon-rds><sql>
Title: Is there a way to acquire metadata about an Amazon RDS database instance using only SQL?
UserDisplayName: Triynko
ThreadText: # Is there a way to acquire metadata about an Amazon RDS database instance using only SQL?
  
  (Asked by: username_0 on 2019-05-09)
  
  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)
  
  **Tags:** amazon-rds, sql
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2019-05-12. Score: 1
  
  I don't have a SQL Server on AWS to check, but you could see if it's in [xp\_msver](https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/xp-msver-transact-sql?view=sql-server-2017), or figure it out from `ProcessorCount`, `ProcessorType` and `PhysicalMemory` in that sproc.
  
  
  ---
  
  