Checking database size and space

Applies to

All GN4 database servers

Frequency

Daily, before the production starts

Tool

Microsoft SQL Management Studio

Where

Start > Programs> SQL Server Management Studio -Microsoft SQL servers > your server > Management > SQL Server Logs:

Time required

5 minutes x server

Description

For each database, check the used space, and the free space.

Applies to

SQL database servers

Frequency

Weekly

Tool

SQL query analyzer

Where

Start-Programs-Microsoft SQL Server-Query analyzer

Time required

10 minutes

Description

•Get the number of articles in the editorial database

•Get the number of elements in the editorial database

•Get the number of carbon copies in the editorial database