Viewing 10 posts - 1 through 10 (of 10 total)
A couple of more thoughts:
I originally made this a table-function but had to replace the waitfor with a clunky loop checking getdate(). The function was nice because you could select...
December 7, 2015 at 8:55 am
this was supposed to be in SQL2012...I inadvertently added to sql2005 section...will create a new one there as well.
October 16, 2015 at 10:17 pm
MY shrink ended after 4hrs.....most of that time the dmvs indicated it was waiting on the same page....too weird.
But the take-aways I have are multiple file objects will require cross...
September 28, 2015 at 1:07 pm
OK, I've turned up something....my DB has a table with varchar(max) LOBs stored off-row. So some pages on file3 are linked to pages on file1. the process of true-up of...
September 28, 2015 at 12:02 pm
ok forgot to turn on the traceflag to allow print display.
did this and now I can see stuff from DBCC PAGE....but still don't understand whats goiong on.
DBCC PAGE(9,3,15411328,3) with...
September 28, 2015 at 11:38 am
Also when I do:
no results (tried levels 0,1,2,3 in 4th parm...nothing)
Am I misunderstanding something here? Isn't the "3" in the Activity monitor Wait Resource the fileid?
September 28, 2015 at 11:30 am
SORRY, put this in wrong forum....is SQL2012 not SQL2005 and didn't realize the context I was in....I will add this to a SQL2012 forum instead. Consider this closed. Sorry don't...
September 28, 2015 at 11:25 am
Let me know how l can improve....the descrption?...how it helped me?...does it not work? Let me know. Thanks
August 14, 2015 at 6:22 pm
Good article. Covered the basic configurations that people are "thinking about". Thanks.
I've set up multi-node Oracle RAC that uses a private interconnect for very quick block movement needed to keep...
September 4, 2012 at 12:25 pm
Yeah, there's a lot out there on lsass.exe ... none of it applied to me until i found this one.
if its a domain controller, there is another fix.
August 14, 2012 at 10:39 am