Viewing 15 posts - 31 through 45 (of 80 total)
sorry for taking a while to reply...
thanks for the links and feedback! 🙂
dont know why I didnt start with sqlskills... invaluable resources over there!
April 24, 2012 at 6:21 am
fixed.
changed the destination path to a local dir and it worked.
changed back to UNC path, and added /R:0 and it 'succeeded' the job, but did not move files....
April 20, 2012 at 11:56 am
thanks Lee.
Im trying to figure out why these were configured under PowerShell initially, and not really getting anywhere 😉
April 20, 2012 at 11:34 am
Final follow-up... I forgot to update this thread with my findings...
We were able to get ghost-cleanup to make a great deal of progress by way of index re-organizations.
but it didnt...
November 4, 2011 at 11:11 am
reorg has been running for ~30 minutes and table size went from 730gb to 729gb (as returned by sp_spaceused which has its margin of error of course).
considering the quantity of...
September 30, 2011 at 7:29 am
SpringTownDBA (9/29/2011)
I'm not recommending that you turn it off, but it mentioned that index reorgs and rebuilds will remove ghost records.
So, if you take the output...
September 30, 2011 at 6:15 am
and using the query against dm_exec_requests from Paul Randal's blog, I see only one active ghost_cleanup task, with a start_time of almost 48 hours ago.
so this isnt an issue of...
September 28, 2011 at 5:59 pm
for the sake of argument/discussion, regarding the purge method/ghost_cleanup not being logically capable of keeping up.
Why has this purge worked for a couple of years without issue/incident on sql 2005?...
September 28, 2011 at 4:21 pm
its all in a single partition/filegroup, and all in one big fat nasty table.
purges are done via cursor or where statement etc so we can control how long the purge...
September 28, 2011 at 2:40 pm
also of note, and I didnt make this connection till now:
the OTHER table that is exhibiting this behavior AND the original table are the two with the highest volume of...
September 28, 2011 at 2:10 pm
the ghost_record_count query has been going over 5 hours now and has over 1100 rows. I stupidly ran it to grid results, which isnt likely to give me the...
September 28, 2011 at 1:36 pm
you guys rule. running that query now.
I'll also try the sp_spaceused with update usage = true on a non-prod copy to get a feel for how long and what kinda...
September 28, 2011 at 8:21 am
jared-709193 (9/26/2011)
Ok, can you post the results of sp_spaceused for this table? And... Are you setting updateusage = TRUE?Thanks,
Jared
shouldnt be necessary with sql 2005 +.
or is there something im...
September 27, 2011 at 5:58 am
suresh.guglani (9/27/2011)
By the way have you checked avg_page_space_used_in_percent with sys.dm_db_index_physical_stats dmv.
NULL?
September 27, 2011 at 5:55 am
no partitioning, just a single file group with a bunch of secondary files.
I know its not optimal, but I'm on the implementation end NOT the architecting end of this...
September 26, 2011 at 3:17 pm
Viewing 15 posts - 31 through 45 (of 80 total)