Re: 100% CPU Util on Simple Update Query

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Jesse Beveridge (jesse_at_nospam.nospam)
Date: 02/09/05 

Date: Tue, 08 Feb 2005 21:12:44 -0700

What is the actual statement? Is there a where clause on it?

-- Jesse

On Tue, 8 Feb 2005 19:51:02 -0800, Joel H
<JoelH@discussions.microsoft.com> wrote:

>We just moved a database from SQL7 to 2000.I ran sp_updatestats after
>updating. One table has about 4000 rows, a single column primary key of type
>t_Ticker which is char 10. A query wants to update several items in one row.
>A sample is
>UPDATE tblTable set CharColumn='12345'.
> Yet even that simple query ties up the machine at 100% cpu, and doesn't
>finish.
>It ran fine on SQL 7.
>When I was trying to see if it was an index problem, by removing and
>replacing the primary key, it would occasionally (not reliably) run quickly,
>but the next time might fail again. I ran the query as part of an sp, but
>also from the analyser.
>The development machine is a 2 GHz, 750MB desktop, but it also fails on the
>production machine. Sql2000 is at SP3.
>TIA for any suggestions.

Relevant Pages

  • 100% CPU Util on Simple Update Query
    ... One table has about 4000 rows, a single column primary key of type ... A query wants to update several items in one row. ... UPDATE tblTable set CharColumn='12345'. ... but the next time might fail again. ...
    (microsoft.public.sqlserver.programming)
  • Query is too complex
    ... I'm using the querybuilder when updating a record in a table. ... I get a "Query is too complex" message. ... The Primary key is autonumbered. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Composite Primary Keys
    ... query to formulate a primary key before updating to the master file. ... Then using the find duplicates wizard on a left join query to display ...
    (comp.databases.ms-access)
  • Re: Problem with Access concatenate query
    ... records in the final query. ... You probably need to INNER JOIN the tables, although on what column, I am not sure. ... PriceID -- Primary Key ... ItemID --- Foreign Key ...
    (microsoft.public.access.queries)
  • RE: Processing thousands of records
    ... Jerry Whittle, Microsoft Access MVP ... Access automatically creates an index for primary key fields. ... that the query is working faster, you don't need the 1stVisit02 query. ... where do I read about fundamental indexing and normalization? ...
    (microsoft.public.access.queries)