![]() ![]() Note: If you find “SQL BODY UNAVILABLE” which means that you don’t have access to view the SQL. by examining the Statement we should able to trace the reason for the overrun. Waits – Will tell you wait cycle for each IO operation that we perform, by using the wait time we can determine the status of the process.Ĭurrent Statement – This is used to fetch the current SQL that is executed. IO – To identify whether the process is performing any I/O related activities, When you don’t see a change in their Block reads, physical Reads etc., you can assume that the process has an issue in the IO. We could identify it by viewing the following option in the session browser. Here we have to choose the suspect and see what could be the reason behind the over run. The Status tab will display all the Active/ InActive Sessions which has/had sessions in the Database.
0 Comments
Leave a Reply. |