windows:windowsstart
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| windows:windowsstart [2014/02/20 04:23] – Domain account permission clarification and other minor changes haidong | windows:windowsstart [2018/05/15 03:00] (current) – external edit 127.0.0.1 | ||
|---|---|---|---|
| Line 2: | Line 2: | ||
| Here are step by step instructions on setting up a process to collect Windows and SQL Server related metrics data. Most of the automation scripts are written in PowerShell. To be honest, given a choice, I'd rather write my tools in either Python or Perl. However, on Windows systems, those languages require a separate install, whereas PowerShell is present already. That, plus the tight integration between PowerShell and Windows (and other Microsoft server products), makes starting with PowerShell pretty compelling. I may present the same tools written in Python, Perl, and/or other languages if/when I develop them. | Here are step by step instructions on setting up a process to collect Windows and SQL Server related metrics data. Most of the automation scripts are written in PowerShell. To be honest, given a choice, I'd rather write my tools in either Python or Perl. However, on Windows systems, those languages require a separate install, whereas PowerShell is present already. That, plus the tight integration between PowerShell and Windows (and other Microsoft server products), makes starting with PowerShell pretty compelling. I may present the same tools written in Python, Perl, and/or other languages if/when I develop them. | ||
| - | Setting this up is pretty easy. Here is a quick overview before we delve into the details | + | Setting this up is pretty easy. Here is a quick overview before we delve into the details: |
| * We will need to create a SQL Server database, JiMetrics, to store metrics data; | * We will need to create a SQL Server database, JiMetrics, to store metrics data; | ||
| * The collection process relies on SQL Server Agent; | * The collection process relies on SQL Server Agent; | ||
windows/windowsstart.1392870180.txt.gz · Last modified: (external edit)
