Tag Archives: Session

How To Identify The Source Of Page Splits

In my last post I talked about how one could go about troubleshooting an issue in SQL Server, and today I would like to talk about one of the common issues that most DBA’s come across their professional career, Page … Continue reading

Posted in ms sql, Performance Tuning, Troubleshooting | Tagged , , , , , , , , , , | Leave a comment

Blocking Sessions

In my last post, I had written about queries that might show up as the most resource consuming queries as per total elapsed time, but it may turn out that the query itself is not performing any action. The query … Continue reading

Posted in Oracle | Tagged , , , , , , | 1 Comment

Kill Thy Session

As a DBA, the most frequent and recurring task on daily basis are to kill sessions that just aren’t doing anything, possibly because of some resource contention or due to network outage. Since, I have overseen both Data-warehouse database system … Continue reading

Posted in Oracle | Tagged , , , , | Leave a comment