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.
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.
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.
