If you're like me (again) the tuning of instances SSAS 2005, you certainly know the properties LowMemoryLimit (LML) and TotalMemoryLimit (TML). The purpose of this post is not to present the function of these two elements: for that you'll find information here (page 92).
Edit of 08/10/2010: I just found a very good blog post from Francis Jehl explains the intricacies of this setup: see here
AS 2008 introduces a new property for its business model of memory: the HardMemoryLimit (HML). Few documents speak of this property. I found a reference here (thank you Thomas).
AS 2008 introduces a new property for its business model of memory: the HardMemoryLimit (HML). Few documents speak of this property. I found a reference here (thank you Thomas).
The HML is setting the same way as the TML and TML. It allows you to enter an even more aggressive garbage collection: if need the whole memory shrinkable will be emptied as well as current orders (processing and motion) may be canceled.
Beware however, similarly to the TML and TML, the HML is not a physical limit of memory consumption, which makes us also think that his name is a misnomer.
Source:
0 comments:
Post a Comment