This shows you the differences between two versions of the page.
Next revision Both sides next revision | |||
windows:powershell:powershellstart [2013/10/15 15:47] haidong created |
windows:powershell:powershellstart [2013/11/05 11:23] haidong removed reference to sysmetrics |
||
---|---|---|---|
Line 5: | Line 5: | ||
Below are scripts that should be scheduled as SQL Server Agent job steps to gather Windows server and SQL Server related metrics data. | Below are scripts that should be scheduled as SQL Server Agent job steps to gather Windows server and SQL Server related metrics data. | ||
- | * [[windows:powershell:updatehost|Windows server info gathering]], assuming [[db:sqlserver:sysmetrics|metrics database has been created]] and server Host table populated. | + | * [[windows:powershell:updatehost|Windows server info gathering]], assuming [[db:sqlserver:jimetrics|metrics database has been created]] and server Host table populated. |
* [[windows:powershell:insertstorage|Windows server disk metrics gathering]] | * [[windows:powershell:insertstorage|Windows server disk metrics gathering]] | ||
* [[windows:powershell:insertinstance|SQL Server instance discovery]] | * [[windows:powershell:insertinstance|SQL Server instance discovery]] |