sendGraphite – Simple Utility for sending Performance Counters to Graphite

Hi All,

This is neto from Brazil

How are you?

sendGraphite (Rodrigo Nascimento and neto from Brazil – NetApp) is a Simple Utility for sending Performance Counters to Graphite.

Downloading sendGraphite – Mac OSX:

sendGraphite.osx

Downloading sendGraphite – Linux:

sendGraphite.linux

Downloading sendGraphite – Windows:

sendGraphite-windows.exe

Running sendGraphite:

sendGraphite.osx --server 10.61.105.165 --port 2003 --project netapp.perf.oracle --name latency --value 0.9

Where:

--server: Graphite Server hostname
--port: Graphite Server port
--project: Project Name (string) to identify your data in Graphite
--name: Database name in Graphite
--value: Value to be send to the Database

Checking the value on Graphite:

root@graphs:~# whisper-fetch.py /opt/graphite/storage/whisper/netapp/perf/oracle/latency.wsp | tail -1 
1453927080 0.900000

If you have any questions, please feel free to contact us at:

[rodrigon] at netapp dot com [neto,n,netofrombrazil] at netapp dot com

Rodrigo Nascimento – @logwriter  –  neto from Brazil – @netofrombrazil

All the best,

neto
NetApp – I love this company!

 

Posted in #NetAppInsight, Databases, grafana, graphite, NetApp, netofrombrazil, Oracle, Performance, workload tools | Tagged , , , , , | Leave a comment

Downloading graphOra – Oracle Real Time Performance Statistics

Hi All,

This is neto from Brazil

How are you?

graphOra (Rodrigo Nascimento and neto from Brazil – NetApp) is an application to collect performance counters from an Oracle database instance and printing them in the screen or sending them to Graphite/Grafana. Even if you don’t have a Graphite/Grafana server you can use graphOra to see real time performance data from an Oracle database.

Downloading graphOra:

graphOra.linux

Note:

We have the compiled version of graphOra to have all the dependencies. Just download and enjoy it🙂

Preparing graphOra:

graphOra.linux --host oracle-db --port 1521 --sid nfb1 --create

Where oracle-db is the name or IP of your oracle database server.

Running graphOra:

graphOra.linux --host oracle-db --port 1521 --sid nfb1 --interval 10

Where oracle-db is the name or IP of your oracle database server.

Running graphOra with graphite:

graphOra.linux --host oracle-db --port 1521 --sid nfb1 --interval 10 --graphite graphs-db --graph-port 2003

Where:

oracle-db is the name or IP of your oracle database server.
graphs-db is the name of your Graphite server.

NOTE: Using graphOra with the graphite option, we recommend to use hostnames instead of IPs as graphite is using “.” as the field separator for the naming schema.

If you have any questions, please feel free to contact us at:

[rodrigon] at netapp dot com [neto,n,netofrombrazil] at netapp dot com

Rodrigo Nascimento – @logwriter neto from Brazil – @netofrombrazil

All the best,

neto
NetApp – I love this company!

Posted in Databases, NetApp, netofrombrazil, Oracle, Performance | Tagged , , , , | 1 Comment

graphOra (Docker Image) – Oracle Real Time Performance Statistics

Hi All,

This is neto from Brazil

How are you?

graphOra (Rodrigo Nascimento and neto from Brazil – NetApp) is an application to collect performance counters from an Oracle database instance and printing them in the screen or sending them to Graphite/Grafana. Even if you don’t have a Graphite/Grafana server you can use graphOra to see real time performance data from an Oracle database.

Snip20151202_11

Steps:

Install Docker client and server – http://www.docker.com

Pulling the Docker image:

docker pull netofrombrazil/graphora

Preparing graphOra:

Snip20151202_8
docker run -ti netofrombrazil/graphora --host oracle-db --port 1521 --sid nfb1 --create    

Running graphOra:

Snip20151202_12
docker run -ti netofrombrazil/graphora --host oracle-db --port 1521 --sid nfb1 --interval 10 

Running graphOra with graphite:

