Will a nonclustered lock index of my table be added?

Question

I have a table with ~ 2 million records, and I need to add a new non-clustered index to uniqueidentifier to improve query performance.

Will adding a nonclustered index block the table or otherwise significantly degrade performance when I use it?

There is a lot of information about the benefits / errors of indexing, but I can not find anything that tells me that this happens during the indexing operation

I am running SQL Server 2008 R2 (on Windows Server 2008, if that matters)

EDIT: This is Enterprise Edition

Answer 1

Enterprise Edition -. :

create index MyIDX on MyTable (MyColumn) with (online = on)

, ( , IIRC), . , , .

: , , -, .

Answer 2

, " " (Enterprise), :

, , Shared (S) . , SELECT .

, " " . - !

PS: , , - . SQL - .

Answer 3

( ), , , . - , , , .

( , "" ) ( 100%, , ).

( , ). , ( )

In any case, I suggest you get into the books and do some acid tests. This is a very complex topic and a lot depends on your specific scenario.