windows:powershell:inserttablestats
Differences
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> | ||
windows/powershell/inserttablestats.1381806784.txt.gz ยท Last modified: 2018/05/14 21:58 (external edit)
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
