When we run an update against a table of 40k rows on a NT environment, it completes in 10 sec.
When the same update is executed on a Linux environment with the same # of records, it completes in 19 sec - nearly 100% drop in performance.
The explain plans are the same for both environments (NT and Linux)
I know it’s a very generic question but would appreciate if you could provide some pointers to why there is this difference and how I can diagnose and fix this. Thank you.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!