All we need is an easy explanation of the problem, so here it is.
I am looking for business reasons to upgrade from Express to Standard. as per my question here
Does SQL Server store internally any information about when it is held up due to edition / licensing features such as number of available cores?
What queries could I run to find this out?
How to solve :
I know you bored from this bug, So we are here to help you! Take a deep breath and look at the explanation of your problem. We have many solutions to this problem, But we recommend you to use the first method because it is tested & true method that will 100% work for you.
SQL Server isn’t going to tell you specifically that there is a performance limitation due to it being Express Edition. But in general, if you start collecting and monitoring wait statistics, you’ll see whether there are any bottlenecks due to insufficient CPU or memory. So if you’ve given SQL Server Express the max number of CPUs and memory, then bottlenecks in these areas generally indicate that it’s being limited by the limitations of the edition. Technically, you could give it faster processors to help overcome the CPU limiation, but I assume that’s not an option.
See SQL Server Wait Statistics: Tell me where it hurts to get started understanding what you need to be monitoring.
Note: Use and implement method 1 because this method fully tested our system.
Thank you 🙂