2024年3月20日发(作者:乾妙晴)
因是安装SQL Server 2000的机器上的CPU数(核心数)必须是2的幂,即2,4,
8,16,32,64 . . .
而双路6核服务器是12个核心,不是2的幂,因此报错。
SQL Server 2005也会面临同样的问题。
解决办法: 用–T3601 和 -T3603 参数来避免SMT检查,具体操作方法有两种,如
下:
信息来源:
/sqlserverfaq/archive/2009/05/27/info-sql-2000-msde-inst
allation-will-fail-if-you-have-number-of-cpus-on-a-box-which-is-not-in-power-of-
决议
METHOD 1:
方法1:
Start the installation in debug mode from command prompt by browsing to
the location of and using the following command:
在开始安装调试模式从命令提示符浏览地点的和使用下列命令:
安装媒体路径> < k = dbg
In case of SP4 installation :
如SP4安装:
Start the installation of SP4 in debug mode from command prompt by
browsing to the location of and using the following command:
在开始安装调试模式从SP4命令提示符浏览地点的和使用下列命令:
安装媒体路径> < k = dbg
Note: When you run setup in debug mode, the setup will prompt you for user
action to proceed on each step. Only when you click “OK” will it continue. This is
exactly what we want to do. We are pausing setup at the configuration step, while
we add the following trace flags in the registry and then continuing.
注意:当你运行安装在调试模式,为用户安装将促使你行动继续每一个步骤。只有当你点
击“OK”会继续下去。这正是我们想要做的事。我们暂停设定在配置步骤,而我们加入下
面微量旗帜在注册表中,然后继续。
Before configuring the server go ahead and added the trace flag –T3601 &
-T3603 in the registry by following the below steps:
配置服务器之前,先走一步,添加微量国旗在注册表中-T3601和-T3603遵循下面的步
骤:
1) Use trace flags 3601 and 3603 while the setup would be going on. Trace
flags 3601 and 3603 can be tried to avoid SMT checks and bypass problematic
code which checks the number of processors.
1)使用微量旗帜3601年和3603年将会在安装。3601年和3603年微量旗帜可以试
图避免SMT检查代码,绕过问题检查处理器数目。
2) Open regedit. Browse to the following location (for named instance, refer
method #2 for key location)
2)多谢开放。浏览下列位置(命名为实例,参考方法关键位置)2号
x86 servers:
HKEY_LOCAL_MACHINESOFTWAREMicrosoftMSSQLServerMSSQLServerPara
meters
服务器:HKEY_LOCAL_MACHINE 软件x86 Microsoft MSSQLServer 参
数MSSQLServer
X64 servers:
HKEY_LOCAL_MACHINESOFTWAREWOW6432nodeMicrosoftMSSQLServerMS
SQLServerParameters
服务器:HKEY_LOCAL_MACHINE 软件看 WOW6432node Microsoft
MSSQLServer 参数MSSQLServer
3) Then add the following String Values (REG_SZ):
3),然后加入下面的字符串值(REG_SZ):
"SQLArg3". Set the value to "-T3601" (without the double-quotes)
“SQLArg3”。将此值设置为“-T3601”(没有double-quotes)
"SQLArg4". Set the value to "-T3603” (without the double-quotes)
“SQLArg4”。将此值设置为“-T3603”(没有double-quotes)
4) Then, go back to the setup screen and click OK to continue with the sp4
installation.
4)然后,回到设置屏幕,点击OK继续sp4安装。
2024年3月20日发(作者:乾妙晴)
因是安装SQL Server 2000的机器上的CPU数(核心数)必须是2的幂,即2,4,
8,16,32,64 . . .
而双路6核服务器是12个核心,不是2的幂,因此报错。
SQL Server 2005也会面临同样的问题。
解决办法: 用–T3601 和 -T3603 参数来避免SMT检查,具体操作方法有两种,如
下:
信息来源:
/sqlserverfaq/archive/2009/05/27/info-sql-2000-msde-inst
allation-will-fail-if-you-have-number-of-cpus-on-a-box-which-is-not-in-power-of-
决议
METHOD 1:
方法1:
Start the installation in debug mode from command prompt by browsing to
the location of and using the following command:
在开始安装调试模式从命令提示符浏览地点的和使用下列命令:
安装媒体路径> < k = dbg
In case of SP4 installation :
如SP4安装:
Start the installation of SP4 in debug mode from command prompt by
browsing to the location of and using the following command:
在开始安装调试模式从SP4命令提示符浏览地点的和使用下列命令:
安装媒体路径> < k = dbg
Note: When you run setup in debug mode, the setup will prompt you for user
action to proceed on each step. Only when you click “OK” will it continue. This is
exactly what we want to do. We are pausing setup at the configuration step, while
we add the following trace flags in the registry and then continuing.
注意:当你运行安装在调试模式,为用户安装将促使你行动继续每一个步骤。只有当你点
击“OK”会继续下去。这正是我们想要做的事。我们暂停设定在配置步骤,而我们加入下
面微量旗帜在注册表中,然后继续。
Before configuring the server go ahead and added the trace flag –T3601 &
-T3603 in the registry by following the below steps:
配置服务器之前,先走一步,添加微量国旗在注册表中-T3601和-T3603遵循下面的步
骤:
1) Use trace flags 3601 and 3603 while the setup would be going on. Trace
flags 3601 and 3603 can be tried to avoid SMT checks and bypass problematic
code which checks the number of processors.
1)使用微量旗帜3601年和3603年将会在安装。3601年和3603年微量旗帜可以试
图避免SMT检查代码,绕过问题检查处理器数目。
2) Open regedit. Browse to the following location (for named instance, refer
method #2 for key location)
2)多谢开放。浏览下列位置(命名为实例,参考方法关键位置)2号
x86 servers:
HKEY_LOCAL_MACHINESOFTWAREMicrosoftMSSQLServerMSSQLServerPara
meters
服务器:HKEY_LOCAL_MACHINE 软件x86 Microsoft MSSQLServer 参
数MSSQLServer
X64 servers:
HKEY_LOCAL_MACHINESOFTWAREWOW6432nodeMicrosoftMSSQLServerMS
SQLServerParameters
服务器:HKEY_LOCAL_MACHINE 软件看 WOW6432node Microsoft
MSSQLServer 参数MSSQLServer
3) Then add the following String Values (REG_SZ):
3),然后加入下面的字符串值(REG_SZ):
"SQLArg3". Set the value to "-T3601" (without the double-quotes)
“SQLArg3”。将此值设置为“-T3601”(没有double-quotes)
"SQLArg4". Set the value to "-T3603” (without the double-quotes)
“SQLArg4”。将此值设置为“-T3603”(没有double-quotes)
4) Then, go back to the setup screen and click OK to continue with the sp4
installation.
4)然后,回到设置屏幕,点击OK继续sp4安装。