For reasons outside the scope of this question, I need to deploy a specific database from my main server to a secondary server; the problem I have is that the secondary server does not exist yet and I need to purchase it.
The thing is, how can I measure the CPU, IO and Memory used by this specific database in order to buy a server capable of handling the load of this specific database in the same (or less) time than the current server?
Any guidance on this topic is greatly appreciated.
