Thomas LaRock (4/28/2009)
did you also look through the discovery management packs? the SQL packs usually are in pairs, one for dscovery, one for monitoring. do a quick search through all of them (2000/5/8), just to be safe.
Thanks for the reply.
Yes, I just looked at all management packs for SQL, SCOM version 6.0.6460.0, and could not find sp_spaceused.
Here are the MPs I searched (under ...\Program Files\System Center Operations Manager 2007\Health Service State\Management Packs):
Microsoft.SQLServer.2000.Discovery.{0B5A085F-F001-0E39-42B4-807321EE46D4}.{DC14D306-B845-D465-ED80-FFD52DE8DF5E}.xml
Microsoft.SQLServer.2000.Monitoring.{8F1F7C0E-ADC9-2226-BD01-B70C6D1B206D}.{7B6079F9-AF30-8053-50D1-8288DC6D9240}.xml
Microsoft.SQLServer.2005.Discovery.{6A9F98A6-04FB-7740-9429-08D0721CAE7D}.{2FFCE1C9-09C4-D319-9E03-2C4B2665BC64}.xml
Microsoft.SQLServer.2005.Monitoring.{1E1833E1-5E0B-1B28-AF46-933A6861FAE0}.{1C88D85E-8695-2AE7-215A-B6E707DD2D14}.xml
Microsoft.SQLServer.2008.Discovery.{542C15D1-2E58-C85D-8574-84A35AB751E9}.{B18574A1-9304-5FEB-91BF-F128F4A519BD}.xml
There is no monitoring MP for SQL 2008.
I did not find a reference for sp_spaceused in any of these files.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]