tag:blogger.com,1999:blog-3109386887529685808.post4107927211821768163..comments2007-04-08T18:24:12.812+01:00Milan Guptahttp://www.blogger.com/profile/13287099462062649030noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-3109386887529685808.post-856560410737369972007-04-07T10:12:00.000+01:002007-04-07T10:12:00.000+01:00Yes, this is exactly what I learnt while working as a support person.. you need to know the normal.. only then can you understand and react when something goes wrong..<BR/><BR/>What I used to look out for was the number of <B>log switches per hour/day </B>. A sudden increase would mean something that has changed is contributing to a high level of database activity..<BR/><BR/>I found TOAD to be a really helpful tool in this regards..TOAD has an amazing range of diagnostic/health indicator tools...<BR/><BR/>...including a chart tool which lists the log switches per hour per day...Aroj Phttp://www.blogger.com/profile/09220834510103861114noreply@blogger.com