Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
The following questions are intended to help you identify and record the compute resources required to maintain operational database performance. This information is critical when planning your migration as well as discussing migration plans with your selected migration partner(s).
Workload Consistency
| Question | Answer |
|---|---|
| Does my database environment utilization change throughout the day? | |
| If Yes, which time(s) of day does activity peak? | |
| How long is the sustained peak activity period? | |
| Does my database environment utilization change throughout the week? | |
| If Yes, which day(s) of the week does activity peak? | |
| How long is the sustained peak activity period? | |
| Does my database environment utilization change throughout the month? | |
| If Yes, which time(s) of the month does activity peak? | |
| How long is the sustained peak activity period? | |
| Does my database environment utilization change throughout the year? | |
| If Yes, which month(s) of the year does activity peak? | |
| How long is the sustained peak activity period? |
Workload Type
| Question | Answer |
|---|---|
| Is my workload read-intensive, write-intensive, or hybrid of both? | |
| Are there any inbound or outbound linked database connection dependencies? | |
| Does my database use any file system mounts for data operations? | |
| How many dependent client applications are connected to my database? |
Peak Operational Periods
During peak operational periods...
| Question | Answer |
|---|---|
| How many cores are being utilized? | |
| What is the percentage of core utilization? | |
| What is the maximum amount of memory used by SGA? | |
| What is the maximum amount of memory used by PGA? | |
| What are the maximum IOPS required? | |
| What are the maximum storage throughput speeds? | |
| What is the maximum required network speed? | |
| What is the maximum number of concurrent active database connections? |
To discuss these answers with experienced migration partners and to learn more about identifying the ideal software and/or partner solutions for your migration, see our Oracle to Azure Postgres Migration Playbook