1 réponse
- Le plus récent
- Le plus de votes
- La plupart des commentaires
0
One of the limitations of SQL Server Express edition is scale.
To be more precise, Express edition is limited to 4vCPUs and 1410 MB of RAM no matter the size instance.
This means that each time the buffer pool goes above 1Gb (75%) it will cause plan cache pressure, triggering plan evictions hence higher compilations. For more details on cache size management see this link.
Note "optimize for ad hoc workloads" should not be disabled. When disables SQL Server cannot take advantage of storing just a stub until the second execution, adding to the memory pressure.
répondu il y a 8 mois
Contenus pertinents
- demandé il y a un an
- demandé il y a un an
- demandé il y a 9 mois
- demandé il y a 4 mois
- AWS OFFICIELA mis à jour il y a 2 ans
- AWS OFFICIELA mis à jour il y a 2 ans
- AWS OFFICIELA mis à jour il y a 9 mois