Snip20151202_10
docker run -ti netofrombrazil/graphora --host oracle-db --port 1521 --sid nfb1 --interval 10 --graphite graphs-db --graph-port 2003


Snip20151202_9.png

NOTE: Using graphOra with the graphite option, we recommend to use hostnames instead of IPs as graphite is using “.” as the field separator for the naming schema.

If you have any questions, please feel free to contact us at:

[rodrigon] at netapp dot com [neto,n,netofrombrazil] at netapp dot com

Rodrigo Nascimento – @logwriter neto from Brazil – @netofrombrazil

All the best,

neto
NetApp – I love this company!

Posted in #NetAppInsight, Databases, Docker, NetApp, Oracle, Performance | Tagged , , , , , , | 4 Comments

Docker Image – NetApp Perfstat

Hi All,

This is neto from Brazil

How are you?

Here you have instructions how to create a Docker Image with NetApp Perfstat 8.3 and all of the dependencies.

1 – Dockerfile file contents:

FROM centos:latest
MAINTAINER Rodrigo Nascimento and neto from Brazil - NetApp
COPY Perfstat*Linux.tar.gz /root
WORKDIR /root
RUN yum -y update && yum -y install glibc-devel compat-libstdc++-33.i686 libstdc++.i686 compat-libstdc++-33.i686 libstdc++.i686 libgcc.i686 gcc gcc-c++ glibc-devel.i686 openssl-libs.i686 libssh2.i686 && ln -s /usr/lib/libssl.so.10 /usr/lib/libssl.so.1.0.0 && ln -s /usr/lib/libcrypto.so.1.0.1e /usr/lib/libcrypto.so.1.0.0 && curl -L -o boost_1_57_0.tar.gz http://sourceforge.net/projects/boost/files/boost/1.57.0/boost_1_57_0.tar.gz && tar zxvf boost_1_57_0.tar.gz && tar xvf Perfstat8*Linux.tar.gz && mv /root/Perfstat*Linux /root/perfstat && rm -rf /root/boost_1_57_0.tar.gz /root/Perfstat*Linux.tar.gz /root/Dockerfile && cd /root/boost_1_57_0 && ./bootstrap.sh --show-libraries && cd /root/boost_1_57_0 && ./b2 address-model=32 -a; exit 0 
RUN cd /root/boost_1_57_0 && rm -rf b2 boost-build.jam bootstrap.bat index.htm libs bin.v2 boostcpp.jam bootstrap.log index.html status bjam boost.css bootstrap.sh INSTALL more tools boost boost.png doc Jamroot rst.css && yum -y remove glibc-devel compat-libstdc++-33.i686 libstdc++.i686 compat-libstdc++-33.i686 libstdc++.i686 libgcc.i686 gcc gcc-c++ glibc-devel.i686 openssl-libs.i686 libssh2.i686 && yum -y install openssl-libs.i686 libssh2.i686 && ln -s /usr/lib/libssl.so.10 /usr/lib/libssl.so.1.0.0 && ln -s /usr/lib/libcrypto.so.1.0.1e /usr/lib/libcrypto.so.1.0.0
ENV LD_LIBRARY_PATH=/root/boost_1_57_0/stage/lib:/usr/lib64
ENTRYPOINT ["/root/perfstat/perfstat8"]
CMD ["/root/perfstat/perfstat8"]

2 – Building the Docker Image:

  1. Install Docker client and server – http://www.docker.com
  2. Create a Dockerfile file on your local folder (e.g. /Users/neto/perfstat)
  3. Use your NetApp credentials to download the NetApp Perfstat binary from support.netapp.com and copy it to a local folder (e.g. /Users/neto/perfstat/Perfstat8_20150514_2838689_Linux.tar.gz)
  4. Copy the “1 – Dockerfile file contents” to your Dockerfile file (e.g. /Users/neto/perfstat/Dockerfile)
  5. To build the image, please run:
docker build -t <image-name>:latest --rm=true .

For example:

docker build -t netofrombrazil/perfstat:latest --rm=true .

