Hi gurus i am in need of quick help i need to know the average cpu usage every day and average mermoery usage and average locks in a day on my production using spotlight. Can you guys help me how to do it.I will be highly ever thankful,as I am new to spotlight.And thanks allot everyone who is answering my questions. satya and alll. Thank U guys.
If you are going to use SQL SErver 2005 then why to go for third party tools for such reports, using SQL SErver Management Studioperformance dashboard reports you can achieve the task. http://sqlserver-qa.net/blogs/tools/archive/tags/dashboard/default.aspx fyi