PlanWise Performance: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 6: | Line 6: | ||
SQL Server version | SQL Server version | ||
PlanWise settings that control how many alternatives that are evaluated | PlanWise settings that control how many alternatives that are evaluated | ||
==Hardware== | |||
====TPG time depends mainly on the processor==== | |||
==SQL Server version== | |||
When using the report generator, SQL Select-queries are created and run on the SQL Server instance you have installed. There are large performance difference between the free SQL Server Express editions, and the Standard edition. SQL Server Standard allows for multiple CPU:s and 128GB of RAM usage, while Express is limited to one cpu and 1GB RAM. Express has a bulit-in database limit of 10GB database size, while Standard edition has no such limit. This may actually prevent you from using the Express edition for large problems. There are also differences between versions. In a test we made, execution times were decreased to 50-60% in version 2016 compared to version 2014. | |||