We're going to be migrating a bunch of small servers (30 - 40) of random instances and such to a couple larger more robust servers.
I am curious to know of some good stats I can query to get an idea of how much the database is used, how heavy the usage is, etc... so I know how to plan for the server hardware and how many databases I can put on each server versus the amount of CPU/RAM we have available.
Basically, there are some cases where we have SQL databases that are lightly used by some applications and could easily be put together on the same server, but others in which they probably benefit from a dedicated environment (IE..heavy usage, etc)
So... any stats that would be beneficial for me to look at that people are aware of? Maybe a point in a good direction to read/look