This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
windows:powershell:inserttablestats [2013/10/14 22:13] 127.0.0.1 external edit |
windows:powershell:inserttablestats [2018/05/14 22:00] (current) |
||
---|---|---|---|
Line 69: | Line 69: | ||
$dataIndexArray | $dataIndexArray | ||
} | } | ||
- | function storeDataIndexIntoSysMetrics($sql) | + | function storeDataIndexIntoJiMetrics($sql) |
{ | { | ||
- | $serverResults = Invoke-Sqlcmd -ServerInstance "sql1" -Database "SysMetrics" -Query $sql | + | $serverResults = Invoke-Sqlcmd -ServerInstance "sql1" -Database "JiMetrics" -Query $sql |
$serverResults | forEach { | $serverResults | forEach { | ||
$ServerInstance, $ServerSID = $_.InstanceName, $_.InstanceID | $ServerInstance, $ServerSID = $_.InstanceName, $_.InstanceID | ||
Line 89: | Line 89: | ||
$SchemaName, $tableName, $TotalRowCount, $DataSizeInMB, $IndexSizeInMB = $_.Schema, $_.tableName, $_.TotalRowCount, $_.DataSizeInMB, $_.IndexSizeInMB | $SchemaName, $tableName, $TotalRowCount, $DataSizeInMB, $IndexSizeInMB = $_.Schema, $_.tableName, $_.TotalRowCount, $_.DataSizeInMB, $_.IndexSizeInMB | ||
$sql = "EXEC Windows.TableStats_Insert $ServerSID, '$DbName', '$SchemaName', $tableName, $TotalRowCount, $DataSizeInMB, $IndexSizeInMB" | $sql = "EXEC Windows.TableStats_Insert $ServerSID, '$DbName', '$SchemaName', $tableName, $TotalRowCount, $DataSizeInMB, $IndexSizeInMB" | ||
- | Invoke-Sqlcmd -Query $sql -ServerInstance "sql1" -Database "SysMetrics" | + | Invoke-Sqlcmd -Query $sql -ServerInstance "sql1" -Database "JiMetrics" |
} } } } } | } } } } } | ||
Line 96: | Line 96: | ||
Windows.Instance_Select_InstanceID_InstanceName | Windows.Instance_Select_InstanceID_InstanceName | ||
"@ | "@ | ||
- | storeDataIndexIntoSysMetrics -sql $sql | + | storeDataIndexIntoJiMetrics -sql $sql |
</code> | </code> |