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
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
© 2022 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy