SQL Server Performance

WMI Provider

Discussion in 'General DBA Questions' started by Trev256, Nov 10, 2010.

  1. Trev256 New Member

    1) How do I check the WMI (windows management instrumentation) provider is installed and enabled on a sql server 2000 box?
    2) Is this provide automatically installed for SQL server 2005 and 2008?
    Thanks!
  2. FrankKalis Moderator

  3. Trev256 New Member

    Hi Frank
    these links state if u install and enable wmi provider for sql server 2000 then it creates root/MicrosoftSQLServer namespace and populates with definitions of all SQL Server classes. The link does not explain how to check if this exists. Do you know how i can check the WMI provider has been installed and enabled????
    also, this suggests SQL server 2005 automatically installs and enables the wmi provider but it does not explicitly state this. Can you confirm 2005 does install and enable the wmi provider????
    Thanks
  4. satya Moderator

    From Control panel go to Services and make sure following are running:
    -. SQL Server (MSSQLServer)
    -. Windows Management Instrumentation


    If you have Windows Management Instrumentation Driver Extension, try to start it as well. Now, open a command prompt and go to folder C:program FilesMicrosoft SQL Server90Shared and execute:

    mofcomp "C:program FilesMicrosoft SQL Server90Sharedsqlmgmproviderxpsp2up.mof

  5. Trev256b Member

    hi satya - why would it be a good idea to start the WMI driver extension too? what is this for?
  6. satyaskj New Member

    Trev, this is required by the SETUP to do pre-installation checks by Software COnfiguration Checket.

Share This Page