<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>

CC BY-SA 4.0
2019-05-12T12:07:09.540Z
2019-05-12T12:07:09.540Z
Gaius
<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>

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


---

