Querying Database Size using WMI on SQL 2005.. issue..

• mirde

  Ten Centuries

  Points: 1211

  More actions

  July 29, 2009 at 5:41 pm

  #133522

  Hello,

  I am trying to get statistics on a WMI counter, specifically..

  \SQLServer:Databases(DBNAME)\Data File(s) Size (KB)

  The counter returns an error saying that the specified instance of the performance object was not found, but the DBNAME does exist in SQL on that Windows 2003 host.

  Also, I have been able to query other DBs on the same server.. but for some reason, I cannot query it for the 3 databases out of the 15 that I am checking.

  Any idea why the counter is failing?

  Thanks.

• AlexSQLForums

  SSChampion

  Points: 14277

  More actions

  July 29, 2009 at 10:20 pm

  #1032147

  does your wmi user have access to those 3 db's?

  are they set to read_only or offline?

  Alex S