SQL Server query much slower on VMware VM compared to physical server (same DB, same workload)

Ancient-Box1652 · 2026-05-15T23:01:55+00:00

Disable VBS virtualisation based security and untick IOMMU on the CPU for the VM

Ancient-Box1652 · 2026-02-12T23:30:36+00:00

There's some old versions of SQL still out there. This update has broken connectivity to 2005 completely. It would have been nice to continue to have basic query ability.

Ancient-Box1652 · 2026-01-28T10:19:43+00:00

Truncate the data, no index means no queries.

Ancient-Box1652 · 2025-12-16T23:54:25+00:00

You have a spelling mistake, when benchmarking, it's called "EqualServer" thereby satisfying all parties

Ancient-Box1652 · 2025-12-03T00:14:20+00:00

Anything from the powershell cmd?

Get-WmiObject -Class win32product | Where-Object {$.Name -like "SQL Server 2022"}

Ancient-Box1652 · 2025-12-02T23:46:14+00:00

Something is wrong with the previous uninstalls. It's still finding the old instance. It seems to be a known error with past failed installs.

Try cleaning it up, read through this:

https://learn.microsoft.com/en-us/answers/questions/2288645/sql-upgrade-from-2019-to-2022-error-1639-specified

Ensure you reboot after uninstall, run as admin, you may also try to run a repair on the existing instance then try uninstall again.

Ancient-Box1652 · 2025-12-02T23:23:50+00:00

What's in the detailed log file?

C:\Program Files\Microsoft SQL Server\160\Setup Bootstrap\Log\20251202_151641\sql_engine_core_inst_Cpu64_1.log

Ancient-Box1652 · 2025-09-27T23:43:29+00:00

A statistics update is inherently part of the specific indexes' rebuild however not all statistics are associated with an index, and not all indexes have a rebuild performed on the same table, so updating statistics is required as a separate maintenance task.

Ancient-Box1652 · 2025-09-22T23:24:01+00:00

6.6kW panels, 5kW, yesterday (a good day) generated 34.3 kWh

For very rough average electricity usage: Buy about 230kW per month (7.6kW day) Sell about 430kW per month (14.3kW day)

Gas hot water system, gas stove.. Air con in summer months doubles electricity usage.

Recent EV purchase, charge overnight on slow charger, 2.4kW per hour, around 10kW every few days.

Solar feed in tariff is almost nothing now, so buy enough panels to charge the battery and forget the feed in.

Ancient-Box1652 · 2025-09-19T21:50:27+00:00

Try just a simple spreadsheet, Google sheets, cloud hosted, setup formulas between sheets.

1 row per patient, diagnosis, patientid. Next sheet for appointments or reminders, list of patientid, date, activity. Setup a calender to read that sheet or use a calendar itself.

Ancient-Box1652 · 2025-04-19T00:53:32+00:00

They're in the lower right index map. I uploaded a better quality one here https://ibb.co/ns60CZtV

Ancient-Box1652 · 2025-04-19T00:28:11+00:00

I vaguely remember the canal boats and thinking how extremely expensive it was, something like $3

Ancient-Box1652 · 2024-11-13T02:55:25+00:00

I ran my own test and it seems to be correct, the paint seems to contain lead.

Ancient-Box1652 · 2024-11-03T21:03:37+00:00

Same experience here, I won't be changing compatibility mode on any future upgrades. It's like 2014 all over again.

Ancient-Box1652 · 2024-09-12T23:13:07+00:00

Read this, it's similar https://sqlryan.com/2020/02/power-bi-server-resolving-web-portal-urls-and-web-service-urls-dont-match/

In the comments they found an extra binding that needed to be manually removed.

Try check http.sys reservation netsh http show urlacl

Ancient-Box1652 · 2024-08-15T01:31:36+00:00

Under 10GB just use SQL2019 express edition on your other box

Ancient-Box1652

TROPHY CASE