Please wait … (around 16 minutes to download and compile all needed packages for NetApp Perfstat 8.3)

3 – Running the Docker Container:

To run the container, please do:

docker run -ti -v /<local-folder>:/data netofrombrazil/perfstat perfstat8 -i 1,2 --verbose <cluster-IP> --mode="cluster-mode" -o /data/output

For example:

docker run -ti -v /Users/neto/perfstat:/data netofrombrazil/perfstat perfstat8 -i 1,2 --verbose 10.61.105.115 --mode="cluster-mode" -o /data/output

Snip20151201_6

The <local-folder> is destination for all the NetApp Perfstat output files.

If you have any questions, please feel free to contact me at:[neto,n,netofrombrazil] at netapp dot com

All the best,

neto
NetApp – I love this company!

Posted in #NetAppInsight, Container, Docker, NetApp, netofrombrazil, Performance | Tagged , , , , | 5 Comments

Technical Demo: NetApp Data Fabric – Move Data In/Out/Near the Cloud with Extreme Flash Performance

Hi All,

This is neto from Brazil

How are you?

NetApp – I love this company!

https://youtu.be/uLlwZvkaTmo?t=2868

https://www.youtube.com/watch?v=UluLv_YXx-o

All the best

neto

Posted in Uncategorized | Tagged , , , , , | Leave a comment

Tech ONTAP Podcast Episode 8: The NetApp Customer Proof-of-Concept Lab with neto from Brazil

Hi All,

This is neto from Brazil

How are you?

http://community.netapp.com/t5/Technology/Tech-ONTAP-Podcast-Episode-8-The-NetApp-Customer-Proof-of-Concept-Lab/ba-p/110172

Have you ever thought to yourself “I wonder if it’s possible to do this with NetApp?” Or, how about “I hear what my sales team is saying, but I’m not sure how it will behave with my application.” Well, we have the answer for you, and the answer is the Customer Proof-of-Concept (CPOC) lab. The CPOC team is dedicated to showing NetApp functionality and integration with customer applications, using real customer data, simulated tests, and sometimes just raw benchmarks by mimicking portions of customer environments.

This week we feature Neto from Brazil (@netofrombrazil), a NetApp legend and database performance specialist on the CPOC team. Neto talks with us about the CPOC, it’s function in the company, and how customers can request an engagement from the team. He also happens to be one of NetApp’s premier Oracle specialists, so we take the opportunity to talk about database workloads when using NetApp All-Flash FAS.

We love this company!

Important Links:
NetApp AFF8080 EX Performance and Server Consolidation with Oracle Database (TR-4415)
MetroCluster in Clustered Data ONTAP 8.3 Verification Tests Using Oracle Workloads (TR-4396)
NetApp All-Flash FAS for Databases Performance Testing Summary on FAS8000 Series (TR-4322)
Best Practices for Oracle Databases on NetApp Storage (TR-3633)
Neto from Brazil is a proud NetApp Employee and Brazilian. Since 2000, he has been working at NetApp as Systems Engineer, Consulting Systems Engineer for Latin America and Caribbean and now as a Technical Architect for Customer Proof of Concepts in Research Triangle Park, NC. As a Technical Architect, Neto from Brazil has been working to develop large scale environments to simulate customer’s applications and determine performance and scaling characteristics with focus on databases, performance, and virtualization, demonstrating the latest technologies to prospective customers. In 2009, Neto from Brazil was nominated an Oracle ACE, a group known for their strong credentials as Oracle community enthusiasts and advocates, with candidates nominated by the Oracle Technology and Applications community. You can follow Neto from Brazil at http://www.netofrombrazil.com and Twitter.

Posted in Uncategorized | Tagged , , , , | Leave a comment

NetApp Insight 2015 – netofrombrazil sessions

Hi All,

This is neto from Brazil

How are you?

Please register to my sessions at NetApp Insight 2015.

Thank you,

All the best

neto
NetApp – I love this company!

Posted in Uncategorized | Tagged , , , | Leave a comment