Cannot shrink btrfs filesystem although there is still data and metadata space left : ERROR: unable to resize '/home': No space left on device The Next CEO of Stack OverflowMount two btrfs subvolumes simultaneouslyrsnapshot frequently ext3-fs error: “ext3_lookup: deleted inode referenced:”btrfs write operations hang when appending to filesext4 mount flags for 10+ mill files storage“No space left on device” error despite having plenty of space, on btrfsIs it safe to continue working during btrfs balance operation?How to recover unrecoverable errors in a btrfs RAID1 volume?Does the ReFS filesystem reserve space for itself?Can we add more volumes/disks to an existing mounted ext3/ext4 mountpoint?BTRFS unmountable after cold reboot (total_rw_bytes is twice too big)

Multi tool use
Multi tool use

What are the unusually-enlarged wing sections on this P-38 Lightning?

Why don't programming languages automatically manage the synchronous/asynchronous problem?

Small nick on power cord from an electric alarm clock, and copper wiring exposed but intact

Reshaping json / reparing json inside shell script (remove trailing comma)

How to get the last not-null value in an ordered column of a huge table?

Why is the US ranked as #45 in Press Freedom ratings, despite its extremely permissive free speech laws?

What was Carter Burke's job for "the company" in Aliens?

"Eavesdropping" vs "Listen in on"

free fall ellipse or parabola?

Does higher Oxidation/ reduction potential translate to higher energy storage in battery?

Easy to read palindrome checker

What happened in Rome, when the western empire "fell"?

Cannot shrink btrfs filesystem although there is still data and metadata space left : ERROR: unable to resize '/home': No space left on device

Is there a way to save my career from absolute disaster?

Is it OK to decorate a log book cover?

What day is it again?

Why do we say 'Un seul M' and not 'Une seule M' even though M is a "consonne"

From jafe to El-Guest

Is it correct to say moon starry nights?

Does the Idaho Potato Commission associate potato skins with healthy eating?

Physiological effects of huge anime eyes

Expressing the idea of having a very busy time

Help understanding this unsettling image of Titan, Epimetheus, and Saturn's rings?

Players Circumventing the limitations of Wish



Cannot shrink btrfs filesystem although there is still data and metadata space left : ERROR: unable to resize '/home': No space left on device



The Next CEO of Stack OverflowMount two btrfs subvolumes simultaneouslyrsnapshot frequently ext3-fs error: “ext3_lookup: deleted inode referenced:”btrfs write operations hang when appending to filesext4 mount flags for 10+ mill files storage“No space left on device” error despite having plenty of space, on btrfsIs it safe to continue working during btrfs balance operation?How to recover unrecoverable errors in a btrfs RAID1 volume?Does the ReFS filesystem reserve space for itself?Can we add more volumes/disks to an existing mounted ext3/ext4 mountpoint?BTRFS unmountable after cold reboot (total_rw_bytes is twice too big)










2















I cannot shrink btrfs filesystem although there is still data and metadata space left :





$ sudo btrfs filesystem resize -11G /home;echo $?
Resize '/home' of '-11G'
ERROR: unable to resize '/home': No space left on device
1


Here are some btrfs filesystem info about /home :



$ sudo btrfs filesystem df /home | column -t
Data, single: total=92.01GiB, used=80.68GiB
System, DUP: total=8.00MiB, used=16.00KiB
System, single: total=4.00MiB, used=0.00B
Metadata, DUP: total=1.00GiB, used=631.41MiB
Metadata, single: total=8.00MiB, used=0.00B
GlobalReserve, single: total=224.00MiB, used=0.00B
$ sudo btrfs filesystem show /home
Label: none uuid: c7ee56a8-ef45-46c8-86d1-13879201a1e7
Total devices 1 FS bytes used 81.30GiB
devid 1 size 100.00GiB used 94.04GiB path /dev/mapper/home_VG-home

$ sudo btrfs filesystem usage -T /home
Overall:
Device size: 100.00GiB
Device allocated: 94.04GiB
Device unallocated: 5.96GiB
Device missing: 0.00B
Used: 81.91GiB
Free (estimated): 17.29GiB (min: 14.31GiB)
Data ratio: 1.00
Metadata ratio: 1.99
Global reserve: 224.00MiB (used: 0.00B)

