How to determine current database space usage?

For MS SQL Server, follow these steps:

1. Open a command shell cmd.exe

2. Execute the following command using the actual values of the indicated variables in order to open an SQL prompt

   sqlcmd -S .\<instance> -U <user> -P <password>

   default values:

   • instance: NETX_SERVER_SQL
   • user: sa
   • password: netxnetx_123456

3. On the SQL prompt, execute following commands

   use netx_ef_<workspace_name>
   
   select name AS DBName, SQL_Server_Edition = serverproperty('Edition'), SQL_Server_Version = serverproperty('ProductVersion'), (CAST(FILEPROPERTY(name, 'SpaceUsed') AS INT) / 128.0) as SpaceUsedMB FROM sys.database_files WHERE type = 0 and name = 'NETX_<workspace_name>'
   
   go

4. The usage of the databases in the given instance is shown.