Monday, 1 July 2013

Exchange Server Sizing with Quest MessageStats

Anyone who works with any version of Microsoft Exchange Server will know how important it is to correctly size your infrastructure.  One of the key considerations are your mailbox user profiles - the number of users, how many messages they are sending and receiving each day, and the average size of those messages.  These numbers are usually entered into the Exchange Server sizing tool to help estimate the capacity of the server.

As I worked on our upgrade from Exchange 2010 to Exchange 2013 we needed to gather information about our users. Fortunately, we have Quest MessageStats gathering data on our Exchange environment. Unfortunately, there is no out-of-the-box report to provide the exact data, but I was able to get what I needed with a custom SQL script.

Below is the SQL query I came up with to get data from MessageStats in the format I needed.