How do I change the usage of a device_fragment?
0
votes
1
answer
1322
views
As can be seen below an index
device_fragment
usage is log only when it should be data only, and a log device_fragmen
t usage is data only when it should be log only.
name db_size owner dbid created durability lobcomplvl inrowlen status
-------- ------------- -------- ---- ------------ ---------- ---------- --------- ------------------------------------------------------------------------
a0000023 76000.0 MB a0000023 4 Sep 05, 2017 full 0 NULL select into/bulkcopy/pllsort, trunc log on chkpt, allow nulls by default
device_fragments size usage created free kbytes
------------------------------ ------------- -------------------- ------------------------- ----------------
a0000023_data000 250.0 MB data only Sep 6 2017 9:37AM 86
a0000023_index000 500.0 MB data only Sep 6 2017 9:37AM 126
a0000023_log000 100.0 MB log only Sep 6 2017 9:37AM not applicable
a0000023_data000 500.0 MB data only Sep 6 2017 9:37AM 56
a0000023_index000 500.0 MB data only Sep 6 2017 9:37AM 2554
a0000023_data000 300.0 MB data only Sep 6 2017 9:37AM 70
a0000023_index000 700.0 MB data only Sep 6 2017 9:37AM 422
a0000023_data000 1000.0 MB data only Sep 6 2017 9:37AM 126
a0000023_index000 1000.0 MB data only Sep 6 2017 9:37AM 0
a0000023_log000 548.5 MB log only Sep 6 2017 9:37AM not applicable
a0000023_log000 0.5 MB data only Sep 6 2017 9:37AM 272
a0000023_log000 1.0 MB data only Sep 6 2017 9:37AM 0
a0000023_data000 2449.0 MB data only Sep 6 2017 9:37AM 112
a0000023_data000 2.0 MB data only Sep 6 2017 9:37AM 0
a0000023_index000 2422.5 MB data only Sep 6 2017 9:37AM 84
a0000023_index000 0.5 MB data only Sep 6 2017 9:37AM 0
a0000023_index000 3.0 MB data only Sep 6 2017 9:37AM 0
a0000023_data000 2997.0 MB data only Sep 6 2017 9:37AM 322
a0000023_data000 4.0 MB data only Sep 6 2017 9:37AM 0
a0000023_index000 1995.5 MB data only Sep 6 2017 9:37AM 658
a0000023_index000 0.5 MB data only Sep 6 2017 9:37AM 510
a0000023_index000 5.0 MB log only Sep 6 2017 9:37AM not applicable
a0000023_log000 345.5 MB log only Sep 6 2017 9:37AM not applicable
a0000023_log000 0.5 MB data only Sep 6 2017 9:37AM 0
a0000023_log000 4.0 MB data only Sep 6 2017 9:37AM 0
a0000023_index000 1495.5 MB data only Sep 6 2017 9:37AM 602
a0000023_index000 0.5 MB data only Sep 6 2017 9:37AM 0
a0000023_index000 5.0 MB data only Sep 6 2017 9:37AM 0
a0000023_data000 5495.0 MB data only Sep 6 2017 9:37AM 518
a0000023_data000 5.0 MB data only Sep 6 2017 9:37AM 0
a0000023_index000 1620.0 MB data only Sep 6 2017 9:37AM 28
a0000023_index000 5.0 MB data only Sep 6 2017 9:37AM 0
a0000023_data000 6995.0 MB data only Sep 6 2017 9:37AM 352250
a0000023_data000 3.0 MB data only Sep 6 2017 9:37AM 0
a0000023_index000 7747.0 MB data only Sep 6 2017 9:37AM 1638
a0000023_data000 6000.0 MB data only Sep 6 2017 9:37AM 140
a0000023_index000 2000.0 MB data only Sep 6 2017 9:37AM 56
a0000023_data000 4000.0 MB data only Sep 6 2017 9:37AM 98
a0000023_index000 15000.0 MB data only Sep 6 2017 9:37AM 6856024
a0000023_data000 10000.0 MB data only Sep 6 2017 9:37AM 10200000
--------------------------------------------------------------------------------------------------------------
log only free kbytes = 1018706
Asked by terry
(1 rep)
Sep 6, 2017, 03:43 PM
Last activity: Jun 25, 2025, 03:07 PM
Last activity: Jun 25, 2025, 03:07 PM