Technological recipes that I've held to prepare some solutions DBA environment. (by Felipe Donoso Bastias)

28 Nov 2013

Very good alternative to Graphic tools in Oracle environments, MOATS


Need to examine a database in detail without a graphical tool involved? I found the solution :)
A few days ago researching alternatives were not monitoring oracle enterprise manager, I found a great tool called MOATS (The Mother of All Tuning Scripts) to design a genius out there on the web. This tool is run via console (sqlplus) and shows real-time database. There is also a sister tool called "Dashboard Sqlplus For RAC" for rac environments (http://blog.tanelpoder.com/2012/05/13/moats-like-sqlplus-top-utility-for-rac/). Here 'part explained by the author of this tool in your website: http://blog.tanelpoder.com/2011/03/29/moats-the-mother-of-all-tuning-scripts/

Regards, felipin
Here the author's explanation:

http://blog.tanelpoder.com/2011/03/29/moats-the-mother-of-all-tuning-scripts/
.....
 "
People talk about the Oracle SQL Developer 3 being out, which is cool, but I have something even cooler for you today ;-)
I finally figured out how to convert my screen-recordings to uploadable videos, so that the text wouldn’t get unreadable and blurry.
So, here’s the first video, about a tool called MOATS, which we have built together with fellow OakTable Network member and a PL/SQL wizard Adrian Billington (of oracle-developer.net).
Here’s the video, it’s under 3 minutes long. Play the video in full screen for best results (and if it’s too slow loading, change it to lower resolution from HD mode):





check it out and if you like MOATS, you can download it from Adrian’s website site (current version 1.05) and make sure you read the README.txt file in the zip!
Also thanks to Randolf Geist for finding and fixing some bugs in our alpha code… Note that MOATS is still kind of beta right now…
P.S. I will post my ORA-4031 and shared pool hacking video real soon now, too! :-)
P.P.S. Have you already figured out how it works?! ;-)
Update: Now you can suggest new features and improvement requests here:
 "
Bye, Friends.
Pipe.
Share:

27 Nov 2013

PAL, The best tool for to generate graphics on performance monitor files of windows.


Hello friends, today I bring you one of the best tools I've seen to generate graphics performance "performance monitor" of windows, I often take care to analyze SQL SERVER servers, it is very simple to use they recommend:

http://pal.codeplex.com/





This information is from the author's page:

Project Description
Ever have a performance problem, but don't know what performance counters to collect or how to analyze them? The PAL (Performance Analysis of Logs) tool is a powerful tool that reads in a performance monitor counter log and analyzes it using known thresholds.
Features

    Thresholds files for most of the major Microsoft products such as IIS, MOSS, SQL Server, BizTalk, Exchange, and Active Directory.
    An easy to use GUI interface which makes creating batch files for the PAL.ps1 script.
    A GUI editor for creating or editing your own threshold files.
    Creates an HTML based report for ease of copy/pasting into other applications.
    Analyzes performance counter logs for thresholds using thresholds that change their criteria based on the computer's role or hardware specs.

To use PAL
The PAL tool is primarily a PowerShell script that requires arguments/parameters passed to it in order to properly analyze performance monitor logs.
Requirements
Operating Systems
The tool is tested only tested on Microsoft Windows 7 64-bit. If you encounter problems with the tool on other operating systems, then consider reusing the tool on Windows 7 64-bit.

Required Products (free and public):
- PowerShell v2.0 or greater.
- Microsoft .NET Framework 3.5 Service Pack 1
- Microsoft Chart Controls for Microsoft .NET Framework 3.5

Known Issues
PAL must be ran under an English-US locale until globalization can be added. We are looking for assistance from users like you to help contribute to this cause.

Download locations:

Microsoft .NET Framework 3.5 Service Pack 1 (Partial package - internet access required)
http://www.microsoft.com/downloads/details.aspx?familyid=AB99342F-5D1A-413D-8319-81DA479AB0D7&displaylang=en

Microsoft .NET Framework 3.5 Service Pack 1 (full package - no internet access required)
http://download.microsoft.com/download/2/0/e/20e90413-712f-438c-988e-fdaa79a8ac3d/dotnetfx35.exe

Microsoft Chart Controls for Microsoft .NET Framework 3.5
http://www.microsoft.com/downloads/details.aspx?FamilyID=130f7986-bf49-4fe5-9ca8-910ae6ea442c&DisplayLang=en

PowerShell v2.0 (Windows Management Framework (Windows PowerShell 2.0, WinRM 2.0, and BITS 4.0))
http://support.microsoft.com/kb/968929

Training
Download it (20071005IntrotoPALwmv.zip) from:
https://www.codeplex.com/Release/ProjectReleases.aspx?ProjectName=PAL&ReleaseId=6759

Related Blogs and Reviews
Clint Huffman's Windows Performance Analysis Blog
http://blogs.technet.com/clinth

Mike Lagase's Exchange Performance Analysis Blog
http://blogs.technet.com/mikelag/archive/2008/08/20/performance-troubleshooting-using-the-pal-tool.aspx

Get a Handle on Windows Performance Analysis (Windows IT Pro Magazine)
http://windowsitpro.com/Windows/Articles/ArticleID/101162/pg/2/2.html

Two Exchange Server Tools You Should Know About
http://windowsitpro.com/article/articleid/100132/two-exchange-server-tools-you-should-know-about.html

Support and social media: Please post to the Discussions section of the web site, use the Twitter hashtag #paltool, or email the developer at clinth@microsoft.com.

Last edited Oct 4 at 12:22 AM by ClintH, version 34
download
current     PAL v2.4
date     Thu Oct 31, 2013 at 5:00 AM
status     Stable
downloads     46,473
rating           21 ratings
Review this release
Most Helpful Reviews

     The greatest performance analysis tool EVER !

     Awesome reporting tool. It gave me the performance control of my IAAS as provider and client, the properly reports to help our deve... (more)


Share:

Copyright © DBA TIPS | Powered by Blogger
Design by SimpleWpThemes | Blogger Theme by NewBloggerThemes.com | Free Blogger Templates