windows:powershell:insertdbfilestats
Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
windows:powershell:insertdbfilestats [2013/10/14 22:13] 127.0.0.1 external edit |
windows:powershell:insertdbfilestats [2018/05/14 22:00] (current) |
||
|---|---|---|---|
| Line 43: | Line 43: | ||
| function storeDbFileInfo($sql) | function storeDbFileInfo($sql) | ||
| { | { | ||
| - | $serverResults = Invoke-Sqlcmd -ServerInstance "sql1" -Database "SysMetrics" -Query $sql | + | $serverResults = Invoke-Sqlcmd -ServerInstance "sql1" -Database "JiMetrics" -Query $sql |
| $serverResults | forEach { | $serverResults | forEach { | ||
| $InstanceName, $InstanceID = $_.InstanceName, $_.InstanceID | $InstanceName, $InstanceID = $_.InstanceName, $_.InstanceID | ||
| Line 61: | Line 61: | ||
| $FileLogicalName, $FilePhysicalName, $FileGroupName, $FileSizeInMB, $FreeSizeInMB, $max_size, $growth, $is_percent_growth = $_.FileLogicalName, $_.FilePhysicalName, $_.FileGroupName, $_.FileSizeInMB, $_.FreeSizeInMB, $_.max_size, $_.growth, $_.is_percent_growth | $FileLogicalName, $FilePhysicalName, $FileGroupName, $FileSizeInMB, $FreeSizeInMB, $max_size, $growth, $is_percent_growth = $_.FileLogicalName, $_.FilePhysicalName, $_.FileGroupName, $_.FileSizeInMB, $_.FreeSizeInMB, $_.max_size, $_.growth, $_.is_percent_growth | ||
| $sql = "EXEC Windows.DbFileStats_Insert $InstanceID, '$DbName', '$FileLogicalName', '$FilePhysicalName', '$FileGroupName', $FileSizeInMB, $FreeSizeInMB, $max_size, $growth, '$is_percent_growth'" | $sql = "EXEC Windows.DbFileStats_Insert $InstanceID, '$DbName', '$FileLogicalName', '$FilePhysicalName', '$FileGroupName', $FileSizeInMB, $FreeSizeInMB, $max_size, $growth, '$is_percent_growth'" | ||
| - | Invoke-Sqlcmd -Query $sql -ServerInstance "sql1" -Database "SysMetrics" | + | Invoke-Sqlcmd -Query $sql -ServerInstance "sql1" -Database "JiMetrics" |
| } } } } } | } } } } } | ||
windows/powershell/insertdbfilestats.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
