Sample Header Ad - 728x90

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_fragment 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