Differences

This shows you the differences between two versions of the page.

--- windows:powershell:inserttablestats [2013/10/15 03:13] – external edit 127.0.0.1
+++ windows:powershell:inserttablestats [2018/05/15 03:00] (current) – external edit 127.0.0.1
@@ Line 69: / Line 69: @@
     $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 {
         $ServerInstance, $ServerSID = $_.InstanceName, $_.InstanceID
@@ Line 89: / Line 89: @@
                     $SchemaName, $tableName, $TotalRowCount, $DataSizeInMB, $IndexSizeInMB = $_.Schema, $_.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
 "@
-storeDataIndexIntoSysMetrics -sql $sql
+storeDataIndexIntoJiMetrics -sql $sql
 </code>