It's all about the answers!

Ask a question

What is the latest-metrics-by-namespace-report means?

Jia Jia Li (8057154192) | asked Sep 23 '13, 10:25 a.m.
edited Sep 23 '13, 8:19 p.m. by Millard Ellingsworth (2.5k12431)
The db is growth fast. So I run this report to check what component determin the growth. 
I see "Footprint", "item count","State count" charts. 
What these three charts means?
And what the Y variety means? I can guess some, is there full explain?

One answer

permanent link
Stephanie Bagot (2.1k1513) | answered Oct 02 '13, 3:13 p.m.
The footprint will tell you how much space each component takes up in the DB. This is available in compressed and uncompressed reports. Item count will tell you how many items in the component are found.
Once you have identified which component takes up the most of your DB, for example, you can run a deeper report on that component which will further seperate the information into build components.

Some tips for large DB:
-RTC will run item cleanups daily (sometimes frequently throughout the day) to help clean stale data. You can investigate increasing this task, or the expiration time of these items (located in Advanced Properties).
-You can also run the onlineverify to ensure the consistency of the data and that there is no corruption which may be preventing the item clean up from running.
-ensure all your builds are being pruned and any results cleaned up

Lastly, I would also recommend reaching out to your DBA and running a compact or reorg on the DB to ensure any empty space is utilized.

Your answer

Register or to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.