Programming Homework Help

1. How to troubleshoot database performance issues? Define how database knowledge was applied to resolve a complex issue. How different sources of information were used to identify and resolve an issue. What steps you take to increase performance.

2. How to troubleshoot a 3 tier web application. How would you check each layer to identify the problem and resolve it. Detail the approach and commands

Note: Please don’t use online information. Better to use personal and real time experiences.