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 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;
windows/windowsstart.txt ยท Last modified: 2018/05/14 22:00 (external edit)