User bio
404 bio not found
Member since Mar 26, 2019
Posts:
Replies:
Hi Frank,
There is no "out of the box" tool that can give you ^%SS and ensemble componet dashboard to measure performance (GREFs, memory, CPU etc.)
Maybe worth to check if someone has already developed something similar in "open exchange"
Hello Frank,
You can correlate the pid in O/S with the pid in Cache processes (in management portal). there you can see which namespace this pid is running in Cache. You can also have more information for that component: last line in source code, last global reference, if there are any locks might give you a good clue what this component is doing.
If you are using ensemble, you can match the same pid to an ensemble job
Certifications & Credly badges:
Global Masters badges:
Followers:
Following:
Hello Caio,
There is no DECLARE @variable (SQL server) or DECLARE variable (Oracle) on Cache but there are few options:
1. Use a host variable(s) in embedded SQL:
&SQL(SELECT Column FROM Table WHERE ID = :variable)
2. Use the same with Dynamic SQL
SET sql = "SELECT Column FROM Table WHERE ID = " _ variable
DO ##class(%SQL.Statement).%ExecDirect(, sql)
3. Writing a SP
AS
BEGIN
SELECT Column FROM Table WHERE ID = variable;
END