The developers just released some code and added a bunch of indexes and now I am seeing all my DATA drives become low on space.
How can I find out the cause of this growth, any advice would be great?
I used this query but not sure if I am on the right path:
asked Mar 19, 2014 at 08:58 PM in Default
That's as good a start as any.
I have used this in the past:
Indexes are subsets of your data. They add space and overhead.
Ask the developers what indexes they added and then look at the data types involved, then count the rows in the table. You may be surprised at A) how much data needed to be duplicated to support the indexes, B) How much data is now entered in multiple storage structures on each insert.
Indexing is a science all to itself - they speed up queries but come at a price.
answered Mar 20, 2014 at 04:05 AM