Hi, i have one question. before this i am an oracle DBA. we use tools name AWR for us to analyze the db condition. best thing bout awr report is that we can specify the time frame on that report. let say we got hit cpu usage issue at 6 am then we just specify the time frame for awr report from 6 am to 6.30 am to see what's really going on at that time. my question is, is there any similar tools that i can use for sql server. the tools that enable me to specify the time frame.. thank you in advance for your replykneeah

Hi Kneeah, I think you got the question in the wrong forum. This is more of a SQL Server Maintainence / Administration question and could be better answered at the SQL Server forums. Nevertheless, you can use the Windows Performance Monitor to do your task. You can read more at the following link: Link to Article There are also few good ones from third party vendors such as RedGate. Link to RedGate HTH Please mark correct answers :)