Module 15: Monitoring

Transcription

1 Module 15: Monitoring

2 Overview Formulate requirements and identify resources to monitor in a database environment Types of monitoring that can be carried out to ensure: Maximum availability Optimal performance Error-free operations Availability of tools for monitoring

3 Monitoring Availability Monitoring should cover availability, errors, and performance of all components of the database environment Components to be monitored for availability are: Node or server server hardware and all components in the path from the client Database listener in SQL Server the listener is part of the database service Database monitoring High-level checks for existence of instance Low-level ensures work can be performed on the database

4 Monitoring Errors The database and its components return status when successful and error messages of when failure or events are encountered Error messages in Oracle have an error code made up of a number and a descriptive error message Error messages in SQL Server are composed of: Unique message number Severity level Error state number identifies source Error message description

5 Error Logs Oracle alert file (alert.log) has equivalent in error logs of SQL Server Logs can be read using SQL Server Management Studio or any text editor Previous 6 error log files are kept by default but you can configure to keep more up to 99 Trace files are not created by default but can be created manually using Performance Monitor or Profiler SQL Server also writes the useful information to the Microsoft Windows Application log which can be read using the Event Viewer

6 Demonstration: Viewing Logs and Events In this demonstration you will learn to: Locate and Review SQL Server Logs

11 Demonstration: Activity Monitor In this demonstration you will learn to: Use SQL Server Activity Monitor to observe specific resources and queries.

12 Demonstration: Setting Alerts to Automate Monitoring In this demonstration you will learn to: Create an Alert based on SQL Server performance counter

13 Review We learned that server, database listener, and database are the components that need to be monitored We learned the types of monitoring cover availability, errors, and performance We saw the operating system tools to check performance of server hardware and operating system components We learned how the various subcomponents of the database and instance can be monitored using counters and logs We were introduced to tools for monitoring SQL Server database and servers such as Performance Monitor, the Data Collector and Performance Data Warehouse, SQL Server Agent, and SQL Profiler

Oracle University Contact Us: 1.800.529.0165 Oracle Database 12c: Performance Management and Tuning NEW Duration: 5 Days What you will learn In the Oracle Database 12c: Performance Management and Tuning

Module 8: Server Management Overview Server-level and instance-level resources such as memory and processes Database-level resources such as logical and physical storage structures User sessions and their

MS-40074: Microsoft SQL Server 2014 for Oracle DBAs Description This four-day instructor-led course provides students with the knowledge and skills to capitalize on their skills and experience as an Oracle

coursemonster.com/us Microsoft SQL Server: MS-10980 Performance Tuning and Optimization Digital View training dates» Overview This course is designed to give the right amount of Internals knowledge and

THE ESSENTIAL GUIDE TO Database Monitoring By Michael Otey SPONSORED BY One of the database administrators (DBAs) most important jobs is to keep the database running smoothly, which includes quickly troubleshooting

6231B: Maintaining a Microsoft SQL Server Database Course Details Course Code: Duration: Notes: 6231B 5 days This course syllabus should be used to determine whether the course is appropriate for the students,

Course 6231B: Maintaining a Microsoft SQL Server Database Five days, instructor-led About this Course This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft

SQL Server 2014 Performance Tuning and Optimization 55144; 5 Days; Instructor-led Course Description This course is designed to give the right amount of Internals knowledge, and wealth of practical tuning

Course 10775A: Administering Microsoft SQL Server 2012 Databases OVERVIEW About this Course This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL

Oracle University Contact Us: 1.800.529.0165 Oracle Database 12c: Performance Management and Tuning NEW Duration: 5 Days What you will learn In the Oracle Database 12c: Performance Management and Tuning

Proactive database performance management white paper 1. The Significance of IT in current business market 3 2. What is Proactive Database Performance Management? 3 Performance analysis through the Identification

HOUR 3 Getting to Know the SQL Server Management Studio The Microsoft SQL Server Management Studio Express is the new interface that Microsoft has provided for management of your SQL Server database. It

Programa de Actualización Profesional ACTI Oracle Database 11g: SQL Tuning Workshop What you will learn This Oracle Database 11g SQL Tuning Workshop training is a DBA-centric course that teaches you how

10775A Administering Microsoft SQL Server 2012 Databases Five days, instructor-led About this Course This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft

SQL Server 2008 Designing, Optimizing, and Maintaining a Database Course The SQL Server 2008 Designing, Optimizing, and Maintaining a Database course will help you prepare for 70-450 exam from Microsoft.

Course 6231A: Maintaining a Microsoft SQL Server 2008 Database About this Course Elements of this syllabus are subject to change. This five-day instructor-led course provides students with the knowledge

Description Course Summary This course is designed to give the right amount of Internals knowledge, and wealth of practical tuning and optimization techniques, that you can put into production. The course

Oracle Database 10g: New Features for Administrators Course ON10G 5 Day(s) 30:00 Hours Introduction This course introduces students to the new features in Oracle Database 10g Release 2 - the database for

Objectif Back up and recover a database Configure Oracle Database for optimal recovery Administer ASM disk groups Use an RMAN backup to duplicate a database Automating Tasks with the Scheduler Participant

MONITORING PERFORMANCE IN WINDOWS 7 Performance Monitor In this demo we will take a look at how we can use the Performance Monitor to capture information about our machine performance. We can access Performance

Microsoft SQL Server OLTP Best Practice The document Introduction to Transactional (OLTP) Load Testing for all Databases provides a general overview on the HammerDB OLTP workload and the document Microsoft

Upon completion of the program, students are given a full support to take and pass Microsoft certification examinations. After completing this course, students will be able to: Plan and install SQL Server

Key Data Product #: Course #: 6231A Number of Days: 5 Format: Certification Exams: 70-432, 70-433 Instructor-Led This course syllabus should be used to determine whether the course is appropriate for the

Course Description This course is a soup-to-nuts course that will teach you everything you need to configure a server, maintain a SQL Server disaster recovery plan, and how to design and manage a secure

AuditWizard v8 This document describes a few operations we recommend to improve or maintain the performance of AuditWizard v8 and the back end SQL server. These steps should allow for optimal upload, application

This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2014 database. The course focuses on teaching individuals how to use SQL Server 2014