3

SQL Server 2008 R2 GHOST CLEANUP hanging processes

view full story
linux-howto

http://serverfault.com – 2008 R2(SP1) - 10.50.2500.0 (X64) Hi, I am having the following problem intermittently on my development machine. I am running some T-SQL in a FOR loop. During each loop iteration, first we delete all rows in a table and then we add some rows to it (we are talking thousands of rows so nothing extraordinary). Then we query the rows in this table a few times and store the results in a table variable. Sometimes (quite often) the process appears to completely hang. I cannot kill the sp_id. DBCC OPENTRAN indicates that we are stuck on an INSERT. After much research I now see the following in sys (HowTos)

u85500's picture
Submitted by u85500 on 05/18/2012 – Made popular on 05/18/2012

Stories similar to SQL Server 2008 R2 GHOST CLEANUP hanging processes

I've been using transactional replication to mirror a table from one database to another and lately it's been a pain to keep running.

My goal is to simply keep an exact copy of a table in another database.

Table inserts are about 100 a day from the ASP page from which records submitted, up to a maximum of 400 per day on peak days.

The total records in the table wind up to be about 20,000 by the

select query issue 3 years 11 weeks ago

Hi all,

categories_id (PK,AI),categories_name(varchar(150)), categories_order(int), categories_image(varchar(100)), categories_status(int)

Hi, This may not be the right forum but i am hoping someone knows an answer to this.

I have to capture rows for a column that was deleted.

I'm looking for a simple way to check the rows in the database if the imagePath is equal to the column TABLE_IMAGE_PATH. First I was thinking of doing a loop and began with a request to check how many rows there are in the table, but then I got lost! And I guess there is better ways to do this with perhaps Do While?!

There are some rows in a table, by mistakenly I had deleted all rows from the table and data got commited. So is there any way to restore data for that table.

I am not having backup of the database.

I did not enable Binary Logging.

To avoid premature optimization, I don't want to implement SQL Azure's Federation too early. Is there a rule of thumb for how much data a table would need to have before seeing performance benefits from sharding?

MySQL Unite Two Tables 46 weeks 1 day ago

Situation: after crash (or hack, I'm not still sure) some in table vB_users disappeared. I have march backup of that table, but since that time there were new records. Is there a fast way to add all the rows from crashed table to the backup table and rewrite the existing rows? I mean, unite them, but the crashed version shoul have the priority over old version.

When ever I run a query that exceeds 30 queries the time for the query to run goes from less than a second to over 10 seconds to get data. Example I run a query to return 29 rows, it takes .1 seconds, I run a query to return 31 rows it takes 11.2 seconds. I am running mySQL on Windows 2008 Server Dual Core 2.6Ghz with 3GB of Memory. The machine doesn't run anything else.

Hi I need some help to write generic shell script for the below log file Requirement : Get some values from this log file and load them into one stats tables 1. Initializing session time (it will be available in first line) it is start time of the the job. 2. Target Load Summary variables like Table name, Output Rows, Affected Rows, Applied Rows, Rejected Rows.