May 5, 2014 at 5:32 am
Hi Experts,
Just wanted to know how to check 'IO affinity' of SQL server through a query?
:-):-)
May 5, 2014 at 5:52 am
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
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy