SQLRNNR (8/3/2014)
Did you check the status of the index creation while in progress? Did you check for blocking?Does the dev server have just a small amount of RAM or little cpu power?
Those things can affect the creation of the index.
Besides the 172million records, we know so little about your table. Things like total size of the table, data types, what the index was that you created. Those things can also impact the creation time.
Run the script from the following link and post the results for the table in question. Also post things like the table definition and index definition please.
the dev server has only 4 CPU with 8 GB of RAM
but the production has 24 CPU with 32 GB of RAM
How do i check the blocking when I run the index creation process?
Data for the table :
Index space : 32.067.563 MB
Row count : 178.432.356 MB
Data space : 10.905.453 MB
The index :
CREATE NONCLUSTERED INDEX [IX_D] ON [dbo].[D]
(
[TemplateId] ASC
)
INCLUDE ( [Value],
[Datestamp])
FYI :
Template id (int)
Value (varchar(2000)
datestamp (datetime )
Unfortunately when I run the script that u gave me ..I got many errors but i hope the table profile that I give you can give you more information
looking forward your response
thankss