Sumários
Lab Guide 10: Performance Monitoring and Project Support (aula online)
29 maio 2020, 11:00 • João Pedro Lebre Magalhães Pereira
Lab Guide 10:
- Performance monitoring and performance indicators
- Isolating slow running queries using the SQL Profiler
- Saving and analyzing the trace as a database table
- Generating a trace for tuning
- Reorganizing and rebuilding indexes
- Using of the query governor configuration option
- Check files auto growth frequency
Q&A about the course project.
NoSQL databases
29 maio 2020, 09:30 • Helena Galhardas
- Requirements of Web applications
- Characteristics of NoQL database systems
- Map-reduce data processing paradigm
- Different incarnations of NoSQL systems, their properties and examples of implementations:
- key-value store and column store
- document store
- graph databases.
NoSQL databases
29 maio 2020, 09:30 • Helena Galhardas
- Requirements of Web applications
- Characteristics of NoQL database systems
- Map-reduce data processing paradigm
- Different incarnations of NoSQL systems, their properties and examples of implementations:
- key-value store and column store
- document store
- graph databases.
Lab Guide 10: Performance Monitoring and Project Support (aula online)
29 maio 2020, 08:00 • João Pedro Lebre Magalhães Pereira
Lab Guide 10:
- Performance monitoring and performance indicators
- Isolating slow running queries using the SQL Profiler
- Saving and analyzing the trace as a database table
- Generating a trace for tuning
- Reorganizing and rebuilding indexes
- Using of the query governor configuration option
- Check files auto growth frequency
Q&A about the course project.
Lab Guide 10: Performance Monitoring (aula online)
26 maio 2020, 12:30 • João Tiago Aparício
1. Performance monitoring and performance indicators
Clarification of doubts for the project.