System Architecture

1. Please describe the topology of the system overall. You may describe using both, Logical Topology and also Physical Topology.
2. How many Application being involved?
3. How many Databases being used?
4. Do you have any DR Site to backup the current system?
5. What Operating System is mostly being used?
6. What Programming Languages is mostly being implemented?
7. How many physical servers are involved in this assessment?

Application Side

1. Please describe the architecture of each application.
2. Please describe the hardware specification for the each application
   1. Processor type and Number of Cores
   2. Number of Memory
   3. Storage Type, Model, and Construction
   4. Network/Bandwidth Capacity
3. Is the application made specially (customized) or off the shelf product?
4. What is the application name and who develops the application?
5. What is the application type? (i.e. Web apps/Desktop/Mobile Apps/Web Service/etc)
6. Do you have access to the latest working application source code?
7. How many transactions per second (TPS) does the application handle in current condition?
8. How many users does the application handle in current condition?
9. How many concurrent users does the application handle in current condition?
10. Does the application support the High Availability mechanism?
11. Does the application support Load-balancing mechanism?
12. Please tell a brief about application business process and the purpose
13. Please describe what protocol being used for application? (i.e. HTTP - JSON/AJAX/Websocket/RESTFUL API/SOAP XML/JMS/Binary ISO-8553/Binary proprietary/SMTP/XML - RPC/etc.)
14. What is the application type? (i.e. financial related transaction/inventory or resource management/Workflow or Business process/Reporting related/SAP/Monitoring or Logging/etc.)
15. What is the application that integrates with this application?
16. Does the application interact with humans or machines?
17. What are the dependencies of the application? (i.e. SSO server/mailing system/social media/etc.)
18. What library application is used? (i.e. Encryption/Compression/specific driver for specific hardware/special input/output (camera,fingerprint, barcode, laser, smart card/etc.)
19. What authentication mechanism is used by the application?
20. What RDBMS-es are accessed by the application?
21. What is the connection behaviour/mechanism (pooling/keep-alive) from application to database?
22. Does the application need persistence connection ?

Database Side

1. How is the implementation detail? Explain in database architecture / topology (i.e. Clusters, Replication, Monitors, High Availability)
2. What current TPS can be achieved on the database?
3. Please describe the current environment on the database server:
   1. Processor type and Number of Cores
   2. Memory
   3. Storage Type, Speed, and Layout
   4. Network/Bandwidth
4. Describe the current server type? (i.e. Virtual or dedicated)
5. Describe the file system ( i.e. SAN or NFS)
6. Describe the database load behaviour (i.e. peak time on end of month, peak time on day time, etc)
7. Describe the current database size.
8. Describe how many databases and tables are in the current instance
9. Is there any specific method which has been implemented for the Backup and Restore mechanism? Please explain
10. Do you have a DBA Team for daily operations?
11. Do you have a monitoring system for the database?
12. How old the database has been implemented in production?
13. Do you also have a Data Warehouse system?
14. What is the data retention policy?
15. How many store procedures?
16. How many lines of code do you have?

Submit