it4biz / pentaho-performance-monitoring Goto Github PK
View Code? Open in Web Editor NEWPentaho Performance Monitoring (MDX and SQL Logs)
Pentaho Performance Monitoring (MDX and SQL Logs)
Hi, I want to install this plugin manually as no connectivity with the internet. Can you enlist the steps to install manually?
I'm getting plugin running ok in my server but SQL queries are not parsed correctly since they have line breaks. i.e:
2015-06-22 12:22:02,293 #0: SqlTupleReader.readTuples [[Brand.Default].[Brand]]: executing sql [select
"D_Brand"."BookingSystem" as "c0"
from
"dbo"."D_Brand" as "D_Brand"
order by
....
Hi,
When i open this plugin pentaho gives this errors:
Error processing component (barTopSlowSQLQueriesComponent)
Error processing component (barTopFastSQLQueriesComponent)
And don't show anything!
My Pentaho server has no internet access, therefore no access to the marketplace. I downloaded the package manually from http://www.pentaho.com/marketplace/ and installed. Filled out the form, and there was an error, saying to contact it4biz.
Pentaho Server is running on a linux machine.
We have to create better docs and videos about the plugin.
It was an idea by Everton Roberto Denuncio at Pentaho Day 2015.
Contact:
Everton Roberto Denuncio
e-mail : [email protected]
twitter: @evertondenuncio
Criar sistema de envio de email agradecendo pela instalação realizada.
When the log is write fast the sequence of rows is lost.
"DIM_TIME"."MONTH_NAME" as "c2", sum("ORDERFACT"."QUANTITYORDERED") as "m0" from "DIM_TIME" as "DIM_TIME", "ORDERFACT" as "ORDERFACT" where "ORDERFACT"."TIME_ID" = "DIM_TIME"."TIME_ID" and "DIM_TIME"."YEAR_ID" = 2003 and "DIM_TIME"."QTR_NAME" = 'QTR1' and "DIM_TIME"."MONTH_NAME" in ('Feb', 'Jan', 'Mar') group by "DIM_TIME"."YEAR_ID", "DIM_TIME"."QTR_NAME", "DIM_TIME"."MONTH_NAME"]
2015-01-20 16:38:26,777 #48: Segment.load: executing sql [select "CUSTOMER_W_TER"."TERRITORY" as "c0", "DIM_TIME"."YEAR_ID" as "c1", "DIM_TIME"."QTR_NAME" as "c2", "DIM_TIME"."MONTH_NAME" as "c3", sum("ORDERFACT"."QUANTITYORDERED") as "m0" from "CUSTOMER_W_TER" as "CUSTOMER_W_TER", "ORDERFACT" as "ORDERFACT", "DIM_TIME" as "DIM_TIME" where "ORDERFACT"."CUSTOMERNUMBER" = "CUSTOMER_W_TER"."CUSTOMERNUMBER" and "ORDERFACT"."TIME_ID" = "DIM_TIME"."TIME_ID" and "DIM_TIME"."YEAR_ID" = 2003 and "DIM_TIME"."QTR_NAME" = 'QTR1' and "DIM_TIME"."MONTH_NAME" in ('Feb', 'Jan', 'Mar') group by "CUSTOMER_W_TER"."TERRITORY", "DIM_TIME"."YEAR_ID", "DIM_TIME"."QTR_NAME", "DIM_TIME"."MONTH_NAME"]
2015-01-20 16:38:26,778 #49: Segment.load: executing sql [select "CUSTOMER_W_TER"."TERRITORY" as "c0", "CUSTOMER_W_TER"."CUSTOMERNAME" as "c1", "DIM_TIME"."YEAR_ID" as "c2", "DIM_TIME"."QTR_NAME" as "c3", "DIM_TIME"."MONTH_NAME" as "c4", sum("ORDERFACT"."QUANTITYORDERED") as "m0" from "CUSTOMER_W_TER" as "CUSTOMER_W_TER", "ORDERFACT" as "ORDERFACT", "DIM_TIME" as "DIM_TIME" where "ORDERFACT"."CUSTOMERNUMBER" = "CUSTOMER_W_TER"."CUSTOMERNUMBER" and "ORDERFACT"."TIME_ID" = "DIM_TIME"."TIME_ID" and "DIM_TIME"."YEAR_ID" = 2003 and "DIM_TIME"."QTR_NAME" = 'QTR1' and "DIM_TIME"."MONTH_NAME" in ('Feb', 'Jan', 'Mar') group by "CUSTOMER_W_TER"."TERRITORY", "CUSTOMER_W_TER"."CUSTOMERNAME", "DIM_TIME"."YEAR_ID", "DIM_TIME"."QTR_NAME", "DIM_TIME"."MONTH_NAME"]
2015-01-20 16:38:26,986 #48: , exec 208 ms
2015-01-20 16:38:27,224 #50: Segment.load: executing sql [select "CUSTOMER_W_TER"."CUSTOMERNAME" as "c0", "DIM_TIME"."YEAR_ID" as "c1", "DIM_TIME"."QTR_NAME" as "c2", "DIM_TIME"."MONTH_NAME" as "c3", sum("ORDERFACT"."QUANTITYORDERED") as "m0" from "CUSTOMER_W_TER" as "CUSTOMER_W_TER", "ORDERFACT" as "ORDERFACT", "DIM_TIME" as "DIM_TIME" where "ORDERFACT"."CUSTOMERNUMBER" = "CUSTOMER_W_TER"."CUSTOMERNUMBER" and "ORDERFACT"."TIME_ID" = "DIM_TIME"."TIME_ID" and "DIM_TIME"."YEAR_ID" = 2003 and "DIM_TIME"."QTR_NAME" = 'QTR1' and "DIM_TIME"."MONTH_NAME" in ('Feb', 'Jan', 'Mar') group by "CUSTOMER_W_TER"."CUSTOMERNAME", "DIM_TIME"."YEAR_ID", "DIM_TIME"."QTR_NAME", "DIM_TIME"."MONTH_NAME"]
2015-01-20 16:38:27,224 #48: , exec+fetch 447 ms, 7 rows
2015-01-20 16:38:27,243 #47: , exec 448 ms
2015-01-20 16:38:27,243 #49: , exec 464 ms
2015-01-20 16:38:27,371 #50: , exec 146 ms
2015-01-20 16:38:27,371 #49: , exec+fetch 592 ms, 14 rows
2015-01-20 16:38:27,372 #47: , exec+fetch 596 ms, 3 rows
2015-01-20 16:38:27,372 #50: , exec+fetch 147 ms, 14 rows
Hola Rafael,
Que tal? Como puedo cojer los datos de garbage collector do Tomcat Pentaho?
Otra cosas, donde Saiku genera el log de quien has ejecutado una consulta? Quien has descargado, etc? Te acuerdas que tu has dicho que si el tiene y no hace falta utilizar el plugin de mi amigo.
Que mas te parece necesario monitorar con los plugins que hemos hecho?
Un saludo,
Caio
Hi,
I installed your two plugins , and I see the same information do you find getting modifying the log4j .
I've seen etls where do you find the information , and I have not gotten to see how to get the user.
After talking with Caio , we have seen that these data do not currently exist , and it would be a good improvement for the plugin .
The question is , how can we get this data for inclusion in the plugin?
Thanks,
Regards
There is no option to select United States during registration.
Endpoint: _jobCopyAndClearLogs
Step: Clear log Windows
Error: The path not working and the file is blocked by OS
hey this is a good product but i don't konw why it's donse't work
we use linus here is the log
I've installed Pentaho Performance Monitoring on Pentaho 5.0.1 CE server (Windows 2012 Server).
Installation runs ok and registration seems to be correct but when I start the plugin (after BAServer restart) and refresh data it hangs on loading screen.
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google ❤️ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.