• Pull logical reads SP's

    Hi ,

    I need to pull data from Spotlight repository like what gets displayed in 'Workload analysis page' ( sorted by Logical reads , CPU ) and store it somewhere for custom reporting . 

    Can someone please provide the query to get this info ? 

    Is…

  • Spotlight on SQL Server - Powershell API

    I am highly interested in expansion of the Powershell API to automate administration tasks.  When dealing with hundreds of connections, working through the GUI is not preferable.