When SQL Server runs on a computer with more than one microprocessor/CPU or on SMP (a computer-architecture where two or more identical processors can connect to a single shared main memory and I/O and can perform the same functions. In case of multi-core processors, the SMP architecture applies to the cores, treating them as separate processors), it detects the best degree of parallelism, that is, the number of processors employed to run a...
Max Degree of Parrallism
- Posted by Prakash chheatry
- 10:06 PM
- 0 comments
- Labels: No labels
Read more »
Installing a SQL Server 2008 R2 Failover Cluster
- Posted by Prakash chheatry
- 11:37 PM
- 0 comments
- Labels: No labels

To install a SQL Server failover cluster, you must create and configure a failover cluster instance by running SQL Server Setup. This topic explains the elements of a failover cluster, as well as important information about naming a failover cluster instance. It also describes basic steps for installing a failover cluster.Elements...