Data Metadata Metadata System System
Id Path single single DUP single DUP Unallocated
-- --------- -------- -------- --------- ------- -------- -----------
1 /dev/dm-0 92.01GiB 8.00MiB 2.00GiB 4.00MiB 16.00MiB 5.96GiB
-- --------- -------- -------- --------- ------- -------- -----------
Total 92.01GiB 8.00MiB 1.00GiB 4.00MiB 8.00MiB 5.96GiB
Used 80.68GiB 0.00B 631.41MiB 0.00B 16.00KiB


and here the output of dmesg :



$ dmesg | tail -11
[44202.411949] BTRFS info (device dm-0): new size for /dev/dm-0 is 97706311680
[44202.412156] BTRFS info (device dm-0): relocating block group 120288444416 flags 1
[44208.119721] BTRFS info (device dm-0): relocating block group 119214702592 flags 1
[44211.611669] BTRFS info (device dm-0): relocating block group 118140960768 flags 1
[44212.495603] BTRFS info (device dm-0): relocating block group 117067218944 flags 1
[44213.006830] BTRFS info (device dm-0): relocating block group 95592382464 flags 1
[44216.613870] BTRFS info (device dm-0): relocating block group 120288444416 flags 1
[44222.780073] BTRFS info (device dm-0): relocating block group 119214702592 flags 1
[44225.843279] BTRFS info (device dm-0): relocating block group 118140960768 flags 1
[44226.575236] BTRFS info (device dm-0): relocating block group 117067218944 flags 1
[44226.930918] BTRFS info (device dm-0): relocating block group 95592382464 flags 1


Can you help me ?










