January 8, 2010 at 2:37 pm
I'm new in SSAS, and I'm trying to find out where the files of an analysis-services database are located.
I'm looking in SSMS, but I can't figure out where this info is exposed.
Anyone can help me with this?
Any links and additional info on this would be greatly appreciated.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
January 8, 2010 at 2:46 pm
Right-click on the Analysis Services instance in SSMS, go to properties, and look at the DataDir property. This should correspond with where the files are on disk.
As far as additional resources on SSAS, I've found Bill Pearson's series of articles very helpful. You can find them out on DatabaseJournal.com or use this lins. He's got a couple of series on this link, one for SSAS and one for MDX.
January 8, 2010 at 2:50 pm
Marios Philippopoulos (1/8/2010)
I'm new in SSAS, and I'm trying to find out where the files of an analysis-services database are located.I'm looking in SSMS, but I can't figure out where this info is exposed.
Anyone can help me with this?
Any links and additional info on this would be greatly appreciated.
You will find Dimension and Fact tables in the list of tables, so look for DIM and Fact in the table names.
Kind regards,
Gift Peddie
January 8, 2010 at 2:51 pm
John Rowan (1/8/2010)
Right-click on the Analysis Services instance in SSMS, go to properties, and look at the DataDir property. This should correspond with where the files are on disk.As far as additional resources on SSAS, I've found Bill Pearson's series of articles very helpful. You can find them out on DatabaseJournal.com or use this lins. He's got a couple of series on this link, one for SSAS and one for MDX.
Thank you, much appreciated.
The DataDir setting is instance-wide; any way to get this info at the database level, in case databases have been moved to locations other than what is specified in DataDir?
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
January 8, 2010 at 3:14 pm
Not that I know of. It looks to be just instance level. This sounds counter productive considering the nature of Analysis Services and how it is file based which would make the I/O load the determining factor for performance unlike a RDBMS where memory is pretty dang important. Having multiple cube files in the same directory sounds like a contention issue.
I'm not a SSAS guru by any means and I'm just learning much of this myself. I do have a cube that is not performing like I'd like so I will be looking into cube performance improvements. I'll let you know if I learn otherwise.
January 8, 2010 at 3:19 pm
By the way, the last 2 articles in Bill Pearson's link deal with cube storage and partition management. These may contain the info that you're looking for.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply