tsql - Explanation for the fn_dblog() function's output on SQL Server 2008 R2 -

-

i have query me basic information regarding transaction log (.ldf) file. here is:

with cte (     select         allocunitname,         operation,         context,         [lock information],         sum(convert(bigint, [log record length])) totaltranlogbytes,         sum(convert(bigint, [log record length])) * 100 /             sum(convert(money, sum(convert(bigint, [log record length]))))             over() percentoflog             sys.fn_dblog(null,null)     group         allocunitname,         operation,         context,         [lock information] )  select     allocunitname,     operation,     context,     [lock information],     totaltranlogbytes,     percentoflog     cte     percentoflog >= 0 order     totaltranlogbytes desc

unfortunately, don't understand output... i'm concerned top row query's results, it's largest amount of space used in transaction log, simple!

however, there other columns, allocunitname, operation , context. in case, get:

dbo.mymassivetable.pk_mymassivetable    lop_modify_row  lcx_text_mix        3848564 61.6838

...as output. on earth lop_modify_row, , lcx_text_mix mean?

obviously can vaguely understand it's primary key table, it's associated update command, , there happening text column?

but need precision!

anyone can me understand why particular part of transaction log huge great help!

this indicates table contains column of large object datatype subject insert or update activity (i.e. max datatype, xml, clr datatype or image or [n]text).

dbo.mymassivetable.pk_mymassivetable must either clustered index or non clustered index include-s 1 or more lob columns.

lcx_text_mix presumably indicates text mix page:

a text page holds small chunks of lob values plus internal parts of text tree. these can shared between lob values in same partition of index or heap.

lop_modify_row appears in log when value updated example below shows insert can reproduce same logging outcome.

create table dbo.mymassivetable   (      pk    int identity constraint pk_mymassivetable primary key,      blob1 nvarchar(max)   )  insert dbo.mymassivetable values     (replicate(cast(n'x' varchar(max)), 3848564 / 2));

Comments

Post a Comment

Popular posts from this blog

javascript - Chart.js (Radar Chart) different scaleLineColor for each scaleLine -

-
Image
i try , create radar chart using chart.js has various colours each scaleline, or coloured between scalelines. wondering if possible? from: to: i have working graph, though there doesn't seem method change individual scale lines. kind regards leigh you can extend radar chart type this, so chart.types.radar.extend({ name: "radaralt", initialize: function (data) { chart.types.radar.prototype.initialize.apply(this, arguments); var originalscaledraw = this.scale.draw; var ctx = this.chart.ctx; this.scale.draw = function () { var linewidth = this.linewidth; // bypasses line drawing in originalscaledraw this.linewidth = linewidth; originalscaledraw.apply(this, arguments); ctx.linewidth = this.linewidth; var scale = this; // draw chart.helpers.each(scale.ylabels, function (label, index) { // color of ...
Read more

apache - Error with PHP mail(): Multiple or malformed newlines found in additional_header -

-
suddenly have started receiving above error without changes having been made script. host 1and1 (i know...) the script still works fine on different server, , suspicion there must have been server config change has lead this, although hosts plead ignorance. there's no information on above error @ in google can find - have ideas? server running apache if helps. had similar problem. came out of blue. no php code changed. what changed: php upgraded 5.5.25-1 5.5.26. a security risk in php mail() function has been fixed , newlines in additional_headers allowed no more. because newlines mean: starts email message (and surely don't want inject newlines through headers followed evil message). what have worked fine, e.g. having newlines after headers or passing whole message additional_headers , function no more. solution : sanitize headers. no multiple newlines in additional_headers argument. these count "multiple or malformed newlines":...
Read more

java - Android – MapFragment overlay button shadow, just like MyLocation button -

-
Image
i'm struggling add shadow custom overlay button on google map. goal make custom button google's mylocation button. here's how app looks now: layout.xml <relativelayout xmlns:android="http://schemas.android.com/apk/res/android" xmlns:tools="http://schemas.android.com/tools" xmlns:map="http://schemas.android.com/apk/res-auto" android:layout_height="match_parent" android:layout_width="match_parent" style="@style/apptheme"> <fragment android:layout_width="match_parent" android:layout_height="match_parent" android:id="@+id/map" tools:context=".mapsactivity" android:name="com.google.android.gms.maps.supportmapfragment" android:layout_alignparentend="true" android:layout_alignparentstart="true" android:layout_alignparentbottom="true" ...
Read more