开发者

Is there a Microsoft SQL Server Profiler equivalent for Progress OpenEdge ABL?

开发者 https://www.devze.com 2023-04-11 13:20 出处:网络
I am looking for an equivalent of Microsoft SQL Profile开发者_如何学编程r for a Progress 4GL database.Maybe.It depends on how "equivalent" you need your solution to be.

I am looking for an equivalent of Microsoft SQL Profile开发者_如何学编程r for a Progress 4GL database.


Maybe. It depends on how "equivalent" you need your solution to be.

If you are looking for general performance data then options include:

  • PROMON (included)
  • OpenEdge Management (aka "Fathom") (an extra license from PSC)
  • ProTop (free -- http://wss.com/protop which is me)
  • Pro Monitor (no longer available)
  • Roll your own via Virtual System Tables

If you are specifically looking for something along the lines of "explain plan" then you probably want to be running OE10.2B or better and look into the "client statement cache" feature.

If you wish to profile the performance of 4GL code then you might be wanting to use the "profiler" feature of the ABL. You can get to that via the -profile startup option or by using the session:profiler handle within a session.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号