In SQL Monitor, I want to...

Identify and alert on heap fragmentation

Currently SQL Monitor does not have a way to identify and alert on heap fragmentation. I suggest you add this to the product.

I know having a heap is usually a bad idea and that heap maintenance is a pain (rebuilding a heap also rebuilds all the nonclustered indexes on it, SQL Server doesn't release a page of a heap table, and doesn't use free space in previously used pages unless you are doing deletes with TABLOCK hints), but there are some valid use cases for heaps.

10 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Blaž Dakskobler shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    0 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...

      Feedback and Knowledge Base