You are the Database Administrator for the automated warehousing division of your organization. Your customers include large retailers such as Walmart, Target, Best Buy, JC Penny’s, and so on. The customers are starting to complain that when they input their orders’ into your Warehouse Management Portal, the input and output process is rather slow.

You as the DBA manage over 500 different databases with as many tables in each. Where would you begin to address these type of issues? How would you solve this type of problem?

Answer rating: 100% (QA)

Addressing performance issues in a complex database environment with hundreds of databases and tables requires a systematic and wellthoughtout approach Heres a stepbystep guide on how you can begin to ... View the full answer