Page Comparison

For MS SQL Server, follow these steps:

1. Open a command shell cmd.exe>sqlcmd -S

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

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

   command:
   select name AS DBName,

   commands

   Code Block
   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_

   <your workspace>

   name>'

   
   

   go

   
   

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