Project Manager :Muscat Ophélie

Application support contact(s) ?

Business owner of the application including department name ?

Remote access requirements

Application support user or vendor's login needs db_owner access to the database for the application installation (remove after the installation) ?

What Authentication will be used by the application to connect to SQL Server(choice)?

Does the application require DBAs to create logins going forward?

Provide reasons if SYSADMIN server role is required for the day-to-day application functionality. Use minimal permissions principal?

List access requirements.

collation

Are there any additional security considerations?

Dependencies

Provide any dependencies on SQL Server features or services?

Compatibility AlwaysOn

compatibility SQL 2019?

Please provide vendor’s documentation

What is the initial database size?

Provide database growth rate: What amount of data in MB\GB\TB or in Rows changes daily/weekly/monthly (provide one)? How much data usually added each year (in MB\GB\TB)? Can you provide examples based on other customers statistics.

SQL Server CPU

Memory

Storage

When application setup is scheduled and will be completed. This is required to make sure that a DBA is available in case of any issues during the installation?

How should the database be initially created?

What is the suggested database name? Does application support a custom database name?

Do you need Auditing requirements ?

Connections strings and other database related application settings ?

Application operational information (For example: Automated processes run at night)

Are there any requirements to keep databases in sync with integrated system(s)?

Backup and Recovery requirements

todo