|
OriginalGriff wrote: The apps load maybe ten times faster?
Give it a few days.
|
|
|
|
|
There are some major differences between the two that result in the bulk of the performance improvements:
1) SQL Server Express 2012 is limited to using 1 GB of RAM and is single threaded
2) SQL Server Developer 2019 is the full blown SQL Server Enterprise 2019 with a developer only license and will use all memory and performs SQL Server specific thread management.
3) SQL Server Express (all versions) doesn't attempt to optimize queries before execution; SQL Server Professional and Enterprise have a rather good query optimizer.
You would have seen similar performance enhancements moving from SQL Express 2012 to SQL Enterprise 2012. The remaining performance improvements are the result of Microsoft improving SQL Server's performance in general.
Also, Microsoft did a ground up rewrite of SQL Server 2019 to make it run on Linux as well as Windows and in the process eliminated a lot of internal performance bottlenecks.
modified 23-Jun-22 10:01am.
|
|
|
|
|
Nice to know I'm not imagining it.
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
OriginalGriff wrote: The apps load maybe ten times faster?
I've been using it (2019 Dev) for a couple of years now in prod and never noticed performance gains over previous versions.
I'll run some tests and get back to you on that. I've been putting off installing a 2019 instance on my main dev system due to low disk space. This may be the determination of how soon I replace this non-upgradable tower and join the rest of you on 11.
"Go forth into the source" - Neal Morse
"Hope is contagious"
|
|
|
|
|
See obermd's response. I guess the earlier editions of Express were single threaded and only used 10MB of RAM whereas the new ones do not have that limitation. You were probably running commercial servers and so you were not subject to that limitation.
To err is human. Fortune favors the monsters.
|
|
|
|
|
Good catch - SQL Server Express was limited to 1 GB RAM. I've updated the post.
For SQL Server Express 2019:
16 cores (threads)
64 GB RAM max
SQL Server Express 2019 is far more powerful than 2012 was but still doesn't have the performance enhancements of SQL Server 2019 Standard or Enterprise.
|
|
|
|
|
I thought 10MB seemed small, but these days anything in the MB range seems generous to me so I didn't question it.
To err is human. Fortune favors the monsters.
|
|
|
|
|
OriginalGriff wrote: changing to the new Server instance was a single location change and all my apps switch over
That's why I tend to use an alias[^].
(Although it technically requires two changes, since there's a separate list of aliases for x86 and x64.)
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Doesn't express have memory and cpu core limitations that dev and the commercial editions don't? That would almost certainly explain it.
Personally I like testing on low memory, low cpu SQL because it forces me to optimize performance.
|
|
|
|
|
Referring to the backless sandals with strap over the base of the toes and a post between the first 2 toes...
Here in the north central US they are called flip flops. My mom called them zorries, my grandmother called them thongs.
I'm curious as to what name you use.
|
|
|
|
|
Round these parts, "thongs" go on a totally different body area and aren't normally seen in public ...
It's flip-flops for us. But please, not with socks.
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Yeah - thongs in Oz, too. Always scares the North American tourists.
cheers
Chris Maunder
|
|
|
|
|
And the Oz version of Durex doesn't do the same job either!
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
...or rubbers
My first naive trip to the US office (early 70s) I learned the hard way about asking for an eraser.
Software rusts. Simon Stephenson, ca 1994. So does this signature. me, 2012
|
|
|
|
|
If you're a British smoker, don't even think about asking a USian if you can "bum a fag".
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Birkenstocks (brand of flip flop) with socks is a standard fashion statement in Boulder, CO.
|
|
|
|
|
Remind me never to go there ...
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Quote: Round these parts, "thongs" go on a totally different body area and aren't normally seen in public ... Unsure |
Except maybe in Essex!
modified 6-Sep-22 21:01pm.
|
|
|
|
|
Red Neck Wing Tips
The most expensive tool is a cheap tool. Gareth Branwyn
JaxCoder.com
|
|
|
|
|
Teenslippers
|
|
|
|
|
It's called "Hawaii chappal" over here - no specific idea why, though
Happiness will never come to those who fail to appreciate what they already have. -Anon
|
|
|
|
|
It used to be thongs years ago, but flip-flops has largely replaced it because of the other meaning for thong.
|
|
|
|
|
Either "flip flops" or "things I refuse to wear".
|
|
|
|
|
What? The type of logic circuit?
|
|
|
|
|
In the days of vacuum tubes (valves for you right ponders) we called them triggers.
>64
Some days the dragon wins. Suck it up.
|
|
|
|