Computing.Net > Forums > Database > Sql parallell queries suspended

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

Sql parallell queries suspended

Reply to Message Icon

Name: chipcat
Date: February 18, 2009 at 05:23:23 Pacific
OS: Microsoft Windows XP Professional
CPU/Ram: 2.088 GHz / 767 MB
Product: Micro-star international / Ms-6712
Subcategory: MS SQL Server
Comment:

We're using sql server 2005 and when running our etl tool the server acts strange.
Uptill now we have had no problems what so ever.
Today when running an etl job after reading and insertig 100.000 rows our server jumps to 100% cpu on all 8 of them. And in the activity monitor it always sais suspended waiting on cx packet.

How do i resolve this issue?

thanks in advance



Sponsored Link
Ads by Google
Reply to Message Icon

Related Posts

See More







Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Database Forum Home


Sponsored links

Ads by Google


Results for: Sql parallell queries suspended

Need Urgent Help in MS SQL Express www.computing.net/answers/dbase/need-urgent-help-in-ms-sql-express-/384.html

create a table from a file www.computing.net/answers/dbase/create-a-table-from-a-file/249.html

Need help with SQL-query (access) www.computing.net/answers/dbase/need-help-with-sqlquery-access/209.html