windows:windowsstart
Differences
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:21] haidong Major surgery to make this easy to follow. |
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; | ||
| * The domain account SQL Server Agent jobs run under must have: | * The domain account SQL Server Agent jobs run under must have: | ||
| - | * A domain account that has: | + | * Administrative access to all server hosts you intend to collect metrics data from |
| - | * Administrative access to all server hosts you intend to collect metrics data from | + | * sysadmin access to all SQL Server instances you intend to collect metrics data from |
| - | * sysadmin access to all SQL Server instances you intend to collect metrics data from | + | * dbo access to the JiMetrics database. |
| - | * dbo access to the JiMetrics database. | + | * Manual steps needed are minimal. If you create steps in the order that is presented in this page, you will be fine. Each PowerShell script corresponds to one SQL Server Agent job. Inside the PowerShell script, it knows which stored procedure to call, which Hosts are involved, what metrics to gather, and which table to put that metrics into. |
| - | * Manual steps needed are minimal. If you create steps in the order that is presented in this page, you will be fine. Each PowerShell script corresponds to one SQL Server Agent job. Inside the PowerShell script, it knows which stored procedure to call, which Hosts are involved, what metrics to gather, and which table to put that metrics into. Here is a pretty typical use case: | + | |
| * Once you've started collecting for a while, you will certainly be able to get a lot out of this information. There are very few tables involved so the database is pretty easy to query against. I suggest you follow the [[db:sqlserver:jimetrics|database diagram]] for help. | * Once you've started collecting for a while, you will certainly be able to get a lot out of this information. There are very few tables involved so the database is pretty easy to query against. I suggest you follow the [[db:sqlserver:jimetrics|database diagram]] for help. | ||
windows/windowsstart.1392870061.txt.gz · Last modified: 2018/05/14 21:58 (external edit)
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
