Session 1: Getting Started with Performance Analyst for Microsoft

From DBArtisan
Jump to: navigation, search

Go Up to Performance Analyst for Microsoft SQL Server Tutorial

Download and Install

You can obtain the latest version of Performance Analyst by downloading the DBArtisan software from the IDERA Web site at https://www.idera.com/dbartisan-database-administration-solution/freetrialsubscriptionform. Performance Analyst runs fully contained within DBArtisan so you will need the DBArtisan product to use Performance Analyst (although Performance Analyst can also run in standalone fashion within a Microsoft Internet Explorer Web browser).

Click Download, and follow the steps indicated. Save the file on your computer and then double-click to launch the self-extracting file that will guide you through the installation process.

When you first install an evaluation copy of DBArtisan, you can use the tool for 14 days. After that time, a permanent license is needed.

Overview of Performance Analyst for Microsoft

When DBArtisan is connected to a Microsoft SQL Server database, you can open Performance Analyst two ways:

  1. On Utilities menu, select Performance Analyst.

For Performance Analyst to work, several procedures need to be installed by the SA account. When Performance Analyst is first invoked, it will check for the presence of this package and if it has not been installed, the product will prompt you to install it. Once created, any account with access to these procedures may monitor databases using Performance Analyst. No other objects need to be installed on a monitored database.

Performance Analyst for Microsoft Product Navigation

Navigating through Performance Analyst is easily accomplished through two main mechanisms:

  1. The main Performance Analyst toolbar contains buttons that invoke the major performance analysis views within the product as well as frequently used actions like Refresh and Performance Threshold Customizations.
  2. Positioning the mouse pointer on any area within Performance Analyst and clicking the right mouse button will bring up a navigation menu that allows you to easily move between any of the main Performance Analyst home pages and drill down views. The right mouse menu also contains context sensitive options like drilling down further into a particular statistic, copying the display to a text file, and more.

Proceed to Session 2: Using Ratio-based Performance Analysis in Performance Analyst for Microsoft

Retrieved from "http://docwiki.embarcadero.com/DBArtisan/182/e/index.php?title=Session_1:_Getting_Started_with_Performance_Analyst_for_Microsoft&oldid=5997"