The problem is following. I have 2 SQL servers 2012 instances in two different virtual machines, let's call it DEV and PROD. When running a very simple parameterized query returning one row from one table with identical data structure, content, and query execution plans, the profiler in PROD shows much higher reads (like 15 times) and duration (5 times) than in DEV. Note, that PROD machine is 2 times more powerful than DEV.
Some days ago, it was the same, but then something happened, and it all went like this. No changes to data structure has been done. Indexes and statistics are up to date in both. Execution plans are identical in DEV and PROD.
So, i exclude SQL server as a reason. Apart from it, what can cause such behavior?
