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 performances 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?
Any help or directions for this issue will be highly appreciated.