This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
windows:windowsstart [2014/02/19 22:23] haidong Domain account permission clarification and other minor changes |
windows:windowsstart [2018/05/14 22:00] (current) |
||
---|---|---|---|
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 into the rest of the page: | + | 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; |