SQL Server Performance

help

Discussion in 'Third Party Tools' started by sonijaiswal, Nov 5, 2007.

  1. sonijaiswal New Member

    Hi Gurus I need to get the average CPU USAGE ,average Locks and average memory used perday.How can I do this we are using spotlight. Anyhelp will be greatly appreciated.
  2. Luis Martin Moderator

    You can use Performance Monitor, create a csv file and import into excel. After that you can have any average.
    From the 3rd party tool point of view, SQL Diagnostic Manager from Idera, give you that and more.
    Check ours sponsors.
  3. satya Moderator

    You are using third party tool, so better check Quest's forums in this case.
    And even you can check under Software Spotlight articles on this site for more information.

Share This Page