Sumários

Performance Monitoring

26 maio 2017, 08:00 • Bruno Emanuel Da Graça Martins

1. Performance monitoring and performance indicators

2. Isolating slow running queries using the SQL Profiler
3. Reorganising and rebuilding indexes
4. Checking files auto-growth frequency
5. Using of the query governor configuration option

Performance Monitoring and Distributed Databases

23 maio 2017, 11:00 • Helena Galhardas

Performance Monitoring:

  • Recurrent Patterns of Problems
  • A Systematic Approach to Monitoring
  • Main Performance Indicators
Distributed Databases:
  • Distributed DBMS Architectures
  • Storing Data in a Distributed DBMS
  • Distributed Catalog Management

Performance Monitoring and Distributed Databases

23 maio 2017, 11:00 • Helena Galhardas

Performance Monitoring:

  • Recurrent Patterns of Problems
  • A Systematic Approach to Monitoring
  • Main Performance Indicators
Distributed Databases:
  • Distributed DBMS Architectures
  • Storing Data in a Distributed DBMS
  • Distributed Catalog Management

Lab 9

23 maio 2017, 09:30 • Carlos Mendes

1. Performance monitoring and performance indicators

2. Isolating slow running queries using the SQL Profiler

3. Reorganize and rebuild indexes

4. Check files auto growth frequency

5. Using of the query governor configuration option

Schema Tuning, Query Tuning, and Index Tuning

19 maio 2017, 11:00 • Bruno Emanuel Da Graça Martins

1. Schema Tuning  (cont.)

2. Query Tuning (rules of thumb for query tuning)
3. Index Tuning and the SQL Server Database Engine Tuning Advisor
4. Experiments and Exercises
4.1. A Practical Exercise Using the Database Engine Tuning Advisor
4.2. Implementing the Database Engine Tuning Advisor Recommendations 
4.3. Pen-and-paper Exercises
5. Support to the course project