{"id":35,"date":"2007-10-19T21:45:37","date_gmt":"2007-10-20T02:45:37","guid":{"rendered":"http:\/\/www.ssas-info.com\/VidasMatelisBlog\/35_analysis-services-property-enablefast1033locale-for-english-installations"},"modified":"2008-03-17T20:52:10","modified_gmt":"2008-03-18T01:52:10","slug":"analysis-services-property-enablefast1033locale-for-english-installations","status":"publish","type":"post","link":"http:\/\/www.ssas-info.com\/VidasMatelisBlog\/35_analysis-services-property-enablefast1033locale-for-english-installations","title":{"rendered":"Analysis Services property EnableFast1033Locale for English installations"},"content":{"rendered":"<p>I was looking into some issues with using Analysis Services translations and found not related to my problem, but new to me information\u00a0about\u00a0SSAS configuration property <strong>EnableFast1033Locale<\/strong>.\u00a0From BOL:<\/p>\n<blockquote><p>If you use the English (United States) language identifier (0x0409, or 1033) as the default language for the Analysis Services instance, you can get additional performance benefits by setting the <strong>EnableFast1033Locale<\/strong> configuration property, an advanced configuration property available only for that language identifier. Setting the value of this property to <strong>true<\/strong> enables Analysis Services to use a faster algorithm for string hashing and comparison.<\/p><\/blockquote>\n<p>I found this properly in the msmdsrv.ini file (default folder: C:\\Program Files\\Microsoft SQL Server\\MSSQL.2\\OLAP\\Config):<\/p>\n<blockquote><p>\u00a0&lt;EnableFast1033Locale&gt;0&lt;\/EnableFast1033Locale&gt;<\/p><\/blockquote>\n<p>I did some tests and found\u00a0that you have to drop all databases from SSAS server before you change property value to 1.\u00a0Then you have to restart server and re-deploy and re-process all databases. I found that even Adventure Works DW database would not work without redeployment. My other test databases were also giving me\u00a0different errors until I redeployed and reprocessed them.<\/p>\n<p>I could not see performance differences on my small tests databases. But for a big installations with 1033 locale it could be worth to see if this could give you some performance boost.<\/p>\n<p>As as side effect I noticed, that when EnableFast1033Locale property value is set to 1, in Microsoft SQL Server Management Studio server properties window was always giving me error when clicking on &#8220;OK&#8221; button:<\/p>\n<blockquote><p>TITLE: Microsoft SQL Server Management Studio<br \/>\n&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;<br \/>\nErrors in the metadata manager. LOG file extension can be only .LOG.<br \/>\nErrors in the metadata manager. An error occurred while setting the value for the &#8216;ConfigurationSettings\\Log\\File&#8217; configuration property.<br \/>\n\u00a0(Microsoft.AnalysisServices)<\/p><\/blockquote>\n<p>To go around this problem just change required property values directly in msmdsrv.ini file.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I was looking into some issues with using Analysis Services translations and found not related to my problem, but new to me information\u00a0about\u00a0SSAS configuration property EnableFast1033Locale.\u00a0From BOL: If you use the English (United States) language identifier (0x0409, or 1033) as the default language for the Analysis Services instance, you can get additional performance benefits by [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[4],"tags":[],"aioseo_notices":[],"_links":{"self":[{"href":"http:\/\/www.ssas-info.com\/VidasMatelisBlog\/wp-json\/wp\/v2\/posts\/35"}],"collection":[{"href":"http:\/\/www.ssas-info.com\/VidasMatelisBlog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.ssas-info.com\/VidasMatelisBlog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.ssas-info.com\/VidasMatelisBlog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.ssas-info.com\/VidasMatelisBlog\/wp-json\/wp\/v2\/comments?post=35"}],"version-history":[{"count":0,"href":"http:\/\/www.ssas-info.com\/VidasMatelisBlog\/wp-json\/wp\/v2\/posts\/35\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.ssas-info.com\/VidasMatelisBlog\/wp-json\/wp\/v2\/media?parent=35"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.ssas-info.com\/VidasMatelisBlog\/wp-json\/wp\/v2\/categories?post=35"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.ssas-info.com\/VidasMatelisBlog\/wp-json\/wp\/v2\/tags?post=35"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}