MSSQL CPU 선호도 설정
DB Skill/MSSQL 2021. 6. 6. 07:03
-- 1번 NUMA Node CPU 사용하지 않도록 설정
ALTER SERVER CONFIGURATION SET PROCESS AFFINITY NUMANODE = 1
GO
-- CPU 선호도를 Auto로 설정
ALTER SERVER CONFIGURATION
SET PROCESS AFFINITY CPU=AUTO; GUI 설정
참고 자료
ALTER SERVER CONFIGURATION(Transact-SQL) - SQL Server
ALTER SERVER CONFIGURATION(Transact-SQL)
docs.microsoft.com
Setting a Processor Affinity in SQL Server – the (unwanted) Side-Effects |
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.) Today I want to talk about a very important topic in SQL Se
www.sqlpassion.at
'DB Skill > MSSQL' 카테고리의 다른 글
| MSSQL Long Running Job Check (0) | 2021.06.06 |
|---|---|
| MSSQL Database 암호화 키 삭제 (0) | 2021.06.06 |
| MSSQL Table Constraints Check 비활성화 (0) | 2021.06.06 |
| MSSQL backup history delete (0) | 2021.06.06 |
| MSSQL 데이터베이스 파일 (MDF, NDF)에 대해 초기화(Zeroing)하지 않고 즉시 생성 (0) | 2021.06.04 |