share|improve this question




























    2















    I cannot shrink btrfs filesystem although there is still data and metadata space left :





    $ sudo btrfs filesystem resize -11G /home;echo $?
    Resize '/home' of '-11G'
    ERROR: unable to resize '/home': No space left on device
    1


    Here are some btrfs filesystem info about /home :



    $ sudo btrfs filesystem df /home | column -t
    Data, single: total=92.01GiB, used=80.68GiB
    System, DUP: total=8.00MiB, used=16.00KiB
    System, single: total=4.00MiB, used=0.00B
    Metadata, DUP: total=1.00GiB, used=631.41MiB
    Metadata, single: total=8.00MiB, used=0.00B
    GlobalReserve, single: total=224.00MiB, used=0.00B
    $ sudo btrfs filesystem show /home
    Label: none uuid: c7ee56a8-ef45-46c8-86d1-13879201a1e7
    Total devices 1 FS bytes used 81.30GiB
    devid 1 size 100.00GiB used 94.04GiB path /dev/mapper/home_VG-home

    $ sudo btrfs filesystem usage -T /home
    Overall:
    Device size: 100.00GiB
    Device allocated: 94.04GiB
    Device unallocated: 5.96GiB
    Device missing: 0.00B
    Used: 81.91GiB
    Free (estimated): 17.29GiB (min: 14.31GiB)
    Data ratio: 1.00
    Metadata ratio: 1.99
    Global reserve: 224.00MiB (used: 0.00B)

    Data Metadata Metadata System System
    Id Path single single DUP single DUP Unallocated
    -- --------- -------- -------- --------- ------- -------- -----------
    1 /dev/dm-0 92.01GiB 8.00MiB 2.00GiB 4.00MiB 16.00MiB 5.96GiB
    -- --------- -------- -------- --------- ------- -------- -----------
    Total 92.01GiB 8.00MiB 1.00GiB 4.00MiB 8.00MiB 5.96GiB
    Used 80.68GiB 0.00B 631.41MiB 0.00B 16.00KiB


    and here the output of dmesg :



    $ dmesg | tail -11
    [44202.411949] BTRFS info (device dm-0): new size for /dev/dm-0 is 97706311680
    [44202.412156] BTRFS info (device dm-0): relocating block group 120288444416 flags 1
    [44208.119721] BTRFS info (device dm-0): relocating block group 119214702592 flags 1
    [44211.611669] BTRFS info (device dm-0): relocating block group 118140960768 flags 1
    [44212.495603] BTRFS info (device dm-0): relocating block group 117067218944 flags 1
    [44213.006830] BTRFS info (device dm-0): relocating block group 95592382464 flags 1
    [44216.613870] BTRFS info (device dm-0): relocating block group 120288444416 flags 1
    [44222.780073] BTRFS info (device dm-0): relocating block group 119214702592 flags 1
    [44225.843279] BTRFS info (device dm-0): relocating block group 118140960768 flags 1
    [44226.575236] BTRFS info (device dm-0): relocating block group 117067218944 flags 1
    [44226.930918] BTRFS info (device dm-0): relocating block group 95592382464 flags 1


    Can you help me ?










    share|improve this question


























      2












      2








      2


      1






      I cannot shrink btrfs filesystem although there is still data and metadata space left :





      $ sudo btrfs filesystem resize -11G /home;echo $?
      Resize '/home' of '-11G'
      ERROR: unable to resize '/home': No space left on device
      1


      Here are some btrfs filesystem info about /home :



      $ sudo btrfs filesystem df /home | column -t
      Data, single: total=92.01GiB, used=80.68GiB
      System, DUP: total=8.00MiB, used=16.00KiB
      System, single: total=4.00MiB, used=0.00B
      Metadata, DUP: total=1.00GiB, used=631.41MiB
      Metadata, single: total=8.00MiB, used=0.00B
      GlobalReserve, single: total=224.00MiB, used=0.00B
      $ sudo btrfs filesystem show /home
      Label: none uuid: c7ee56a8-ef45-46c8-86d1-13879201a1e7
      Total devices 1 FS bytes used 81.30GiB
      devid 1 size 100.00GiB used 94.04GiB path /dev/mapper/home_VG-home

      $ sudo btrfs filesystem usage -T /home
      Overall:
      Device size: 100.00GiB
      Device allocated: 94.04GiB
      Device unallocated: 5.96GiB
      Device missing: 0.00B
      Used: 81.91GiB
      Free (estimated): 17.29GiB (min: 14.31GiB)
      Data ratio: 1.00
      Metadata ratio: 1.99
      Global reserve: 224.00MiB (used: 0.00B)

      Data Metadata Metadata System System
      Id Path single single DUP single DUP Unallocated
      -- --------- -------- -------- --------- ------- -------- -----------
      1 /dev/dm-0 92.01GiB 8.00MiB 2.00GiB 4.00MiB 16.00MiB 5.96GiB
      -- --------- -------- -------- --------- ------- -------- -----------
      Total 92.01GiB 8.00MiB 1.00GiB 4.00MiB 8.00MiB 5.96GiB
      Used 80.68GiB 0.00B 631.41MiB 0.00B 16.00KiB


      and here the output of dmesg :



      $ dmesg | tail -11
      [44202.411949] BTRFS info (device dm-0): new size for /dev/dm-0 is 97706311680
      [44202.412156] BTRFS info (device dm-0): relocating block group 120288444416 flags 1
      [44208.119721] BTRFS info (device dm-0): relocating block group 119214702592 flags 1
      [44211.611669] BTRFS info (device dm-0): relocating block group 118140960768 flags 1
      [44212.495603] BTRFS info (device dm-0): relocating block group 117067218944 flags 1
      [44213.006830] BTRFS info (device dm-0): relocating block group 95592382464 flags 1
      [44216.613870] BTRFS info (device dm-0): relocating block group 120288444416 flags 1
      [44222.780073] BTRFS info (device dm-0): relocating block group 119214702592 flags 1
      [44225.843279] BTRFS info (device dm-0): relocating block group 118140960768 flags 1
      [44226.575236] BTRFS info (device dm-0): relocating block group 117067218944 flags 1
      [44226.930918] BTRFS info (device dm-0): relocating block group 95592382464 flags 1


      Can you help me ?










      share|improve this question
















      I cannot shrink btrfs filesystem although there is still data and metadata space left :





      $ sudo btrfs filesystem resize -11G /home;echo $?
      Resize '/home' of '-11G'
      ERROR: unable to resize '/home': No space left on device
      1


      Here are some btrfs filesystem info about /home :



      $ sudo btrfs filesystem df /home | column -t
      Data, single: total=92.01GiB, used=80.68GiB
      System, DUP: total=8.00MiB, used=16.00KiB
      System, single: total=4.00MiB, used=0.00B
      Metadata, DUP: total=1.00GiB, used=631.41MiB
      Metadata, single: total=8.00MiB, used=0.00B
      GlobalReserve, single: total=224.00MiB, used=0.00B
      $ sudo btrfs filesystem show /home
      Label: none uuid: c7ee56a8-ef45-46c8-86d1-13879201a1e7
      Total devices 1 FS bytes used 81.30GiB
      devid 1 size 100.00GiB used 94.04GiB path /dev/mapper/home_VG-home

      $ sudo btrfs filesystem usage -T /home
      Overall:
      Device size: 100.00GiB
      Device allocated: 94.04GiB
      Device unallocated: 5.96GiB
      Device missing: 0.00B
      Used: 81.91GiB
      Free (estimated): 17.29GiB (min: 14.31GiB)
      Data ratio: 1.00
      Metadata ratio: 1.99
      Global reserve: 224.00MiB (used: 0.00B)

      Data Metadata Metadata System System
      Id Path single single DUP single DUP Unallocated
      -- --------- -------- -------- --------- ------- -------- -----------
      1 /dev/dm-0 92.01GiB 8.00MiB 2.00GiB 4.00MiB 16.00MiB 5.96GiB
      -- --------- -------- -------- --------- ------- -------- -----------
      Total 92.01GiB 8.00MiB 1.00GiB 4.00MiB 8.00MiB 5.96GiB
      Used 80.68GiB 0.00B 631.41MiB 0.00B 16.00KiB


      and here the output of dmesg :



      $ dmesg | tail -11
      [44202.411949] BTRFS info (device dm-0): new size for /dev/dm-0 is 97706311680
      [44202.412156] BTRFS info (device dm-0): relocating block group 120288444416 flags 1
      [44208.119721] BTRFS info (device dm-0): relocating block group 119214702592 flags 1
      [44211.611669] BTRFS info (device dm-0): relocating block group 118140960768 flags 1
      [44212.495603] BTRFS info (device dm-0): relocating block group 117067218944 flags 1
      [44213.006830] BTRFS info (device dm-0): relocating block group 95592382464 flags 1
      [44216.613870] BTRFS info (device dm-0): relocating block group 120288444416 flags 1
      [44222.780073] BTRFS info (device dm-0): relocating block group 119214702592 flags 1
      [44225.843279] BTRFS info (device dm-0): relocating block group 118140960768 flags 1
      [44226.575236] BTRFS info (device dm-0): relocating block group 117067218944 flags 1
      [44226.930918] BTRFS info (device dm-0): relocating block group 95592382464 flags 1


      Can you help me ?







      filesystems btrfs






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited 4 hours ago







      SebMa

















      asked 8 hours ago









      SebMaSebMa

      1367




      1367




















          1 Answer
          1






          active

          oldest

          votes


















          2














          You're requesting the volume to shrink by 11GB, yet you only have about 6GB unallocated.



          You can more efficiently use allocated extents by rebalancing the volume. Executing a command similar to btrfs balance start /home will start that process, and it may take some time to complete.



          But I don't know if that will free up enough for a large amount of shrinkage.






          share|improve this answer























          • I though I add 14.31GiB free according to this : Free (estimated): 17.29GiB (min: 14.31GiB)

            – SebMa
            1 hour ago






          • 1





            But you're requesting a volume change, which deals with allocated extents rather than how they're used. You could have almost the entire volume "free", but if the whole thing is "allocated" you can't shrink it. Running a rebalance will reallocate used data in a more efficient way.

            – Spooler
            1 hour ago











          • Ok, thanks bro. I'll do this tomorrow 'cause it's 20 to 4 (A.M) in France.

            – SebMa
            1 hour ago











          Your Answer








          StackExchange.ready(function()
          var channelOptions =
          tags: "".split(" "),
          id: "2"
          ;
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function()
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled)
          StackExchange.using("snippets", function()
          createEditor();
          );

          else
          createEditor();

          );

          function createEditor()
          StackExchange.prepareEditor(
          heartbeatType: 'answer',
          autoActivateHeartbeat: false,
          convertImagesToLinks: true,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: 10,
          bindNavPrevention: true,
          postfix: "",
          imageUploader:
          brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
          contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
          allowUrls: true
          ,
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          );



          );













          draft saved

          draft discarded


















          StackExchange.ready(
          function ()
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fserverfault.com%2fquestions%2f960860%2fcannot-shrink-btrfs-filesystem-although-there-is-still-data-and-metadata-space-l%23new-answer', 'question_page');

          );

          Post as a guest















          Required, but never shown

























          1 Answer
          1






          active

          oldest

          votes








          1 Answer
          1






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes









          2














          You're requesting the volume to shrink by 11GB, yet you only have about 6GB unallocated.



          You can more efficiently use allocated extents by rebalancing the volume. Executing a command similar to btrfs balance start /home will start that process, and it may take some time to complete.



          But I don't know if that will free up enough for a large amount of shrinkage.






          share|improve this answer























          • I though I add 14.31GiB free according to this : Free (estimated): 17.29GiB (min: 14.31GiB)

            – SebMa
            1 hour ago






          • 1





            But you're requesting a volume change, which deals with allocated extents rather than how they're used. You could have almost the entire volume "free", but if the whole thing is "allocated" you can't shrink it. Running a rebalance will reallocate used data in a more efficient way.

            – Spooler
            1 hour ago











          • Ok, thanks bro. I'll do this tomorrow 'cause it's 20 to 4 (A.M) in France.

            – SebMa
            1 hour ago















          2














          You're requesting the volume to shrink by 11GB, yet you only have about 6GB unallocated.



          You can more efficiently use allocated extents by rebalancing the volume. Executing a command similar to btrfs balance start /home will start that process, and it may take some time to complete.



          But I don't know if that will free up enough for a large amount of shrinkage.






          share|improve this answer























          • I though I add 14.31GiB free according to this : Free (estimated): 17.29GiB (min: 14.31GiB)

            – SebMa
            1 hour ago






          • 1





            But you're requesting a volume change, which deals with allocated extents rather than how they're used. You could have almost the entire volume "free", but if the whole thing is "allocated" you can't shrink it. Running a rebalance will reallocate used data in a more efficient way.

            – Spooler
            1 hour ago











          • Ok, thanks bro. I'll do this tomorrow 'cause it's 20 to 4 (A.M) in France.

            – SebMa
            1 hour ago













          2












          2








          2







          You're requesting the volume to shrink by 11GB, yet you only have about 6GB unallocated.



          You can more efficiently use allocated extents by rebalancing the volume. Executing a command similar to btrfs balance start /home will start that process, and it may take some time to complete.



          But I don't know if that will free up enough for a large amount of shrinkage.






          share|improve this answer













          You're requesting the volume to shrink by 11GB, yet you only have about 6GB unallocated.



          You can more efficiently use allocated extents by rebalancing the volume. Executing a command similar to btrfs balance start /home will start that process, and it may take some time to complete.



          But I don't know if that will free up enough for a large amount of shrinkage.







          share|improve this answer












          share|improve this answer



          share|improve this answer










          answered 2 hours ago









          SpoolerSpooler

          6,0591127




          6,0591127












          • I though I add 14.31GiB free according to this : Free (estimated): 17.29GiB (min: 14.31GiB)

            – SebMa
            1 hour ago






          • 1





            But you're requesting a volume change, which deals with allocated extents rather than how they're used. You could have almost the entire volume "free", but if the whole thing is "allocated" you can't shrink it. Running a rebalance will reallocate used data in a more efficient way.

            – Spooler
            1 hour ago











          • Ok, thanks bro. I'll do this tomorrow 'cause it's 20 to 4 (A.M) in France.

            – SebMa
            1 hour ago

















          • I though I add 14.31GiB free according to this : Free (estimated): 17.29GiB (min: 14.31GiB)

            – SebMa
            1 hour ago






          • 1





            But you're requesting a volume change, which deals with allocated extents rather than how they're used. You could have almost the entire volume "free", but if the whole thing is "allocated" you can't shrink it. Running a rebalance will reallocate used data in a more efficient way.

            – Spooler
            1 hour ago











          • Ok, thanks bro. I'll do this tomorrow 'cause it's 20 to 4 (A.M) in France.

            – SebMa
            1 hour ago
















          I though I add 14.31GiB free according to this : Free (estimated): 17.29GiB (min: 14.31GiB)

          – SebMa
          1 hour ago





          I though I add 14.31GiB free according to this : Free (estimated): 17.29GiB (min: 14.31GiB)

          – SebMa
          1 hour ago




          1




          1





          But you're requesting a volume change, which deals with allocated extents rather than how they're used. You could have almost the entire volume "free", but if the whole thing is "allocated" you can't shrink it. Running a rebalance will reallocate used data in a more efficient way.

          – Spooler
          1 hour ago





          But you're requesting a volume change, which deals with allocated extents rather than how they're used. You could have almost the entire volume "free", but if the whole thing is "allocated" you can't shrink it. Running a rebalance will reallocate used data in a more efficient way.

          – Spooler
          1 hour ago













          Ok, thanks bro. I'll do this tomorrow 'cause it's 20 to 4 (A.M) in France.

          – SebMa
          1 hour ago





          Ok, thanks bro. I'll do this tomorrow 'cause it's 20 to 4 (A.M) in France.

          – SebMa
          1 hour ago

















          draft saved

          draft discarded
















































          Thanks for contributing an answer to Server Fault!


          • Please be sure to answer the question. Provide details and share your research!

          But avoid


          • Asking for help, clarification, or responding to other answers.

          • Making statements based on opinion; back them up with references or personal experience.

          To learn more, see our tips on writing great answers.




          draft saved


          draft discarded














          StackExchange.ready(
          function ()
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fserverfault.com%2fquestions%2f960860%2fcannot-shrink-btrfs-filesystem-although-there-is-still-data-and-metadata-space-l%23new-answer', 'question_page');

          );

          Post as a guest















          Required, but never shown





















































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown

































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown







          G14AA2vNp 1tsBlP1
          xK7muVr,JC4osz1RiFVC,E,SXMmuPP cvIbN7 c0tp2Dk

          Popular posts from this blog

          What is the result of assigning to std::vector::begin()? The Next CEO of Stack OverflowWhat are the differences between a pointer variable and a reference variable in C++?What does the explicit keyword mean?Concatenating two std::vectorsHow to find out if an item is present in a std::vector?Why is “using namespace std” considered bad practice?What is the “-->” operator in C++?What is the easiest way to initialize a std::vector with hardcoded elements?What is The Rule of Three?What are the basic rules and idioms for operator overloading?Why are std::begin and std::end “not memory safe”?

          Creating centerline of river in QGIS? The 2019 Stack Overflow Developer Survey Results Are In Announcing the arrival of Valued Associate #679: Cesar Manara Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern)Finding centrelines from polygons in QGIS?Splitting line into two lines with GRASS GIS?Centroid of the equator and a pointpostgis: problems creating flow direction polyline; not all needed connections are drawnhow to make decent sense from scattered river depth measurementsQGIS Interpolation on Curved Grid (River DEMs)How to create automatic parking baysShortest path creation between two linesclipping layer using query builder in QGISFinding which side of closest polyline point lies on in QGIS?Create centerline from multi-digitized roadway lines Qgis 2.18Getting bathymetric contours confined only within river banks using QGIS?

          SQL Server 2016 - excessive memory grant warning on poor performing query The Next CEO of Stack OverflowFix for slow SQL_INLINE_TABLE_VALUED_FUNCTIONLarge memory grant requestsPoor performing Query -Tsql execution plan - estimated number of rows =1 Paste the PlanMSSQL - Query had to wait for memory grantRow estimates always too lowBad performance using “NOT IN”Warning about memory “Excessive Grant” in the query plan - how to find out what is causing it?Optimizing table valued function SQL ServerWhen does SQL Server warn about an Excessive Memory Grant?Warning in Execution Plan