User Tools

Site Tools


windows:windowsstart

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
windows:windowsstart [2014/02/20 04:23] – Domain account permission clarification and other minor changes haidongwindows: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 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;
windows/windowsstart.1392870180.txt.gz · Last modified: (external edit)