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?