Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
CanadaDBA
583 Posts |
 Posted - 2006-01-20 : 13:38:47
|
SQL Server 2k and Win2k3.My production value for affinity mask is different than my test server. Min Max Config_Value Run_ValueTest: 0 2147483647 0 0Prod: -2147483648 2147483647 0 0 How can I set them identical? How can I set the Min value to -2147483648?Thanks,Canada DBA |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-01-20 : 13:43:06
|
| You'll need to run sp_configure to modify the value. Check out sp_configure in BOL for details.Tara Kizeraka tduggan |
 |
|
|
CanadaDBA
583 Posts |
Posted - 2006-01-20 : 14:13:01
|
It doesn't talk about how to set the value in Minimum column.quote:
Originally posted by tkizer
You'll need to run sp_configure to modify the value. Check out sp_configure in BOL for details.Tara Kizeraka tduggan
Canada DBA |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-01-20 : 14:18:44
|
| Oops, you are right. I was thinking you were asking about changing the current value. I suspect that the minimum and maximum values can not be changed and that they are controlled by MS. The difference in your environments is probably due to an environmental difference, such as versions, hardware, etc...Tara Kizeraka tduggan |
|
|
|
CanadaDBA
583 Posts |
Posted - 2006-01-20 : 14:56:03
|
| Good News!The Minimum value is in spt_values in master database. I changed it and tested with sp_configure. Everything looks fine.Canada DBA |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-01-20 : 15:06:42
|
| Wow, you've certainly got guts changing system data like that.Tara Kizeraka tduggan |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-01-20 : 16:13:42
|
| I guess you like doing things the hard way:"How to configure the affinity mask (Enterprise Manager)To configure the affinity mask Expand a server group.Right-click a server, and then click Properties.Click the Processor tab.Under Processor control, select one or more processors to assemble your affinity mask."I hope your systems have identical hardware configurations. I would be inclined to follow the suggestion in BOL, and just leave it alone."Allocating Threads to a CPUBy default, each instance of Microsoft® SQL Server™ 2000 starts each thread, and then Microsoft Windows NT® or Windows® 2000 assigns each thread to a specific CPU. Windows NT or Windows 2000 distribute threads from instances of SQL Server evenly among the microprocessors, or CPUs on a computer. At times, Windows NT or Windows 2000 can also move a thread from one CPU with heavy usage to another CPU.SQL Server administrators can use the affinity mask configuration option to exclude one or more CPUs from being eligible to run threads from a specific instance of SQL Server. The affinity mask value specifies a bit pattern that indicates the CPUs that are used to run threads from that instance of SQL Server. For example, the affinity mask value 13 represents the bit pattern 1101. On a computer with four CPUs, this indicates threads from that instance of SQL Server can be scheduled on CPUs 0, 2, and 3, but not on CPU 1. If affinity mask is specified, the instance of SQL Server allocates threads evenly among the CPUs that have not been masked off. Another effect of affinity mask is that Windows NT and Windows 2000 do not move threads from one CPU to another. affinity mask is rarely used; most systems get optimal performance by letting Windows NT or Windows 2000 schedule the threads among the available CPUs."CODO ERGO SUM |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-01-20 : 16:17:03
|
| Michael,He wasn't changing the current/running value of the affinity mask. He wanted the minimum to be the same on both systems. Changing the affinity mask from EM would change the current value, right?Tara Kizeraka tduggan |
|
|
|
|
|
|
|
|
affinity mask