This shows you the differences between two versions of the page.
windows:powershell:powershellstart [2013/11/05 11:23] haidong removed reference to sysmetrics |
windows:powershell:powershellstart [2018/05/14 22:00] |
||
---|---|---|---|
Line 1: | Line 1: | ||
- | PowerShell is Microsoft's scripting language/shell that comes with Windows server and desktop per-installed nowadays. It has tight integration with the operating system and Microsoft's various server products. For automating tasks on Windows, it is a pretty compelling choice because of this bundling. | ||
- | PowerShell runs on Windows only, so it is not a good choice in doing cross-platform metrics data gathering and scripting. | ||
- | |||
- | 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:jimetrics|metrics database has been created]] and server Host table populated. | ||
- | * [[windows:powershell:insertstorage|Windows server disk metrics gathering]] | ||
- | * [[windows:powershell:insertinstance|SQL Server instance discovery]] | ||
- | * [[windows:powershell:updateinstance|SQL Server instance info gathering]] | ||
- | * [[windows:powershell:insertdbfilestats|SQL Server database file metrics gathering]] | ||
- | * [[windows:powershell:inserttablestats|SQL Server database table metrics gathering]] |