We are going to discuss the below questions in a detailed
Manner
Can you provide the checklist for MI installation?
2. What are the post-MI installation configurations?
3. What kind of applications can you migrate to MI? Would you suggest MI for critical applications?
4. Can you explain the service tiers critical/business?
5. Can you please explain about Gen-5?
6. How many components/services can be created upon MI configuration?
7. What is the default port? Will you connect using a public IP? How do you connect MI with a private or local IP?
8. How much time will it take to stop and restart the services?
9. I have a requirement; I want to install 5 MI instances. What is your approach?
10. I have 2 domains (A, B). How do you enable connectivity between MI and domain VMs?
11. How do you choose the network/subnet for MI during the installation, and who will configure it?
12. How do you configure a remote connection for VPN? What is the best VPN for MI?
13. What are the authentication modes?
14. How do you put the database in single-user mode?
15. If the database is corrupted, how do you repair it?
16. Is there any performance issue with General Purpose?
17. What is the max log file size for General Purpose? How many log files can be created? If the log file is full, what will you do?
18. Do you see any tempdb space issues?
19. What is the best migration method (1 TB) from on-premises to MI with 2 hours of downtime? What challenges did you face during the migration?
20. Suppose the database size is 500 GB and there are 3500 connections per minute. Can you suggest the configuration? Will you configure in memory?
21. What are the performance issues in MI?
22. If you run a query on-premises and MI, is the performance the same on MI?
23. How do you monitor MI? If the server is running slowly, how do you troubleshoot?
24. How do you enable ticketing tools (P1, P2, P3, and P4)?
25. How do you take a backup on MI and restore it on-premises?
26. Did you add any MI?
27. What are the recovery models for MI? Why not log backup?
28. How do you configure SSIS packages?
29. How do you deploy the SQL code (100+ scripts, monthly)?