Windows 10: how do we get list of aggregations which are unused on the cube ?

Sql server version: 2016

Is there a way to know if aggregation on the cube is unused ? I have tried to get the information on the DMVs $system.discover_object_activity (gives me count of aggregations on a partitions/measure groups being hit or missed) and $system.discover_partition_stat (aggregation name and its processed state). But I am not able to get information if a aggregation is left unused, like a list of aggregations which have been used/unused

The cube which is being investigated has over 200 aggregations. It is cumbersome to manually go through each one of them and check for the combinations. Any help is appreciated.

:)

 

Overclocking / Undervolting guide for Vega 56 or 64?

Here's a quick laundry list:

List of software to use for overclocking and testing
Examples:
Wattman (and how to find and use it, like an overview, including profiles)
Unigine Valley or Heaven (use this for quick testing while changing settings in Wattman and checking for stability / artifacts) ...just suggesting this
How to monitor cores / mem speeds and temps during testing (I've seen screen overlays, and others using GPUz)

Step-by step overclocking in Wattman
Fan speeds
Power limit
Temp limit
Voltages
Core speeds
Memory speeds

 

AMD FX OC'ers Club

That's what the auto setting will do since you're over the 1333 mark it jumps to the next step which isn't listed or officially supported I assume by that ram.

At this point though I would suggest dropping the multi one step or .5 so that we can get something stable and possibly take the heat issue out of the picture for now.

 

Cheap Photo box that will get the job done

WEll i took on this project for PP hes a hardware reviewer and wants to get the professional looking pics for the Pc parts

Materials:

• Big cardboard box

• a razor

• white material 3 yards

• cone lights

• stapler

• medical tape

• pvc pipe about 6 inches longer than your box

• white paint any cheap finger paint would work

the project I'm guessing will cost me $30 if it works out properly
I will post pictures and step by step as i do it