Data Migration and Upgrade Best Practices Webinar WATCH NOW
  • HELP
    • About Us
    • Contact Us
    Performance Tuning
    • (800) 887-4513
    • About
      • About Us
      • Careers
    • IT Strategy Solutions
      • Digital Transformation
      • Cloud Maturity
      • Enterprise Analytics
    • Technical Consulting
      • Managed Cloud Services
      • Data Integration
      • Database Consulting
      • Managed Database
      • Data Performance TuneKit: Oracle GoldenGate Edition
        • Data Performance TuneKit – GoldenGate Rapid Deployment
        • Data Performance TuneKit – Monitor for Oracle GoldenGate
        • Data Performance TuneKit – GoldenGate Trail File Analyzer
        • Data Performance TuneKit – GoldenGate Logdump GUI
        • Data Performance TuneKit: Oracle GoldenGate Edition Demo
    • Knowledge Center
      • White Papers
      • Webinars & Videos
      • Blog
    Contact Us
    • OEM
    • Apr 06
    • 2 mins read

    Configuring SQL Server Monitoring in OEM 13c – Pt 1

    Edward Whalen

    I recently was called on to set up SQL Server monitoring in my OEM system in my lab.  The OEM server is Oracle Linux 7 and my SQL Server platform is Windows 2016.  It turns out that with only a few bumps, Configuring SQL Server Monitoring in OEM 13c is possible. 

    The first part was to install the OEM 13c agent on Windows from a Linux server.  This was covered in my previous blog. https://www.perftuning.com/blog/install-an-oem-windows-agent-from-a-linux-oem-platform/

    Expert Oracle Database Support  Starting at $500 per month Click to Learn More

    The second phase is to configure SQL Server monitoring in OEM 13c.

    This involves two parts:

    1.) Configure SQL Server for OEM access

    2.) Configure OEM to monitor SQL Server 

    Because of what is involved in these parts I’ll split it up into two blog entries.

    Part 1:  Setting up SQL Server for OEM access

    There are a few things that must be done in order to setup SQL Server monitoring in OEM.  The first is to make sure that the database is set up for TCP/IP access.  By default (at least in my installations) it was not. 

    Free SQL Server Performance Assessment

    From the start menu choose the SQL Server Connection Manager from your SQL Server installation and select SQL Server Network Configuration.  If TCP/IP does not show Enabled, right click on it and select Enable.  My completed setting is shown here.

    SQL Server Protocols for OEM

    Next, create a SQL Server user (if you don’t already have one) that will be used to monitor the SQL Server database.  This can either be a SQL Server authenticated user or a Windows user.

    Create a SQL Server User for OEM Monitoring

    This user must be granted sysadmin in order to be able to monitor all of SQL Server. 

    If you are setting up a SQL Server authenticated user, you must change the SQL Server instance property in order to allow mixed-mode authentication.

    Admin Access for OEM

    This is really all that is needed in order to be prepared for OEM monitoring.

    Part 2:  Configure OEM monitoring of SQL Server

    The next part of this blog will describe how to configure OEM for SQL Server monitoring.

    OEM Windows Linux SQL Server Oracle Enterprise Manager

    Contact Us

    Advertisement

    Company

    • About us
    • How We Work
    • Careers We’re Hiring!
    • Contact us

    IT Strategy Solutions

    • Digital Transformation
    • Cloud Maturity
    • Enterprise Analytics

    Technical Consulting

    • Managed Cloud Services
    • Data Integration
    • Database Consulting
    • Managed Database

    Knowledge Center

    • Case Studies
    • White Papers
    • Webinars & Videos
    • Blog

    Contact Us

    • Iconinfo@perftuning.com
    • Icon(800) 887-4513
    • IconAustin, TX 78759
    Copyright 2021 © Performance Tuning Corporation
    All Rights Reserved