SQL Server Blogs

Voices from the UK SQL Server Community
All Tags » tsql » WMI » CLR » Performance (RSS)

Browse by Tags

  • Accessing OS performance counters from tsql

    A cool use of WMI data from within SQL that I have found is getting to OS perfmon data. There are several ways of doing it. I would say the best practice would be CLR if you need it in real time or SSIS if you are logging to a table for reporting purposes. You can also hit it through xp_cmdshell and...
    Posted to Jason Massie's SQL blog (Weblog) by JasonMassie on Fri, Nov 30 2007
Page 1 of 1 (1 items)
Powered by Community Server (Commercial Edition), by Telligent Systems