Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to check IO affinity of SQL server through a query? Expand / Collapse
Author
Message
Posted Monday, May 5, 2014 5:32 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, October 16, 2014 1:19 AM
Points: 52, Visits: 279
Hi Experts,

Just wanted to know how to check 'IO affinity' of SQL server through a query?


Post #1567477
Posted Monday, May 5, 2014 5:52 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 10:17 AM
Points: 13,867, Visits: 28,265
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
The Scary DBA
Author of: SQL Server Query Performance Tuning
SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1567480
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse