SQL Server 2012 Performance Test I've been given a task to test where an SQL Server 2012 can achieve better performances - we have two options:


Use the SQL Server as an On-Premise machine (Standalone server that we have)
Use the SQL Server as a cloud-based server.


What is the best way to check which option gets better performance for our needs? (CPU + I/O performances), is there any recommended benchmark tool I can use? I thought about writing some SQL queries of various types and run them against both options, but I'm not sure which queries I should use.

Are there any recommended  type of queries that can give some good glance about the performance?
I would say using a local server would be better. At least that way you know the hardware and can simulate it as close to the production server as possible. With a cloud-based server you have no idea what the underlying hardware is, and with some services like Azure you will have to take the 3x write policy into account, different network connectivity, volume bursts for other activity within your "cloud", etc. So your performance picture will be quite different even if the hardware might be similar.