|
Posted by CK on 11/17/05 14:19
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.
Navigation:
[Reply to this message]
|