SQL Server DBA Interview Questions & Answers| How to Allocate CPUs to SQL Server Instances

preview_player
Показать описание
In this video you will learn the answer of SQL Server DBA interview Question "
You have a Server that has 24 processors, You need to install multiple SQL Server instances on it.What method you will use to allocate processors to each instance depending upon the requirement?
"

Complete list of SQL Server DBA Interview Questions by Tech Brothers
  1. TechBrothersIT
  2. Database Administrator (Job Title)
  3. Microsoft SQL server
  4. MS SQL SErver
  5. MS SQL SErver Interview Questions and Answers
  6. Technology
Рекомендации по теме
DATABASE ADMINISTRATOR Interview 0:13:00

DATABASE ADMINISTRATOR Interview Questions & TOP-SCORING Answers! (DBA Interview Tips and Answer...

SQL Server DBA 0:20:29

SQL Server DBA Mock Interview 1

SQL Server DBA 0:15:47

SQL Server DBA interview Questions and Answers Part-1 |Microsoft | SQL Server| DBA |

TOP 23 SQL 0:18:31

TOP 23 SQL INTERVIEW QUESTIONS & ANSWERS! (SQL Interview Tips + How to PASS an SQL interview!)

How to clear 0:35:04

How to clear SQL Server DBA interview?

SQL Server DBA 0:05:53

SQL Server DBA Interview Questions | When should we update Statistics on SQL Server Database and why

SQL Server DBA 0:24:38

SQL Server DBA Interview Questions and Answers

SQL DBA Mock 0:22:33

SQL DBA Mock Interview 2 for 3 Years experience

Real Time MS 0:03:50

Real Time MS SQL Server DBA Issues

Real time MS 0:52:39

Real time MS SQL Server DBA Experienced Interview Questions and Answers Interview 11

Interview Questions From 0:51:35

Interview Questions From Database Pros

Top 25 SQL 0:26:21

Top 25 SQL Interview Questions and Answers(The BEST SQL Interview Questions)

Real time MS 0:46:14

Real time MS SQL Server DBA Experienced Interview Questions and Answers - Interview 18

SQL Server DBA 0:02:09

SQL Server DBA Interview Questions & Answers | Why do we use Listener in Availability Group

Real time MS 0:47:18

Real time MS SQL Server DBA Experienced Interview Questions and Answers Interview 14

Real time MS 0:34:36

Real time MS SQL Server DBA Experienced Interview Questions and Answers - Interview 2

Real time MS 0:22:07

Real time MS SQL Server DBA Experienced Interview Questions and Answers Interview 8

SQL Server DBA 0:15:46

SQL Server DBA Interview Questions and Answers Part-2 |SQL Server | DBA| Database |

SQL DBA Mock 0:28:43

SQL DBA Mock Interview 3 for 4 Years experience

MS SQL DBA 0:03:23

MS SQL DBA Interview Questions and Answers | MS SQL Server Architecture - Question 4

Real time MS 0:26:31

Real time MS SQL Server DBA Experienced Interview Questions and Answers Interview 17

MS SQL DBA 0:04:12

MS SQL DBA Interview Questions and Answers - Question 8 | Always On Enhancements

Real time MS 0:33:32

Real time MS SQL Server DBA Experienced Interview Questions and Answers Interview 13

Real time MS 0:21:22

Real time MS SQL Server DBA Experienced Interview Questions and Answers Interview 15

Комментарии
Автор

Hi Bro,
What's the difference of setting up CPU affinity between by Server's Task Manager and by SSMS?
Which one is more reliable? And why?

Thanks in advance.

dbalukehuang
Автор

Hi Bro, I got an answer as below:
Setting the affinity mask with Task Manager will only have effect until SQL Server is restarted. Using sp_configure will ensure the change remains effective across restarts.
So the best way to apply CPU affinity is through sp_configure.
Right?

dbalukehuang