What is VertiPaq Analyzer?

The VertiPaq Analyzer serves as an essential resource for scrutinizing the data storage frameworks within Power BI and Analysis Services Tabular. It encompasses various metrics related to different segments and partitions, including pageable, resident, refresh date, and last access information. Dynamic Management Views (DMVs) provided by Analysis Services allow for the collection of valuable insights regarding the memory consumption of a data model. For example, the DISCOVER_OBJECT_MEMORY_USAGE DMV provides comprehensive information about all objects currently held in memory. This type of DMV is also beneficial for effectively tracking a Multidimensional instance of Analysis Services. A significant contribution to this field is the BISM Memory Report by Kasper de Jonge, which is a sample model that displays this information in a hierarchical format, enabling users to pinpoint the databases, tables, and columns that consume the most resources on a server. If you are interested in exploring a particular database further, more detailed insights can be accessed through additional specialized DMVs. By familiarizing yourself with these tools and understanding their functionalities, you can greatly improve your data management approaches and overall efficiency. Moreover, leveraging these insights can assist in optimizing system performance and resource allocation.

Pricing

Free Version:
Free Version available.

Screenshots and Video

VertiPaq Analyzer Screenshot 1

Company Facts

Company Name:
SQLBI
Date Founded:
2004
Company Location:
United States
Company Website:
www.sqlbi.com/tools/vertipaq-analyzer/

Product Details

Deployment
Windows
Training Options
Documentation Hub
Video Library
Support
Web-Based Support

Product Details

Target Company Sizes
Individual
1-10
11-50
51-200
201-500
501-1000
1001-5000
5001-10000
10001+
Target Organization Types
Mid Size Business
Small Business
Enterprise
Freelance
Nonprofit
Government
Startup
Supported Languages
English

VertiPaq Analyzer Categories and Features

Data Analysis Software

Data Discovery
Data Visualization
High Volume Processing
Predictive Analytics
Regression Analysis
Sentiment Analysis
Statistical Modeling
Text Analytics