Appendix: SQL Server database migration questionnaire - AWS Prescriptive Guidance

Appendix: SQL Server database migration questionnaire

Use the questionnaire in this section as a starting point to gather information for the assessment and planning phases of your migration project. You can download this questionnaire in Microsoft Excel format and use it to record your information.

Download questionnaire

General information

  1. What is the name of your SQL Server instance?

  2. What is the version of your SQL Server?

  3. What is the edition of your SQL Server database: Standard, Developer, or Enterprise?

  4. What is the database type (OLTP, DW, reporting, batch processing)?

  5. How many databases do you have on the SQL Server instance?

  6. What is the size of your database?

  7. What is the database collation?

  8. What is the time zone of the database?

  9. What are the average and maximum I/O transactions per second (TPS)?

  10. What is the IOPS (on average and maximum) for this database for read/write operations?

  11. How many transaction logs do you generate per hour (with average and maximum size)?

  12. Does the database have linked servers pointing to other databases?

  13. What are the SLA requirements for your database?

  14. What is the RTO and RPO requirements for your database?

  15. How much database downtime can you allow for migration purposes?

  16. Do you have any compliance, regulatory, or auditing requirements?

  17. What tool do you use to monitor your SQL Server databases?

Infrastructure

  1. What is the hostname of the database?

  2. What is the operating system used for this database?

  3. How many CPU cores does the server have?

  4. What is the memory size on the server?

  5. Is the database on a virtualized machine or a physical server?

  6. Are you using local storage?

  7. Do you use network-attached storage (NAS) or storage area network (SAN) storage types?

  8. Do you have a cluster or single instances?

Database backups

  1. How do you back up your database? How often?

  2. What is your retention period for transaction logs and backups?

  3. Where do you store your backup?

Database features

  1. Do you use automatic tuning for your SQL Server instance?

  2. Do you use parallel-indexed operations?

  3. Do you use partitioned table parallelism features?

  4. Do you use table and index partitioning?

Database security

  1. Do you use dynamic data masking?

  2. Do you use security features such as Transparent Database Encryption (TDE)?

  3. Do you use server or database audits?

  4. Do you use advanced compression?

Database high availability and disaster recovery

  1. What are your high availability requirements?

  2. Do you use transactional replication?

  3. Do you use peer-to-peer transactional replication?

  4. What type of high availability solutions (for example, failover clustering, Always On availability groups, database mirroring) do you use for your SQL Server environment?

  5. Where are your primary and standby database regions?

  6. What do you use as a disaster recovery solution (for example, log shipping, Always On availability groups, a SAN-based virtualized environment)?

  7. Do you use a Domain Name System (DNS) alias for database connectivity?