Max Degree of Parrallism

  • 10:06 PM
  • 0 comments
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...
Read more »

Installing a SQL Server 2008 R2 Failover Cluster

  • 11:37 PM
  • 0 comments
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...
Read more »
 

Copyright © 2010 SQL Cached, All Rights Reserved. Design by DZignine