Spotlight on SQL Server Enterprise 11.7 - Release Notes

WMI and Analysis Services

Analysis Services Queries

Default instance:

For named instances 2005/2008 the command should be the following:

wmic /node: HOSTNAME /user: DOMAIN\USER path Win32_PerfRawData_MSOLAPINSTANCENAME_MSOLAPINSTANCENAMEStorageEngineQuery get AvgtimePerquery

The customer should run the command below :

wmic /node: HOSTNAME /user: DOMAIN\USER path Win32_PerfRawData_MSOLAPPROD_MSOLAPPRODStorageEngineQuery get AvgtimePerquery

wmic /node: HOSTNAME /user: DOMAIN\USER path Win32_PerfRawData_MSSQLServerOLAPService_MSAS2005StorageEngineQuery get AvgtimePerquery

wmic /node: HOSTNAME /user: DOMAIN\USER path Win32_PerfRawData_MSSQLServerOLAPService_MSAS2008StorageEngineQuery get AvgtimePerquery

Named instance:

wmic /node: HOSTNAME /user: DOMAIN\USER path Win32_PerfRawData_MSOLAPINSTANCENAME_MSOLAPINSTANCENAMEStorageEngineQuery get AvgtimePerquery

wmic /node: HOSTNAME /user: DOMAIN\USER path Win32_PerfRawData_MSOLAPINSTANCENAME_MSOLAPINSTANCENAMEStorageEngineQuery get AvgtimePerquery

HOSTNAME – Windows host name

DOMAIN\USER – Windows login credentials

INSTANCENAME – SQL Server instance name

WMI Classes

wmic path Win32_BIOS

Win32_Processor

Win32_CacheMemory

Win32_DiskDrive

Win32_PhysicalMemory

Win32_OperatingSystem wmic path Win32_OperatingSystem get Caption, CSDVersion, Version, OSArchitecture

Win32_BootConfiguration

Win32_Product

wmic path win32_PhysicalMemory get name, capacity, DeviceLocator, Speed

Related Links

WMI errors