How to check IO affinity of SQL server through a query?

Question

Viewing 2 posts - 1 through 1 (of 1 total)

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

Grant Fritchey SSC Guru Points: 398679 More actions · Answer 1

You just have to use sp_configure:

EXEC sp_configure 'show advanced option', '1';

RECONFIGURE;

EXEC sys.sp_configure;

That will show you all the advanced options to just see the affinity mask for I/O you do this:

EXEC sys.sp_configure @configname = 'affinity I/O mask';

--or

EXEC sys.sp_configure @configname = 'affinity64 I/O mask';

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt