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.
7  1224 
Almost 2 days already . . . still the same . . .
"CK" <cf***@hotmail. com> wrote in message
news:43******** *************** @ken-reader.news.tel stra.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.
On Thu, 17 Nov 2005 23:19:08 +1100, CK wrote: Is this normal?
Hi CK,
Two days for indexing? No, that's not normal.
Open a new window in Query Analyzer and execute sp_who2. I think that
something is blocking your indexing process.
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)
Thanks for letting me know about this command. Otherwise I would have waited
forever without realising the process is in the state of "sleeping".
"Hugo Kornelis" <hugo@pe_NO_rFa ct.in_SPAM_fo> wrote in message
news:e3******** *************** *********@4ax.c om... On Thu, 17 Nov 2005 23:19:08 +1100, CK wrote:
Is this normal?
Hi CK,
Two days for indexing? No, that's not normal.
Open a new window in Query Analyzer and execute sp_who2. I think that
something is blocking your indexing process.
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)
On Sun, 20 Nov 2005 00:17:11 +1100, CK wrote: Thanks for letting me know about this command. Otherwise I would have waited
forever without realising the process is in the state of "sleeping".
Hi CK,
But is it also blocked?
(Check the column BlkBy)
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)
It's not blocked. After some testings, I realised the problem was caused by
insufficient free harddisk space for the transaction log file. It worked
fine after I created another log file in a drive with plenty of space.
Nevertheless, I was surprised that SQL Server didn't give me any warning
message about this.
"Hugo Kornelis" <hugo@pe_NO_rFa ct.in_SPAM_fo> wrote in message
news:gc******** *************** *********@4ax.c om... On Sun, 20 Nov 2005 00:17:11 +1100, CK wrote:
Thanks for letting me know about this command. Otherwise I would have
waited
forever without realising the process is in the state of "sleeping".
Hi CK,
But is it also blocked?
(Check the column BlkBy)
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)
CK (cf***@hotmail. com) writes: It's not blocked. After some testings, I realised the problem was caused
by insufficient free harddisk space for the transaction log file. It
worked fine after I created another log file in a drive with plenty of
space. Nevertheless, I was surprised that SQL Server didn't give me any
warning message about this.
I bet it did. But it sounds like you ran this through Enterprise Manager,
and there could be some hickup in this tool, hiding the error message
from you. Had you run the CREATE INDEX from Query Analyzer directly,
you should have seen an error message. (Or at least so I like believe. :-)
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se
Books Online for SQL Server 2005 at http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinf...ons/books.mspx
You absolutely are right about me using Enterprise Manager to index the
table. I guess it's now the time for me to brush up on my SQL skill!!!
"Erland Sommarskog" <es****@sommars kog.se> wrote in message
news:Xn******** *************@1 27.0.0.1... CK (cf***@hotmail. com) writes: It's not blocked. After some testings, I realised the problem was caused
by insufficient free harddisk space for the transaction log file. It
worked fine after I created another log file in a drive with plenty of
space. Nevertheless, I was surprised that SQL Server didn't give me any
warning message about this.
I bet it did. But it sounds like you ran this through Enterprise Manager,
and there could be some hickup in this tool, hiding the error message
from you. Had you run the CREATE INDEX from Query Analyzer directly,
you should have seen an error message. (Or at least so I like believe. :-)
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Irmen de Jong |
last post by:
Okay I tried some profiling, but am uncertain about the
results I'm getting. They confuse the hell out of me.
I have a test program (see below) that essentially has
two loops that get called repeatedly. One that is an idle
wait loop, and one that is a busy-wait CPU hogger.
I wanted to see what profiling results that would give.
The total runtime of the program is 10 seconds, where 5
seconds are spent in the CPU-loop and 5 seconds in the...
|
by: Yasutaka Ito |
last post by:
Hi,
Is there any way to disable the "Normal" button of the form? A button
displayed between the Minimum and Maximize button?
I want the user to be allowed to either minimized or maximized, but not set
the window state to normal.
thanks!
-Yasutaka
|
by: DraguVaso |
last post by:
Hi,
I'm new to WebServices, and I'm doing some tests (with a small
VB.NET-application) to know the performance-difference between a WebService
and the 'normal'-way of getting data (just connecting directly with a
SqlDataAdapter to the SQL Server). The WebMethod simply gives a DataSet
back, and does exactly the same actions as the normal-Method does.
The difference are enormous in my opinion:
1 record:
|
by: João Santa Bárbara |
last post by:
Hi all
i have a few problems with my Visual Studio ide 2005 :(
is This normal ???
when i'm writing in the code page my cpu goes wild ( 100 % ) only writing
when i press save my CPU goes Wild ( 100% ) for a couple time
when i move a few controls in the designer it goes wild !!! and mouse
pointer starts to flick....
is this all normal ???
|
by: Markus Ernst |
last post by:
Hi
When toggling an element on and off by setting its display property via
DOM access, display:none is valid for all kinds of elements, but I can't
find anything about a generic value for toggling on again.
Furthermore, UAs do not recognize the same values. To make a table row
visible, IE wants display:block while FF wants display:table-row.
Am I missing something? I am looking for something like display:normal
| | |
by: zybernau |
last post by:
i'm using .NET 1.1
i need to set attribute for a folder which is already read only
i need to sett the particular folder to normal,
i tried this code
dirInfo = New DirectoryInfo(Application.StartupPath & "/Resources/XML/")
dirInfo.Attributes = FileAttributes.Normal
|
by: Ben |
last post by:
Hi,
The gridview contains a radiobuttonlist with boolean values (true/false)
coming from a database.
In normal mode, the gridview displays True or False for that field.
What i want is to change True' and 'False' by 'Yes' and 'No' in normal mode.
I tried this, but still get True / False.
Thanks for help
|
by: awyeah |
last post by:
Hello everyone,
I have some very difficult task to accomplish using ADODB, or DAO in visual basic 6 whichever. This is my masters project and I am stuck!! Say I have a recordset with 4 customers such as:
Field1 Field2 Field3 Field4 Field5 Field6 Field7
E N E E N E N
E E E N E E N
E N E E E N N
N N E N N N N
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| | |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
