Spotlight does not collect data for databases that have auto_close set because it negates the purpose of having that set. If Spotlight did collect data for these databases then the database would be opening and closing as the monitoring scripts ran (quite possibly very frequently) and this may cause performance problems.
In addition, the auto_close feature would be recommended to be turned off in most of cases and also will be removed in future.
See below link:
https://msdn.microsoft.com/en-us/library/ms135094(SQL.90).aspx
http://blogs.msdn.com/b/buckwoody/archive/2009/06/24/sql-server-best-practices-autoclose-should-be-off.aspx
To see this data in Spotlight turn off this setting against these databases.
