Hi Guest

MobileUser

1 HomePage 1 Jobs 1 WalkIn 1Articles  

Cat Exam

 :) Latest Topic
AJAX
VB.NET
SQL Query
UDDI
CLASS
JavaScript Questions
SharePoint Interview
SilverLight
WCF
general knowledge
 ASP.NET
 :) Hot Jobs
 
 :) Latest Articles


  

 
CreamKids


Can we add CPU to SQL Server if yes then describe?
Question Posted on 24 Oct 2021

Home >> DataBase >> sql questions >> Can we add CPU to SQL Server if yes then describe?




Can we add CPU to SQL Server if yes then describe?
Yes we can add CPU to our SQL Server by either adding CPUs physically new hardware or by logically by online hardware partitioning or we can also add that by virtually through a virtualization layer. From Sql Sevre 2008 version sql server support CPU Hot Add means to add CPU minimum version is SQL Server 2008. Below are the some basic requirement to use CPU Hot Add.
(1)Hardware must support the CPU hot add.
(2)We have SQL Server Enterprise version to support CPU Hot Add.
(3)And when we say about operating system 64-bit edition of Windows Server 2008 Datacenter or Windows Server 2008 Enterprise Edition for Itanium-based system OS.
Kindly note once we add CPU we need to run RECONFIGURE and then SQL Server recongnizes the newly added CPU.
0
0



 
 Input Your Comments Or suggestions(If Any)
 Name
 Email(optional)
 Comments


Other Important Questions
Define N in nvarchar and in nchar?
difference between drop and truncate command
difference between procedure and function
different types of databases in sql
Difference Between Update Lock and Exclusive Lock






 
Top Searches:asp net questions vb net questions sql query uddl questions class javascript Questions sharepoint interview questions and concept silverlight questions and concept wcf questions beans general knowledge ajax questions
PHP | Biztalk | Testing | SAP | HR |