Geeks With Blogs
James Rogers BI from the trenches... January 2008 Entries
Finding and killing SSAS Sessions
If you have a reasonably large Analysis Services implementation with users running adhoc queries via multiple tools (ProClarity, Excel, etc...) then you have probably run into problems with long-running queries. While longer-running queries may be acceptable in many data warehousing implementations, there will occasionally be a query (maybe even more than one ;) ) that causes resource issues and runs beyond the established limits of reason for your environment. Analysis Services does not have a native ......

Posted On Tuesday, January 22, 2008 6:47 PM

Copyright © James Rogers | Powered by: