https://www.jimetrics.com/ 2026-05-04T04:45:01-0500 https://www.jimetrics.com/ https://www.jimetrics.com/lib/tpl/dokuwiki/images/favicon.ico text/html 2014-11-11T21:28:42-0500 haidong (haidong@undisclosed.example.com) https://www.jimetrics.com/doku.php?id=db:sqlserver:jimetrics&rev=1415762922&do=diff JiMetrics database creation Since I started with Windows, I will present a SQL Server database design first. Metrics data is typically write-once and read-only, so column-store tables are perfect fits. Toward that end, I've created two versions: the first one, listed below as JiMetrics.sql, is a regular row-based database. The second one uses columnstore for many tables. It is based on SQL Server 2014. It is listed below as JiMetricsColumnstore.sql. text/html 2014-06-16T20:05:22-0500 haidong (haidong@undisclosed.example.com) https://www.jimetrics.com/doku.php?id=windows:powershell:insertinstanceconfig&rev=1402967122&do=diff Here is a PowerShell script to gather SQL Server instance configuration information. It comes from sys.configurations view. Please create a SQL Server Agent job for this. The domain account that this job runs under needs to have proper access to the instances in question and be able to insert data into the JiMetrics database. text/html 2014-06-16T20:03:20-0500 haidong (haidong@undisclosed.example.com) https://www.jimetrics.com/doku.php?id=windows:powershell:updateinstance&rev=1402967000&do=diff After server host SQl Server instance(s) have been discovered, here is a PowerShell script to update those instances with information like SQL Server edition, product version, service pack level, etc. Please create a SQL Server Agent job for this. The domain account that this job runs under needs to have access to the instances. text/html 2014-06-16T20:00:23-0500 haidong (haidong@undisclosed.example.com) https://www.jimetrics.com/doku.php?id=windows:powershell:insertinstance&rev=1402966823&do=diff Here is a PowerShell script to discover SQL Server instances installed on the server hosts in the Host table. Please create a SQL Server Agent job for this. The domain account that this job runs under needs to in the local administrator's group on the host whose metrics it is trying to get. text/html 2014-06-16T19:58:13-0500 haidong (haidong@undisclosed.example.com) https://www.jimetrics.com/doku.php?id=windows:powershell:updatehost&rev=1402966693&do=diff Here is a PowerShell script to gather Windows host info such as OS version, hardware model, memory size, CPU type, core count, BIOS version, BIOS release date, Host hardware serial number. Please create a SQL Server Agent job for this. The domain account that this job runs under needs to in the local administrator's group on the host whose metrics it is trying to get. text/html 2014-02-19T22:23:00-0500 haidong (haidong@undisclosed.example.com) https://www.jimetrics.com/doku.php?id=windows:windowsstart&rev=1392870180&do=diff Windows and SQL Server metrics data capturing 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 s… text/html 2013-12-13T10:17:18-0500 haidong (haidong@undisclosed.example.com) https://www.jimetrics.com/doku.php?id=start&rev=1386951438&do=diff Welcome to JiMetrics My name is Haidong Ji. I created this site to share and improve automation tools that I wrote for server and database management. These tools have been very useful to me, for purposes like: * Server administration * Storage management text/html 2013-11-05T11:44:53-0500 haidong (haidong@undisclosed.example.com) https://www.jimetrics.com/doku.php?id=windows:powershell:powershellstart&rev=1383673493&do=diff PowerShell is Microsoft's scripting language/shell that comes with Windows server and desktop per-installed nowadays. It has tight integration with the operating system and Microsoft's various server products. For automating tasks on Windows, it is a pretty compelling choice because of this bundling.