Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision |
| windows:powershell:powershellstart [2013/10/15 20:47] – created haidong | windows:powershell:powershellstart [2018/05/15 03:00] (current) – external edit 127.0.0.1 |
|---|
| 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]] |
| * [[windows:powershell:updateinstance|SQL Server instance info gathering]] | * [[windows:powershell:updateinstance|SQL Server instance version/edition info and running status gathering]] |
| | * [[windows:powershell:insertinstanceconfig|SQL Server instance configuration gathering]] |
| | * [[windows:powershell:insertinstancedmvperfcounter|SQL Server instance performance counters gathering]] |
| * [[windows:powershell:insertdbfilestats|SQL Server database file metrics gathering]] | * [[windows:powershell:insertdbfilestats|SQL Server database file metrics gathering]] |
| * [[windows:powershell:inserttablestats|SQL Server database table metrics gathering]] | * [[windows:powershell:inserttablestats|SQL Server database table metrics gathering]] |
