I've been tasked with migrating a database and I want to figure out how much resource in terms of CPU and IO does that database need before migrating it. The target server to which the database is planned to be moved to is critical and I want to figure out if the target server can handle the load that the new db brings. Things which I am considering
- Use plan cache to find the IO and CPU, but I am not sure how to translate to real CPU and IO usage on the server.
- Use profiler/extended events to track activities on the DB. NOt sure how to translate it to real CPU / IO usage
What is the normal things to do in such situation?