B
bremmeyr
Guest
What measure can be used to show if the database is hitting a bottle neck during periods of high create record activity? During this event all users are impacted with slow database response time. What I am trying to get to is visibility to the bottle neck. Is the issue at the DBMS or hardware level? Trying to identify what DBMS adjustments can be made to help minimize the impact on other users during these periods of high load? With this case, resource Monitor is showing the most active disk I/O write session is prowin32.exe to 3 extents of the database. 1 is the index extent and the other is a data extent. OpenEdge Enterprise DB, 10.2B, Windows 2008 R2
Continue reading...
Continue reading...