Posted by CK on 11/18/05 16:48

Almost 2 days already . . . still the same . . .

"CK" <cf276@hotmail.com> wrote in message
news:437c7530$0$75331$c30e37c6@ken-reader.news.telstra.net...
> Hi. Sorry if I am asking a stupid question since I am an absolutely
> beginner in SQL Server. Here is the question . . .
>
> About 13 hours ago, I got my SQL Server 2000 to index a table which has
> 104 million records. At first the CPU usage was high. But after an hour or
> two, the process has seemed dead and the Enterprise Manager has had no
> response. The CPU usuage dropped to zero and has been jumping between 0 to
> 5%. The harddisk indicator has been blinking at a rate of roughly three
> times per two seconds.
>
> Is this normal? Has anyone got any idea how long the process would take? I
> have assigned 1.8GB of RAM to the SQL service and is currently taking up
> about 1GB.
>

[Back to original message]