CODEWITHSUNDEEP
azure-analysis-services
user3843858
user3843858

Reputation: 331

How we get analysis services database size in azure analysis services Tabular model

we want to know analysis services database size after it's deploy on Azure analysis services

Upvotes: 1

Views: 10525

Answers (3)

user3675870
user3675870

Reputation: 11

Use SSMS:

  • Connect via SSMS, right click model name and properties. It will give you an estimated size of your deployed tabular model.

Use Metrics:

  • Under Monitoring Tab of your Azure Server listed in Portal, goto Monitoring->Metrics->From the available list of checkboxes, check Memory.

Hope this helps.

Upvotes: 1

user3529580
user3529580

Reputation: 31

You can use below script to find overall size and model wise size For Azure Analysis server in (MB/GB)

Param($ServerName="<servername>")
$loadInfo = 
[Reflection.Assembly]::LoadWithPartialName(“Microsoft.AnalysisServices”)
$server = New-Object Microsoft.AnalysisServices.Server
$server.connect($ServerName)
if ($server.name -eq $null) {
  Write-Output (“Server ‘{0}’ not found” -f $ServerName)
break
}

$sum=0
foreach ($d in $server.Databases )
{
 Write-Output ( “Database: {0}; Status: {1}; Size: {2}MB” -f $d.Name, 
 $d.State, ($d.EstimatedSize/1024/1024).ToString(“#,##0”) )
 $sum=$sum+$d.EstimatedSize/1024/1024
}

$SizeGB=$Sum/1024

write-host ‘Sum of Database = ‘$sum ‘ MB’
Write-host ‘Total Size of Cube Databases =’ $SizeGB ‘ GB’

Thanks, Mahendar

Upvotes: 3

Sergiy Lunyakin
Sergiy Lunyakin

Reputation: 11

You can use either this http://www.sqlbi.com/tools/vertipaq-analyzer/ or this https://www.kasperonbi.com/new-ssas-memory-usage-report-using-power-bi/ tool.

Upvotes: 1

Related Questions