July 30, 2012 at 5:15 am
Hi,
I've a Win Server 2008 machine on which SQL Server 2008 is installed.
Now I need to reduce the No. of CPUs on the machine using MSCONFIG -> Boot options.
Will this create any issue on SQL Server... this is a testing env. and I cant afford issues in SQL server.
Thanks,
Raj
August 6, 2012 at 7:31 am
In general, this should not cause you any problems.
However, if your Production environment relies on parallelism and you cannot get the same degree of parallelism in your test environment, then you will see different access plans and it can be difficault to explain to an auditor why these differences exist.
If you just run with very few cores (or only 1 core) on your test environment and multiple cores on Production, you can easily get what are called 'timing issues' in Production. This is where individual queries that can only execute one after each other in test can execute simultaneously in Production, and give you unexpected results.
Note that parallelism within a query and serialisation of multiple queries are different things.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply