---
title: "How to see the size of any database in SQL server?"  
description: "How to see the size of any database in SQL server?"  
author: "Ashutosh Patel"  
published: 2024-10-11  
updated: 2024-10-11  
canonical: https://www.mindstick.com/interview/33969/how-to-see-the-size-of-any-database-in-sql-server  
category: "mssql server"  
tags: ["mssql server", "sql server", "sql"]  
reading_time: 1 minute  

---

# How to see the size of any database in SQL server?

#### Size of Database in SQL Server

To view the size of any database created in SQL Server database, just use the below SQL command,

```plaintext
USE [YourDatabaseName]
GO
EXEC sys.sp_spaceused
```

![How to see the size of any database in SQL server?](https://www.mindstick.com/interviewquestion/35babf2f-3aa7-4cbb-bad5-bd0e3e7b07a9/images/8e9fbce1-1ddd-4524-805a-4a39fa2529f5.png)

## Answers

### Answer by Ashutosh Patel

#### Size of Database in SQL Server

To view the size of any database created in SQL Server database, just use the below SQL command,

```plaintext
USE [YourDatabaseName]
GO
EXEC sys.sp_spaceused
```

![How to see the size of any database in SQL server?](https://www.mindstick.com/interviewquestion/35babf2f-3aa7-4cbb-bad5-bd0e3e7b07a9/images/8e9fbce1-1ddd-4524-805a-4a39fa2529f5.png)


---

Original Source: https://www.mindstick.com/interview/33969/how-to-see-the-size-of-any-database-in-sql-server

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.