check processor count and maxdop is zero

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Ant-Green SSC Guru Points: 113507 More actions · Answer 1

select cpu_count from sys.dm_os_sys_info

select value_in_use from sys.configurations where name = 'max degree of parallelism'

sumith1andonly1 SSCrazy Points: 2250 More actions · Answer 2

query to check number of processor core equals to number of tempdb files?

Ant-Green SSC Guru Points: 113507 More actions · Answer 3

But again like I said on your other post, query sys.master_files get the number for temp db then match it to the processor value from the above

But seriously read that link