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 |
|
Kimi86
Yak Posting Veteran
79 Posts |
 Posted - 2012-11-01 : 08:49:35
|
| Hi All, We have 2 identical sql servers both sitting on VMsBut recently when i did a right click (property) over the server name in SSMS the Processors fields displayed different values for each. For 1 it displayed 4 and for other it displayed 6. Other field like Memory etc are in sink.This seems to be wrong since these are supposed to be identical. Am i right or these values can be rubbish?? |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-11-01 : 09:02:00
|
As far as I know, it is reliable. You can also query in T-SQL or look in control panel to confirm. T-SQL would be:SELECT cpu_count FROM sys.dm_os_sys_info |
 |
|
|
|
|
|
query regarging processors