James Rogers

BI from the trenches...
posts - 13, comments - 25, trackbacks - 0

My Links

News

Archives

Post Categories

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...
  • Share This Post:
  • Share on Twitter
  • Share on Facebook
  • Share on Technorati

Posted On Tuesday, January 22, 2008 6:47 PM | Feedback (10) | Filed Under [ Analysis Services ]

Powered by: