This project is read-only.

SQLPSX 2.3.1 "import-module sqlpsx" not loading Perfmon module?

Dec 17, 2010 at 9:21 PM
Edited Dec 17, 2010 at 9:37 PM

Isn't 2.3.1 supposed to have Laerte Junior's extensions to use PowerShell to manage PerfMon traces?

This is my output:

PS C:\Windows\system32> import-module sqlpsx
No Oracle found
Loading SQLPSX Module - SQLmaint
Loading SQLPSX Module - SQLServer
Loading SQLPSX Module - Agent
Loading SQLPSX Module - Repl
Loading SQLPSX Module - SSIS
Loading SQLPSX Module - Showmbrs
Loading SQLPSX Module - SQLParser
Loading SQLPSX Module - adolib
Loading SQLPSX Modules is Done!

This would appear to be at odds with the Release Notes for SQLPSX 2.3.1, which say:

Release 2.3.1 implements SQLPSX as PowersShell version 2.0 modules. SQLPSX consists of 12 modules with 155 advanced functions, 2 cmdlets and 7 scripts for working with ADO.NET, SMO, Agent, RMO, SSIS, SQL script files, PBM, Performance Counters, SQLProfiler and using Powershell ISE as a SQL and Oracle query tool. In addition optional backend databases and SQL Server Reporting Services 2008 reports are provided with SQLServer and PBM modules. See readme file for details.
Dec 17, 2010 at 10:19 PM

2.3.1 include Laerte's modules but they are not imported with the sqlpsx module. You need to run:


import-module PerfCounters


import-module SQLProfiler


get-module -listavailable


Dec 20, 2010 at 7:01 PM

Thanks for helping me out.  I am coming up to speed on PowerShell 2.0.  Neat stuff!