Home

PivotalVRP 6.0 User Guide, A01

1. bonjour name 310 check function bodies 3 clent encoding client min messages notice The last tab in the inquire module is the Resource Queue Management tab which enables users to quickly view create and modify queues and roles within the GPDB HAWQ environment 66 PivotalVRP PivotalVRP 6 0 User Manual By default if you have not created queues you will have the pg default queue to which all the defined roles are assigned to The Resource Queue Management screen is divide into 2 sections on the right hand side you can find the Resource queue list which displays the queue names limits and state of the queues the left hand side displays the role amp queue names Locks View DCR Report Resource Queue Management Resource Queue list Role according to queue name Queue Name Active Statements Limit Active Statements Max Cost Limit Min Cost Limit Current Cost Memory Limit Current Memory Waiters Role Name Queue Name 2 E Bond joe Modify Resource Queue GuyE pg_default Delete Resource Queue GuyM joe 2 2 1 assad Joe pg default Show Related Roles AAaa 1 Joey One Settings Global Settings About Adobe Flash Player 13 0 0 214 Tw One 1 Josef pg default 20 JosefLevy o o O O O o o uM o o o O O O O n o Oo O Oo O O O a joe rq 3 MoreVRP PivotalVRP Tommy pg default assaf joe gpadmin pg default iraduser iradq joe2 joe ra joe3 Bond jojojo pg default
2. CNN SQL Text CPU Per Sec Physical Read Pe Total Physical Re Total Phys 00 00 05 04 8 zx 23425 o 0 Program Runtime Logical Re hpuxio select parallel a 30 oracle hpux P075 70 PivotalVRP PivotalVRP 6 0 User Manual Chapter 7 Managing the PivotalVRP Agent Topics Installing the Agent e Starting the Agent e Stopping the Agent 11 PivotalVRP PivotalVRP 6 0 User Manual Installing the Agent Unix Linux Installation 1 This part of the installation process is usually done by a system administrator 2 The agent has to be installed on every single node Copy the agent installer file supplied by PivotalVRP Support to a temporary directory on your PC Note You should now see the Agent installation file called morevrpd 3 Using an FTP editor copy the PivotalVRPd file to your remote database server Unix Linux as user root and place it under bin PivotalVRPd If this directory does not exist then you should create it Here is an example of how to do that ftp open 192 168 10 111Connected to 192 168 10 111 220hpux FTP server Revision 1 1 Version wuftpd 2 6 1 PHNE 34306 Mon Mar 1311 14 17GMT 2006 ready User 192 168 10 111 none root331Password required forroot Password XXX230User root logged in ftp cd tmp250CWD command successful ftp lcd c NtempLocal directory now C Ntemp ftp bin200Type set to I ftp put morevrpd200PORT command successful 1500pening BINARY mode data connection
3. Remove All Filters Module Clientinfo OSUser Planhashvalue Servicename Username Wascontrolled Commandtype select count from te postgres select count from te postgres select count from tes postgres select count from te postgres select count from te postgres select count from te postgres select count from te postgres select count from te postgres select count gp segr postgres select count gp segr postgres select count gp_segr postgres 00 00 27 50 00 00 27 22 00 00 27 21 00 00 27 20 00 00 27 20 00 00 23 37 00 00 00 50 00 00 00 41 00 00 00 39 00 00 02 42 00 00 02 26 00 00 02 20 00 00 06 47 00 00 02 32 00 00 03 53 00 00 06 57 00 00 00 04 00 00 00 09 00 00 00 01 00 00 00 01 To start the investigation into performance with the Performance Bl module you need to define a few parameters e Time Frame e DB name s Resource order CPU Time runtime executions reads per sec etc 69 PivotalVRP PivotalVRP 6 0 User Manual Once this is defined you start building the drill down path by dragging filters in the order selected to the work plane up to 6 filters At any point you can take a step back and recalculate The results are displayed both in a list form and graphically top 10 By double clicking any selection the filters are populated with the information selected and the tree branches out Right c
4. 0 o 60 60 a 50 50 i ae 40 es b ip edi vars ricas Sereno Q 30 Time 27 02 2013 10 03 Ir o D Q E Medium Queries 9 20 A D e ia Long Queries m n 7 10 vi Type Long Queries n gt E Very Long Queries b Time 27 02 2013 10 03 o Value 3 9 28 9 30 9 32 9 34 9 36 9 38 9 40 9 42 9 44 9 46 9 48 9 50 9 52 9 54 9 56 Right click and double click functions Within the graphs section PivotalVRP v6 has a variety of additional functions available As previously shown within the live session dashboard section setting the cursor at different locations open various options In order to facilitate drill downs outside of PivotalVRP you can export results in various formats From 13 02 2014 E 00 00 S DE Name demo To 13 02 2014 EB 23 59 L amp lr Calculate Set server as well Set Time For All Graphs 100 Time 13 02 2014 10 33 CPU 74 80 o e e 609 Playback this event 5 ai What caused this peak a 20 Zoom in 0 f 0 00 1 00 2 00 3 00 4 00 5 00 6 00 7 00 8 00 9 00 10 00 Export graph to image 16 00 17 00 18 00 19 00 20 00 21 00 22 00 23 00 Settings ienBon g 30000 Global Settings 24000 120000 m About Adobe Flash Player 12 0 0 44 18000 a a 80000 i 1 m l 12000 j f mi f 40000 l ni i F wh j hi 1 i i T i i Wu T o Ul Vi ML i MI M LI I TUE LIU EL LUN DAI TUE UU d WM M MM 6000 o 0 0 00 1 00 2 00 3 00 4 00
5. Graphically displays the memory usage of the currently selected server in a pie graph free vs used Graphically displays the amount of network usage both received and sent of the currently selected server Enables the selection of the managed server for dashboard viewing from a pull down list of connected servers 22 PivotalVRP PivotalVRP 6 0 User Manual Using Right click Functions for Managing Resources You can manage resources create rules and prioritize the resource usage directly from the dashboard by using the right click functions that become available when selecting a transaction in the Database Data area The table below lists the right click functions that are available to each user type Right click Function Manage SQL Resources Create Rules from Data Create Rules from SQL Text Copy SQL Text Create tuning task Create Edit SQL tag Remove SQL tag Display session info Display explain plan Show estimated runtime Playback the last minutes Analyze query Show query segmentation Kill Session User Type Administrator and Operator Administrator only Administrator only Everyone Everyone Administrator and Operator Administrator and Operator Everyone Everyone Everyone Everyone Everyone Everyone Administrator and Operator Managing SQL Resources To Manage SQL Resources 1 Right click on the relevant transaction either the entire session or individual slices then s
6. PivotalVRP Agent s footprint in an average database is 0 596 of a single CPU where for example on a machine with four CPUs PivotalVRP consumes 0 12 of the machine s CPU capacity The system s console is installed on a dedicated Windows PC Server on the network collects various statistics correlates them and then logs them into an internal repository The system can be easily monitored and controlled by pre defined rules and corrected as required When a rule is defined the virtual partitioning of the server s resources is performed immediately by the PivotalVRP Agent Fully transparent to the database it does not require special configuration at the DB level Data is clearly displayed on the system dashboard on the PivotalVRP Console The dashboard allows users DBAs and managers to identify problems in the SLA and pinpoint any heavy transaction that may be the cause of the problem Users can create rules and prioritize the resource usage directly from the dashboard PivotalVRP supports Greenplum version 4 x and higher both CE amp SNE databases on the following operating systems Red Hat Linux SUSE Linux Sun Solaris HPUX IBM AIX and Oracle Enterprise Linux Database Operating Ui NIX System RENA PivotalVRP Console Server PivotalVRP PivotalVRP 6 0 User Manual Opening the Application PivotalVRP EE is a web based application This gives you the flexibility to use the PivotalVRP application using any inter
7. PivotalVRP PivotalVRP 6 0 User Manual Rules Wizard The Rules Wizard add on is the helping hand you need when you want to optimize your workflow and set a series of rules based on your current loads and the way you want to handle and prioritize them It gives you step by step instructions and recommendations as you go It allows you as well to set priority levels to the rules you want to implement based on their importance Business Procese name or nil OOO earn see nn ee E wi V Once you define the business process and the relevant priority and times you are asked to define how to activate the rule through Top SQL Program or other parameters Once you defined the trigger right click it and set the effect of the manageable painful transaction MPT hacin_amd_notification queue_ready 1 2 3 Define manageable painful transaction MPT Settings Global Settings About Adobe Flash Player 11 5 31 2 The third step in the process opens up the list of rules created by the module Double clicking any rule at this point will open up the standard rules window with all settings as created by the module You can modify them and edit them from this location or from the standard Rules module they are located in the Business Needs rules module 61 PivotalVRP Rule Module PivotalVRP 6 0 User Man Sal Business Needs test Business Needs Business Needs Variance select count f
8. e SQL Text User Name OS User Application Module Action Optimizer Cost Hit Ratio e Client Info e Command Type Note The selections are based on the Rule Creation dialog box 4 Select the number of slices to be presented in the pie chart 5 Set the SQL Sensitivity as follows Low presents high level information about the queries so that similar SQL statements are treated as one query High drills down into the queries to present more detailed information so that similar SQL statements are presented individually Hashvalue will select the queries according to their actual hash value 6 Select the required Sort By option 7 Click Calculate 51 PivotalVRP PivotalVRP 6 0 User Manual The information is displayed Top Queries Load Vs Runtime Statistics Query Distribution Runtime Statistics DB Name Calculate According To Number Of Slices 5 sj e Execution Optimizer Cost From 09 12 2012 SQL Text VO s cru d iO Select the amount of results you would like to compare 9 To 09 12 2012 E iv O Hashvalue O Hit Ratio Q Run Time Calculate _ Set server as well Set Time For All Graphs D 4 09 ofirm D 4 59 Other o 18 3 gp_etl_engine_dwh 35 5 gp etl engine ods D 37 7 gpadmin SQL text User Name OsUser Application Module and Action can be furthermore f
9. naor pg default At the bottom of the screen on the left hand side of the screen you have the ability to delete view related roles modify or add a queue Right clicking see above a queue provides you part of theses options too By selecting to modify the Resource Queue a new pop up screen will open which provides an easy way to redefine the resource queues Parameters such as max cost min cost active statements memory limit and priority can be easily altered Modify Resource Queue RQ Name Irado Max Cast 1 Cost Overcommit Min Cost oO Active Statements 2 Memory Limit MB 1 Prority MEDIUM MIN LOW i pr HIGH m MAX clicking the Related Roles button while selecting a queue will open up the related role window see below 67 PivotalVRP PivotalVRP 6 0 User Manual Related Roles Queue Name rado Related Roles jraduser Assigning a role to a resource queue can be done by selecting a role name on the right hand side table and either right click it or click the Assign button at the bottom of the table Inquire Assign Role To Resource Queue Role Name GuyE Queue Name pg default v assa All functions can be accessed though the buttons at the bottom of the page or right clicks on the queues and roles Additional information for the Inquire module can be accessed from the GUI by clicking the blue i button at the t
10. 5 00 6 00 7 00 8 00 9 00 10 00 11 00 12 00 13 00 14 00 15 00 16 00 17 00 18 00 19 00 20 00 21 00 22 00 23 00 dl Reads dl Writes As can be seen above if you right click any graph within PivotalVRP a window will open with the option to export graph to image Once selected a new window will open with the link to the image see below If you click the link a new web page will open with the copied image Should you want to retrieve it at a later time all exported material from PivotalVRP are saved in a folder at the following path C Program Files MoreDB GlassFish glassfish domains MoreVRP docroot Exports 55 PivotalVRP PivotalVRP 6 0 User Manual From 13 02 2014 E 00 00 c DB Name demo v To 13 02 2014 gl 23 59 H Calculate Calculate _ Set server as well Set Time For All Graphs 100 80 f o Image Link Uv or L e o https WIN UP66630BGP7 9191 Exports 89E495E7941CF9E40E6980D14A16BF023CCD4CO1 D 40 a 20 17 00 18 00 19 00 20 00 21 00 22 00 23 00 160000 quee 24000 120000 18000 w cr 80000 q Z 12000 IM n ou 40000 E I Y Ii i ih ui ul j n WU BET IU n A US l j T 6000 0 0 0 00 1 00 2 00 3 00 4 00 5 00 6 00 7 00 8 00 9 00 10 00 11 00 12 00 13 00 14 00 15 00 16 00 17 00 18 00 19 00 20 00 21 00 22 00 23 00 Reads p Writes File Lil Propam O quo o riwi Salman LJ LT Bray Hire jdi ba s Fea I14 DISPOLI
11. Nama Rule Crestor administrator Last Update 21 11 2012 sy 15138 Ruba Remark Rule Thresholds flar General Advanced Rule Activation Overrides DE Hamag 197 168 100 135 40000 192 15B 10 122 4nnan a z Select all servers Physical Reads TM 182 168 10 11 uv Clear selections 192 16B 10 1 SQL Text Cosine 192 168 10 1 Settings Run Timea Global Settings 192 16B 10 1 About Adobe Flash Player 11 5 31 2 From Firms E m To Time 7 F Rule Artiom 10058 Control 7 Distribute resources equally among all controlled jobs 2 In the Rule information section enter a new name for the rule and rule remark if desired in the relevant fields 3 The Rule Thresholds section consists of four tabs 25 PivotalVRP PivotalVRP 6 0 User Manual a Basic Tab Use the Basic Tab to define DB name right clicking enables select all servers function Physical Reads Write IO CPU usage SQL text Define the run time required and the time period required for running the rule b General Tab Rule Thresholds Basic General Advanced Rule Activation Overrides Machine 192 168 10 8 Regex amp Liters UserName postgres Regex e Liters OS User Regas a Liters Program Regex 0 Liars service Name Regex 0 Livra Command Type Use the General Tab to define Machine name which runs the SQL The user which runs t
12. e Managing Rules Adding a New Rule e Modifying Rule Activation Overrides e Modifying a Rule e Removing a Rule Rules best practices 36 PivotalVRP PivotalVRP 6 0 User Manual Rules Overview Rules are a set of thresholds and triggers that are user configured directing the application on what action to take control resources send email alert activate script or activate other rule based on the transaction behaviour Rules can be defined according to various factors such as e A specific SQL or part of it The Database username which executed the transaction e The Machine sending the actual transaction in the connected host The Hostname that initiated the transaction he program that launched the transaction According to the Module Action of the transaction he duration of the transaction e The amount of CPU or I O the transaction consumes e The level of utilization of the database server 3 PivotalVRP PivotalVRP 6 0 User Manual Managing Modules Modules are a set of rules that are grouped together in a logical folder which facilitates the activation of multiple rules configured within the application Adding a New Module To add a new module 1 Select Rules TAB from the option in the main menu The Rules screen is displayed i i Baa Corea L HFH ae L Sepir boo Garde Serete Tocha desine arain Lo Cra Edita 3333333231 So PO SS F F F pj ter 2 In the Modul
13. formorevrpd 226Transfer complete ftp 122562bytes sent in 3 57Seconds 34 37Kbytes sec ftp gt close Once you copy the file to tmp as described in the example you can move it to the destination Directory by mkdir bin morevrpd creating the directory mv tmp morevrpd bin morevrpd moving the agent file into it Note Make sure you copy the files while you are in bin mode for binary files compatibility 4 Make sure the file permissions are OK ls 1 bin morevrpd rwxr xr x lroot root 112331Jan 1014 02morevrpd 5 If not then change them with the following commands chown root root morevrpdchmod 755morevrpd Starting the Agent 1 To start the daemon manually cd bin morevrpd morevrpd start 2 PivotalVRP PivotalVRP 6 0 User Manual 2 The following output is OK Starting morevrpd When the daemon is started you should see three processes of PivotalVRPd activated ps ef grep PivotalVRPdroot 228091116 05 00 00 00 morevrpd startroot 228121016 03 QOSOUS00 7morevrpd startroot 228161016 092 00 00 00 morewvbspd start If you want the daemon to start automatically in your OS put into the automatic startup script of your server Ask your sysadmin to do that 73 PivotalVRP Stopping the Agent 1 If you wish to shut the daemon down type morevrpd stop PivotalVRP 6 0 User Manual 4 PivotalVRP PivotalVRP 6 0 User Manual Chapter 8 Important Files within PivotalVRP T
14. is displayed Define Rule Rule Mame Rule Crestor administrator Last Update 10 01 2012 uid wa Rule Remark DE Hamas orci Physical Reads O Physical Writes 0 CPU Usege D Buffer Hit Astig D SOL Text select count from dba objects dba obi _ Rem a Liew da ah j m i Run Time O oa D rmi au z x Dasa Pau bleubzs Secor _ From Tima To Time 1 30 Rule Action 10006 Control Yet DE LOO Distribube resources equally among all controlled jobs ox J Cancel The table below describes the elements that are displayed in the Dashboard Use regular expression matching if necessary or literal default Rule Name Enter a name of the new rule Rule Creator Enter the name of the creator Last Update Time stamp of rule creation update 40 PivotalVRP PivotalVRP 6 0 User Manual New Rule Parameter Description Rule Remark Enter any relevant remarks for the new rule DB Name Right Clicking allows to select all servers or clear all In the Basic TAB Selections Physical Reads Writes Enter the number of physical Reads Writes of a transaction to trigger the rule In the Basic TAB CPU Usage Enter level of CPU usage for the new rule In the Basic TAB Buffer Hit Ratio Enter Hit Ratio In the Basic TAB SQL Text Enter the SQL text for the new rule or part of it In the Basic TAB Run Time Set the run time for the new rule From To Time Set the t
15. pec ndo 3333588 3 8 sot oon 62 PivotalVRP PivotalVRP 6 0 User Manual The Skew Analysis was developed specifically for Greenplum environment now with just a few clicks you have the ability to discover skewing Through this screen you can also discover the distribution itself As with most PivotalVRP windows double clicking any result will open a new window with all the details and specifics relating to the selected session Variance Q Statistics Comparison Skew Analysis CPU Performance Runtime Performance I O Performance What s New Env amp 1 From 24 09 2012 E 09 00 Skew Runtime v By i 1 To 24 09 2012 EE 18 00 Y DB Name v Filter SQL Text v By Deme iMi anna o Select all servers Lc Clear selections 1 Set server as well Set Time For All Graphs Settings Global Settings About Adobe Flash Player 11 5 31 5 SQL Text Min Runtime Avg Runtime Max Runtime Maximum Segment Active Segments HVE select count from test 00 00 00 24 00 00 00 35 00 00 01 13 8 HVE select count from test 00 00 00 19 00 00 00 36 00 00 01 14 Bo 8 2012 09 24 17 43 09 ivSmAL HI sufkoeVu3Zb select count from test 00 00 26 00 00 00 27 17 00 00 30 06 Uo 8 The CPU Performance Runtime Performance amp I O performance tabs compare CPU runtime and I O consumption between two selected environments Statistics Comparison Skew Analysis CPU Pe
16. procpid ra re b 2012 12 09 10 14 15 demo 00 00 00 04 select count from dv b 2012 12 09 09 27 23 demo 00 00 00 15 select from pg lock b 2012 12 09 10 12 10 demo 00 00 01 17 create table dwh zzz dii b 2012 12 09 10 04 31 demo 00 03 04 27 select sum pg total rel b 2012 12 09 07 26 43 demo 00 00 00 06 select psa procpid ra re 52 PivotalVRP Query Analysis PivotalVRP 6 0 User Manual This graph allows you to create a custom made graph based on any of the filters provided here The graph is divided into 3 tabs which allow a very specific drill down by allowing specific filtering parameters To create the Query Analysis graph Set any of the provided filters and click Calculate The information is displayed dna Flisa Fae rir F bang Literal Fibers Cerirm ling FI ula CE Hama Hu ee burn CE Papal iirjar Ea mas Cedar Mapam Lael mm Suction r Beseersieg A POL Tm Ei ara rea Date Sat Tir EE 30300000 anra aioe Slan Firma Hest Kushiro Se Tem Fla ane Ir arrer cru DIDI Ed DST arc main died ps Da 98 33 14 salet court JANION LRI pee Pa zdzz 31 z4 Sieger ad Ce 5 32 13 maHtcoeant ee portgar bx Z212 31 54 gee ied pa GE 33 smimrb meanb 1 23 388 15 223 pentes 2012 8 E4 12 87 08 gee in eT DO 32 33 13 malactrount JANION LRI poyan Es z di1r 11 z4 12ST pein eS Do 08 31 13 BHi cani F ifi ahi Lb 023 postgar xi Z312 31 B4 IDT german MEIO W ghan sm
17. rule will apply to every user in the database Modifying Rule Activation Overrides If you want rules to be automatically activated only when the entire database server is under load you can use the Rule Activation Overrides These rules allow you to configure the amount of resources the server should reach prior to automatically activating the rule To modify the global thresholds of a rule 1 In the Rules screen select the required rule and double click on it or while creating a rule The Rule page shows up select Rule Activation Overrides until it s displayed Rule Thresholds Basic General Advanced Rule Activation Overrides Only activated when total CPU load is above Only activated when total Physical IO is above Use both CPU and IO thresholds Allow activation by other rules Rule Priority 25 highest priority J 2 Define the thresholds as described in the table below Threshold Description Only activated when total CPU Select the check box and enter the CPU load percentage to activate the rule when the load is above CPU load reaches the defined percentage Only activated when total Select the check box and enter the total I O percentage to activate the rule when the Physical IO is above total I O reaches the defined percentage Use both CPU and IO Select the check box to use both the CPU and I O thresholds for this rule thresholds 42 PivotalVRP PivotalVRP 6 0 User Manual Threshold Description Allow activ
18. similar processes This can be used to avoid parallels gm Lm 0 SER Rule Information Rule Name Rule Creator administrator Last Update 17 02 2014 Rule Remark Physical Writes 0 Buffer Hit Ratio o e Select count from select from test O Regex Liters 0B CBB B Days Hours Minutes 00 Seconds To Time 18 00 H Ex 2 Execute Script When selecting this you can activate scripts with this rule Rule Creator administrator Last Update 17 02 2014 Rule Remark 29 PivotalVRP PivotalVRP 6 0 User Manual 3 Send Email When selected the rule will send notifications to the recipients Before use the mail settings have to be defined The Test Settings button will check you connection The Test Recipient will send a test e mail to the recipient Define Rule Rule Information Rule Name E Rule Creator administrator Last Update 17 02 2014 CPU Usage Buffer Hit Ratio o SQL Text Select count from select from test O Regex 0 Literal 4 Activate Rule e The rule will activate a different rule Define Rule Rule Information Rule Name Rule Creator administrator Last Update 17 02 2014 Rule R
19. tab as guy t 00 05 20 28 By double click on the SQL Text you will get more information about the specific SQL by way of Query Segmentation graph o w N r o 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 12000 14000 RunTime in sec 00 07 13 01 Copy SQL text Create tuning task Create rule from SQL text Export to CSV Settings Global Settings About Adobe Flash Player 11 9 900 170 00 00 00 00 00 07 14 57 00 07 14 56 00 07 14 56 00 07 13 03 00 08 05 49 00 07 25 10 00 07 15 06 00 07 16 46 2014 01 01 07 01 2 2014 01 01 07 01 2 2014 01 01 07 01 2 2014 01 01 07 01 2 2014 01 01 07 01 2 2014 01 01 07 01 2 2014 01 01 07 01 2 2014 01 01 07 01 2 2014 01 01 07 01 2 2014 01 01 07 01 2 nod26 40001 nod6 40002 nodi2 40002 nod19 40008 nod1 40006 nod19 40005 nod25 40006 nod25 40001 nod10 40002 nod2 40006 00 07 12 42 00 06 13 41 00 07 13 03 00 07 12 42 00 06 14 03 00 07 12 42 00 07 12 03 00 07 12 03 00 07 13 04 00 00 00 01 select from gp too select from gp too select from gp tool select from gp tool select from gp tool select from gp tool select from gp tool select from gp tool select from gp tool select from gp tool Copy SQL text Playback this event Create tuning task Create rule from data Create rule from SQL text Display explain plan Export to C
20. user 16 PivotalVRP PivotalVRP 6 0 User Manual General Settings To manage General System settings 1 From the Settings menu option select General 3 10 110 127 86 5432 10 110 127 86 40000 Try reconnecting every in seconds 10 10 110 127 86 40001 V Automatically reconnect when disconnected zx 10 110 127 86 40002 L Limit number of reconnect attempts 100 iw q 10 110 127 86 40003 Data polling interval in seconds 5 n Statistics polling interval in seconds 3 m Connection timeout in seconds 50 m Maximum IO per second 6000 Keep data from the last 36 n Months v The General Settings screen Is displayed 2 Enter the required settings see General Settings Table 3 Once the environment has been defined the known servers list will display the current connections and their status connected and OK 17 PivotalVRP Repository Settings To manage the Repository settings 1 From the Settings menu option select Repository Settings 2 Type in the Keep Data value default 3 month 3 Click Save Settings The Repository Settings Screen W Autemabzcally reconnect when disconnected Try raconnecting every in seconds 10 Limit number of reconnect attempts 1 Data polling interval in seconds s 1g Statistics polling interval in seconds 3 Connection timeout in seconds o B Maximum IO per second 6000 Keep dat
21. 47 Load vs Runtime 49 Statistics 50 Query Distribution 50 Query Analysis 93 Runtime statistics 54 Right click and double click functions 55 Chapter 6 Working with Add Ons 57 Add Ons button bar 58 Tuning Tasks 58 Chargeback 59 Rules Wizard 61 Variance LLL 62 Inquire CYS Playback iB Performance BI CED Chapter 7 Managing the PivotalVRP Agent 71 Installing the Agent 72 Stopping the Agent 74 Chapter 8 Important Files within PivotalVRP 75 PivotalVRP PivotalVRP 6 0 User Manual Chapter 1 PivotalVRP Overview This section provides you with an overview of PivotalVRP its architecture and the information you need to get started Topics e About PivotalVRP e System Architecture e Opening the Application PivotalVRP PivotalVRP 6 0 User Manual About PivotalVRP PivotalVRP Virtual Resource Partitioning enables your organization to execute Virtual Resource Partitioning of hardware resources CPU I O of your IT transactions based on business priorities and needs in real time By building the VRP your organization is able to manage the load of each transaction individually providing a better QoS and response time for all your transactions PivotalVRP software boosts performance and availability of database dependent applications in real time PivotalVRP is applicable to a wide spectrum of DB based enterprise environments in particular database infrastructure supporting ERP CRM DW in house applications and ot
22. 990043108 alue 0 tAn9gDeXOxhJUFbqQk27Iw o e 0 10 110 127 86 5432 gpadmin a psql ion moredemo ent Info demo e 17 02 2014 10 41 01 00 00 01 03 Display explain plan To display the explain plan 1 Right click on the required transaction and select Display explain plan A new window will open with the execution plan for the selected transacton F y a ereto lee ee ee k Bartad Lorp icrrt izrzjd 17 232327 94 rcowrz 427173 widzh 2 gt RSTn foan CE pg Pirr all sarclngr a inirzEJ 20 12 70 rrwms 20D9 video gt Hacarinlisa czsrelr4 27 22 24 mowed widrhel Hose Lats doada i2name42 85 122 85 moe video Hask Condo d telha gds hmi Hash fein o memaweam s T2 1 4 8 eee eis Hapi Crede eid T m redmmind Th artei Losp icartE434 0L 91 99 sees esl widrh E Martel Lesp icaorrzE 5 D2 51 324 corel wiZcbksDi gt HaszAgqguragura joowrel 28 D217 coral widehe li Broup By cooled Snag E le Ul Haak Lede Jada amarmi Ei 878 eel debe dd Hash Cena nad Ti tedee lid Hash Delt Fenn o DzmegeT2 18 12 0D0 eee eadeh dl Hash Cond zc rslrnamerpacs T mn rid gt Tag Tcan cn pg clama co lcome l id 8 ao cove lis idrre7z Filtar maliindo ANY j z u akan Hash Geena DT i GOT akma led f ieg fra
23. ELIG 227 Piihi 7 3 3 6 H E D Lu j LE Double clicking any of the queries will open up the following graph which shows the runtime segmentation of the particular query Bente Slatin gt eai ias N i irarri 177 Erin Irat Labs a lues Hals da Runtime statistics The Runtime Statistics window provides graphical resource consumption and performance information at the touch of a button You can define your query runtime thresholds and filter the specific information you seek The Transactions per second TPS vs health graph shows the overall load effects on your systems health Correlating the information on the 3 graphs can quickly point out how resource usage and TPS affect performance Hovering on any point of the graphs will provide numerical values for the point selected 54 PivotalVRP PivotalVRP 6 0 User Manual Top Queries Load Vs Runtime Statistics Query Distribution Query Analysis Runtime Statistics From 27 02 2013 EM 09 28 c DB Name more ee Ri I O Limit 3000 te To 27 02 2013 ier 10 08 c ivi Short Queries 3 gt Sec v Medium Queries 11 Sec v Long Queries 31 Sec iv Very Long Queries 51 baa Sec Calculate Calculate _ Set server as well Set Time For All Graphs 100 i Li 12000 B a i un hi F cpu 9 Ly 8000 er o Paine hs EM anum I 4000 F writes 20 i 0 0 100 100 m 80 80 I 60 60 0 d y F ps dies TENTAT Y 13 ae E com 20 20
24. Free GB E used GB D Received me Sent mB Display session info Display explain plan Show estimated runtime 58 PivotalVRP PivotalVRP 6 0 User Manual Task Id Severity Opening D Last Updat Closing Date Task Creator Task Closer Developer Developer Remarks 2013 12 10 2013 12 10 Guy i Take a look at this Do e Edit tuning task Remove task Resend email task Refresh Settings Global Settings About Adobe Flash Player 12 0 0 44 The tuning task window lets you track all tasks and their status As an administrator you can change their severity level and edit or remove them when necessary At a glance you can see which developer is working on the task and what the date of the last update is Sins Opin o mit coe From oder Hir High T TT PED ERG DAI id D Qi LR nl fg wu usam DE nid a E 1 Cuba HH S LA decd re rage Tanz C raiz AMPLE SEX fri RES waa a d ERRA Psi Sewers HT Chest Iai Sos Tema Le LSP ee Runrima EO LS SS Chargeback The Chargeback add on was created as an essential tool for PivotalVRP users and providers that use or provide database services or for organization wanting to be able to track their tenants resource usage It allows you to set pricing to resources and services provided on a per user basis With a simple to use interface all you need to do is define your tenants through a variety of parameters available You start in the
25. LED 1H i aL D Hau Umda Era ambos laio for Torre bur Al Graphs oer dpi e n ont g X a nl h Seaia Te iibi LP i e far Order Es Severe T Clear tebe Jl Gesrigas Al dreary eus hrs dl a E E E Fur Ens litro LEU sro Esta lia LR Pike ir ex i Pas 10 Buster i prana m XE 0223 30 13 d dik nit HaT 0 abi Lico ns i ar Bev der Mm aoe od B ola imag a gccatar oq Dina ES J Am gv E mM iti FF heii i Ag gs Z Ai GE TE al Te a a Soe ma 1 LT aot rp aan aprr vr ar resto turas g bank EE afago Qu o T i arbi a aur dae LE Cu OF Emp Ya CTA i a ao mum fel ni a 1 hiro La Prd Taran pre DR OE Hote Sega r 2 B5 i DO aG da mhs bie Fr About Adobe Pah Piper 12 3 232 55 Eai As can be seen above if you right click any table within PivotalVRP a window will open with the option to export to CSV Once selected a new window will open with the link to the CSV If you click the link a new web page will open with the data The file is available in the same folder as the images within PivotalVRP in Glassfish It can be easily opened in excel or any other comparative program which imports CSV The data within the file is delimited by semicolons 26 PivotalVRP Chapter 6 Working with Add Ons Topics e Add Ons button bar Tuning Tasks Chargeback Rules Wizard Variance Inquire Playback Performance Bl PivotalVRP 6 0 User Manual 57 Pivot
26. Pivotal PRODUCT DOCUMENTATION PivotalVRP Version 6 0 User Guide Rev A01 June 10 2014 O 2014 Pivotal Software Inc PivotalVRP Copyright PivotalVRP 6 0 User Manual Copyright O 2014 Pivotal Software Inc All Rights reserved Pivotal Software Inc believes the information in this publication is accurate as of its publication date The information is subject to change without notice THE INFORMATION IN THIS PUBLICATION IS PROVIDED AS IS Pivotal Software Inc Pivotal MAKES NO REPRESENTATIONS OR WARRANTIES OF ANY KIND WITH RESPECT TO THE INFORMATION IN THIS PUBLICATION AND SPECIFICALLY DISCLAIMS IMPLIED WARRANTIES OF MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE Use copying and distribution of any Pivotal software described in this publication requires an applicable software license All trademarks used herein are the property of Pivotal or their respective owners Use of Open Source This product may be distributed with open source code licensed to you in accordance with the applicable open source license If you would like a copy of any such source code Pivotal will provide a copy of the source code that is required to be made available in accordance with the applicable open source license Pivotal may charge reasonable shipping and handling charges for such distribution About Pivotal Software Inc Greenplum transitioned to a new corporate identity Pivotal Inc in 2013 As a result o
27. SV Settings Global Settings About Adobe Flash Player 11 9 900 170 o o O Oo OO OOO oO o Q oro oro OQ o 48 PivotalVRP PivotalVRP 6 0 User Manual Some of the options include copying the SQL text playing back events analysis creating tuning tasks rules and exporting to csv Load vs Runtime This graph is used to present information to show how the load on the system affects user experience when running a query The graph compares the load on the system to the runtime of the query enabling you to see the correlation between CPU or IO load and the execution time of queries This enables you to build Rules accordingly paying particular attention to the Rule Global Thresholds see Modifying a Rule To view the Load vs Runtime graph 1 In the Choose Filters section select the filter type from the Filter based on drop down list CPU Per Sec Reads Per Sec Writes Per Sec 2 In the Host Name field select the server that is being controlled 3 Set the Start Date and Start Time and End Date and End Time 4 In the Number of Queries field select the number of queries to be compared 5 Click Calculate The information is displayed Top Queries Load Vs Runtime Statistics Query Distribution Query Analysis Runtime Statistics From 07 05 2012 H8 09 00 DB Name v Filter based on Reads Per Sec WW Us To 07 05 2012 E 18 00 Ls Number of Queries 10 1 Set server as well S
28. a from the last 3 B Months PivotalVRP 6 0 User Manual 18 PivotalVRP PivotalVRP 6 0 User Manual My User Settings Once the administrator has defined users via the Settings tab administrators operators and users all have access to the My User Settings area This area provides access to personalized settings within PivotalVRP The first tab My Operational Settings contains general information such as email settings and logout timing Make sure that for User Name you enter a complete email address for example johndoe email com Once you have entered your custom settings click Save Settings My User Settings Screen Automatically logout when idle for 10 S Minutes v The second tab My Graph Settings allows each user to save his her own preferred time periods for all graphs and add ons This allows you to complete long drill downs or investigations over a period of time without the need to reset the dates after each logout In this area you can also set the default SQL sensitivity Once you have entered your custom settings click Save Settings Base Date And Time Compare Date And Time Default Teday L Selected Time Default Today Selected Time O From 17 02 2014 EB Start Time 05 00 O From 17 02 2014 gj Start Time 05 00 To 17 02 2014 End Time 8 00 To 17 02 2014 End Time 18 00 4 4 S
29. alVRP PivotalVRP 6 0 User Manual Add Ons button bar The Add ons are additional modules that add features to the PivotalVRP system they are developed by the PivotalVRP development and engineering team There are a few add ons available for the PivotalVRP system These Add ons are important additions that based on your usage of the PivotalVRP system and or your environment contribute to your workflow They include Tuning Tasks Chargeback Rules wizard Variance Inquire Playback and Performance Bl This section will provide brief description for each add on Tuning Tasks The tuning task add on is a feature that allows you to create a workflow for transactions that need fine tuning or that create problems within your database It is the perfect tool for follow ups and pulls all the pertaining information needed with the click of a button The tuning task is available both from the Dashboard window and several graphs right click on transaction and through the Tuning Tasks button which opens the Tuning tasks window DB Sessions System Dat Segment DB User Name Control SQL Text Y demo moredemo gpadmin Controlled Select count fro 10 110 127 1 moredemo gpadmin Parking Dis Select count fro 10 110 127 1 moredemo gpadmin Parking Dis Select count frol Create rule from SQL Text Edit SQL tag Remove SQL tag Create tuning task Playback the last minutes Analyze query Show query segmentation Copy SQL text
30. ase make sure you selected the master segment usually ending with 5342 All reports DCR Report https WIN UP66630BGP7 1 KZ My GP Info DCR Reports vm27 DCR 20140525 143348 html Free space per segment per device Postgres conf parameters aggregation Size of databases Resource queue statistics Resource queues assigned to roles Sessions that are idle for more than an hour Please note while running the DCR report you may notice a spike in resource consumption Generate Report Get Old Reports Having this type of report available can help you understand how your GPDB environment grows over time and keeping this info for future comparison can help you with forecasts and trending including those relating to structure and capacity The DCR reporis are kept on the PivotalVRP server 65 PivotalVRP PivotalVRP 6 0 User Manual 310 Performance Report mdw 5432 04 07 2013 09 01 59 Free Space Report opment TD fost Name Dovie Froe space m GE DA o aaa T EEE E mim EE DESIRE EESC DIE EEE DUTO reee e d SS E RA EE e 70 hc ENFIN ESTES 3 7 2 asd evinanper nd e roo 5 soa aevimpperva odio rem Es 17 nodio dev mapper vg nod10 lv root 31 O dev mapper vg nod10 hv EI NN f 20 nod dev mapper vg nodll lv ro ot Postgres Parameters Report s s M
31. ate serials set clienti update obj set obj 4 update mgmt availability update logins set serialic 1 1 1 1 1 1 update ir sys usersbonu 1 update gamer mailservic 1 update gamer ir sys ext 1 update creditcardnumber 1 update casino users set 1 1 update casino users set Inquire 1761686866 2740865541 2281092493 1269766576 159997841 3200756901 2823207502 3319464348 743304949 912967397 1121653670 3148896160 1720306847 Show all instances Total Physical Read From 07 05 2012 09 00 From 06 05 2012 By To 07 05 2012 gi 28 00 Ls To 06 05 2012 18 00 E Calculate Calculate SQL Text 1 v Executions Hash Value SQL ID Total Runtime Total Logical Read Total Physical Write 0 0 0 Copy SQL text o 0 0 Create tuning task 0 0 0 Create rule from SQL text 0 0 0 Export to CSV 47 166 49 Settings E 9 2 Global Settings a About Adobe Flash Player 11 5 31 5 x s D 0 0 3dd3h3cv6pjr5 00 00 00 01 778 0 4b6vygjidq4x6 00 00 00 01 0 0 f kam52xvOpxO 00 00 00 01 0 0 6pspd7dm8mm4z 00 00 00 01 0 The Inquire module is the DBA s Swiss Army knife It consists of 3 useful tools that help make a DBA s life easier The Inquire s module locks view window displays all current lock in your database In case you have blocking locks you can view them by pressing the Get Blocking locks button otart by selecting the master segment from the DB name pulld
32. ation by other rules Select the check box to allow other rules to activate this rule Rule Priority In case a certain event can is identified by 2 rules the rule with the highest priority will take precedent Modifying a Rule To modify a rule 1 In the Rules screen select the required rule and click Edit Rule The Edit Rules dialog box is displayed 2 Makes the necessary modifications to the rule and click OK Removing a Rule To remove a rule 1 In the Rules screen select the required rule and click Remove Rule NOTE there 1s no Remove Module dialog box to display Rules best practices There are 3 types of rules Rules of stability These are in effect rules that are created in order to keep the DB environment at optimal operation levels They are defined and triggered by thresholds defined at the server level at any point when any single server gets to a particular load level the heaviest resource consumers are restricted in levels according to their loads They are grouped and can be defined by CPU usage IO usage and runtime while using resources Usually these will be defined in incremental steps Targeted Rules These can be triggered by a single parameter or a series of them These are usually used when you are targeting a specific user process application etc General Rules These are created for certain situations but are applied to less specific processes A good example is that when you have mult
33. cal Reads O Physical Writes O CPU Usage O Buffer Hit Ratio O SQL Text select count from dba objects dba obj Regex m Literal Run Time O j o to 1 0 Days Haus Harutes De merda _ From Time To Time Rule Action 100 Control 0 100 TE I I I I I L I I LI I Distribute resources equally among all controlled jobs Cox canes 2 Enter a new name for the rule and rule remark if required in the relevant fields 3 Define the required parameters for the Rule Limits Use either literal or regular expressions to match your criteria For example to cover all Schema Usernames except Schema that contains xxx in its name use XXX S in the Username field and then select the regexp button Another example If you want to capture everything except a specific schema name ABC use No 2 2 Aa Bb Cc No Nw Vo in the Username field and then select the regexp button 4 Define the required run time and the required time period for running the rule 5 Choose the action you would like to use after the rule is applied See Rule Action for details 6 If required select the Distribute resources equally among all controlled jobs check box then click OK 31 PivotalVRP PivotalVRP 6 0 User Manual The rule is automatically added to the list of rules in the application see Administering Rules Copying SQL Text To copy SQL Text 1 Right click on the required transactio
34. customer setting window once you have created the user you can define its mapping through various available parameters The add on also includes a built in invoice generation summary billing per customer and more 99 PivotalVRP PivotalVRP 6 0 User Manual Customer Settings Time Added Customer N Description ContactName Conta Contact Phone Price Per CP Price Per Re Price Per Wr Fixed Fee 15 11 2012 11 2 Guy Accounting Guy guy erezfa 0 01 0 01 0 01 20 Mapping Identifier Description lv OS user guy on server78 T P Action l Action Machine Module OsUser Program There are two main views to the Chargeback add on the customer setting view contains all the info about your customers and the billing view which has all the information pertaining to billing such as Ad hoc billing customer billing and invoices The Billing View window is divided with three tabs here you have the ability to create ad hoc bills review your customer billing and create invoices with a right click and review all invoices created The Ad Hoc Billing tab enables you to create on the fly customers and evaluate resource costs by tenant on a single screen Ad Hoc Billing Customer Billing Invoices 01 05 2012 LE 15 05 2012 EA Resources Rates Vere Billing Segmentation pesy Billing View Customer Billing Billing Segmentation 60
35. d for the PivotalVRP connection to the DB Connection Type Select Automatic enumeration for connection to the full environment Single Segment if you wish to connect to a single segment Test Connection Verifies that the setting are correct and that PivotalVRP can communicate with the segments Press OK 5 Provided PivotalVRP was installed correctly you will see the segments populating the Known Server list 6 Once you are connected select Dashboard from the Main Menu in the left pane You can now start working with Pivotal VRP If you encounter any problems during the above procedure contact PivotalVRP support at support 2morevrp com The General Settings screen 10 PivotalVRP PivotalVRP on Settings PivotalVRP 6 0 User Manual Server Information Sett User Name The General Settings table below details the login information and system settings displayed in this screen Setting Connection Name Host Name IP Port User Name Password Connection Type Test Connection Automatically connect upon disconnection Limit number of reconnect attempts Data and statistics polling settings Data polling interval Statistics polling interval Connection timeout Maximum IO Repository setting Dashboard Administrator Mode Description Name of the view The IP of the Master node or segment server depending on the connection type default for master for auto connect is 5432 for single co
36. elect Start Managing Resources The Manual Control dialog box 1s displayed Manual Control PID 3008 100 E 100 OK Cancel 23 PivotalVRP PivotalVRP 6 0 User Manual 2 Using the slider set the throtile at the required setting then click OK The Manual control range can be defined differently for each user by the administrator 3 The control affects both CPU and IO at the same level and relate to the maximum potential resource usage of the session The Acceleration Chart will change to display the new level of resource management Creating Rules from Data Using the information displayed in the dashboard to determine the level of resource management required you can easily create a rule that will have an immediate effect on the managed resources This option automatically locates within the system most of the relevant data required to create a rule requiring you to proactively define only a minimum number of parameters For further information about creating rules see Managing Rules To create a rule from data 24 PivotalVRP PivotalVRP 6 0 User Manual 1 Right click on the required transaction then select Create Rules from Data The Defines Rule dialog appears This dialog contains 3 sections Rule Information Rule Thresholds which contains four tabs Basic General Advanced Rule Activation Overrides Rule Action The Define Rule dialog Define Rule i Rule Information Rule
37. emark _ Rule Thresholds Basic General Advanced Rule Activation Overrides DB Names v Physical Reads jo Physical Writes o CPU Usage 0 Buffer Hit Ratio 0 SQL Text select count from select char length Regex e Liters Run Time co B e lS le B o Days Hours Minutes Seconds 18 00 O From Time 09 00 To Time Reporting Tools Business Objects Any Business Objects Query X Rules Examples Regular Expressions Examples By Database User Rules Examples Regular Expressions Examples By Machine E The rule s automatically added to the list of rules in the application see Administering Rules Creating Rules from SQL Text This option for creating a rule after reviewing the information displayed in the Dashboard automatically provides the SQL Text contained in the transaction requiring you to define the remaining parameters For further information about creating rules see Managing Rules 30 PivotalVRP PivotalVRP 6 0 User Manual To create a rule from SQL Text 1 Right click on the required transaction then select Create Rules from SQL Text The Define Rule dialog box is displayed with Rule Limits parameters automatically defined Define Rule Rule Information Rule Name Rule Creator administrator Last Update 10 01 2012 i id i 13 Rule Remark Rule Thresholds Basic General Advanced Rule Activation Overrides DB Names orcl Physi
38. es according to their actual hash value 47 PivotalVRP 6 Click Calculate The information is displayed Top Queries Load Vs Runtime Number of queries to filter 10 cat SQL Text Filter based on Runtime v From 01 01 2014 To 10 01 2014 DB Name v SQL Sensitivity Hashvalue Set server as well Set Time For All Graphs select from test_tab limit 100 set datestyle to iso select from gp_toolkit gp_disk_free select pg_highest_oid vacuum select from gp_toolkit gp_disk_free select 11 count from test_tab a select from test_tab select count as rows from only test_ select count from test_tab as guy t 00 07 13 01 00 07 13 01 00 07 06 59 00 05 56 38 00 05 35 16 00 05 34 24 00 05 31 42 00 05 24 43 00 05 21 38 00 05 20 28 PivotalVRP 6 0 User Manual 7 Right Clicking a session will open a drop down menu which allows the user to copy the SQL text create a tuning task create a rule or export the info to csv select from test_tab limit 100 select from gp_toolkit gp_disk_free select pg highest oid vacuum select from gp toolkit gp disk free select 11 count from test tab a select from test tab 00 07 13 01 00 07 06 59 00 05 56 38 00 05 35 16 00 05 34 24 00 05 31 42 00 05 24 43 select count as rows from only test 00 05 21 38 select count from test
39. es pane click Add Module or right click in the Module pane and select Add Module A new branch is added to the Module tree 3 Enter the required name for the new module 38 PivotalVRP PivotalVRP 6 0 User Manual Removing a Module In the Modules pane select the required module and click Remove Module or right click in the Module pane and select Remove Module 1 A new window pops up requesting your action 2 Select move rules to a different module or select the remove button 3 Once the rules moved to a different module or have been deleted the Module will disappear from the Module tree 4 When you remove a module you will only be able to remove rules that you are allowed to administer Remove Module ETL Tools x The module ETL Tools contains rules Would you like to e Move the rules into Custom Rules Examples L el Rules Examples General use Rules Examples Regular Expressions Examples M Reporting Tools The module is removed from the Module tree Editing a Module 1 In the Modules pane select the required module and click Edit Module or right click in the Module pane and select Edit Module 2 Enter a new name for the module 39 PivotalVRP PivotalVRP 6 0 User Manual Managing Rules Rules can be easily built and customized to facilitate efficient management of resources Adding a New Rule To add a new rule In the Rules screen click Add Rule The Define Rules dialog box
40. es you access to a different graph The purpose of these graph is to visualize your database performance from different aspects They allow you to track your performance based on your repository and see how PivotalVRP is boosting the ROI improving your SLA and making better use of your resources Set server as well Set Time For All Graphs Top Queries This graph uses a filtering mechanism based either on Runtime to display the queries that take the longest to run in the system or based on I O to display the queries that consume the largest amount of resources To create the Top Queries graph 1 In the Choose Filters section select the filter type from the Filter based on drop down list e Runtime CPU per Sec Reads Per sec Writes Per Sec Hitratio and Optimizercost 2 In the Number of queries to filter field enter the required number of filters 3 In the from and to fields select the Date period that you want to view 4 In the DB Name field select the DB that is being controlled right click enables select all servers clear options 5 Set the SQL Sensitivity as follows Lowest presents high level information about the queries so that similar SQL statements are treated as one query 40 characters Highest drills down into the queries to present more detailed information so that similar SQL statements are presented individually 1000 characters Hashvalue will present the top queri
41. et Time For All Graphs 19 PivotalVRP PivotalVRP 6 0 User Manual Chapter 3 Viewing Data from the Database Topics Overview e Understanding the Dashboard Using Right click Functions for Managing Resources Managing SQL Resources Creating Rules from Data e Rule Action e Creating Rules from SQL Text e Copying SQL Text Creating a tuning task e Tagging SQL Text Display session info e Display explain plan e Kill Session e Changing User 20 PivotalVRP PivotalVRP 6 0 User Manual Overview PivotalVRP collects all the information about transactions submitted to and from the database which typically represent communications between user applications and the database database functions batch files etc The collection of the information about the transactions which is executed at the operating system level is a non invasive process which does not affect the database in any way The information that is collected is displayed on the PivotalVRP Dashboard Via the dashboard you can see any resource problems within your applications and identify any heavy transactions that may be affecting its efficiency In addition you can create rules and prioritize the resource usage directly from the dashboard 21 PivotalVRP Understanding the Dashboard DB Sessions Segment DB User Name Control SQL Text CPU Memory MB Reads b demo moredemo gpadmin None select count from sele 61 4 276 1272 10 110 127 86 mo
42. et Time For All Graphs Calculate Calculate begin emd_no select t usern select hardwa select max cr select real ac select bonus select registe select authen select u mast select to_char 20 n 5 16 12 ib i 8 Q 4 ta 0 0 10000 20000 30000 40000 50000 eogat Average Reads per sec Close Tab The graph displays the top queries as defined in the Number of Queries field In the tab of each query is the name of the query and the number of occurrences during the defined time period The chart will present the breaking point at which user experience is slowing down and performance is deteriorating 49 PivotalVRP PivotalVRP 6 0 User Manual Statistics The Statistics graph presents the level of IO amp CPU resource consumption When you mouse over any point on the graph you get numerical values of the point selected In order to get a better picture of any given point you have the ability to right click and zoom in on a shorter period of time this will provide a higher level of resource usage detail Please note that since you are reviewing an MPP environment the top level view doesn t always provide a full picture you have the ability to get this information at the segment level too by selecting an individual segment in the DB name pull down menu To create the Statistics graph 1 Select the Environment or segment in the DB name pull down menu 2 In the Choose Filters section set t
43. f the day by simply limiting their resources instead of delaying them e Ability to manage existing resources more efficiently e Pre defined rules and modules for ERP CRM DBA tools Bl and Data Warehouse that can be fine tuned to specific needs and added to when required otal transparency to users and applications Definition of custom rules quickly and easily PivotalVRP PivotalVRP 6 0 User Manual Reduction in use of power and datacenter capacity Allocation of resources so that the most important transactions have the lowest response times and the most resources Receipt of alerts anywhere Acceleration of transactions for high priority modules or users that you want to run faster in accordance to your business needs Upgradeable though various modules for your future business needs PivotalVRP PivotalVRP 6 0 User Manual System Architecture PivotalVRP is composed of the following two main elements e PivotalVRP Console PivotalVRP Console is an MS Windows based WEB GUI console that can be installed on any PC that runs Windows XP SP2 2003 2008 2012 Vista Windows 7 and Windows 8 The console allows you to monitor your various databases investigate performance issues and apply manual or automatic rules as needed PivotalVRP Agent PivotalVRP Agent is installed on the database server itself The agent is controlled by the console and performs the actual resource allocation according to the rules
44. f this transition there will be some legacy instances of our former corporate identity Greenplum appearing in our products and documentation If you have any questions or concerns please do not hesitate to contact us through our web site http gopivotal com about pivotal support PivotalVRP Contents Chapter 1 PivotalVRP Overview About PivotalVRP System Architecture Opening the Application Chapter 2 Managing System Settings User Management General Settings Repository Settings My User Settings Chapter 3 Viewing Data from the Database Overview Understanding the Dashboard Using Right click Functions for Managing Resources Managing SQL Resources Creating Rules from Data Rule Action Creating Rules from SQL Text Copying SQL Text Creating a tuning task Tagging SQL Text Display session info Display explain plan Kill Session Changing User Chapter 4 Administering Rules Rules Overview Managing Modules Adding a New Module Removing a Module Editing a Module Managing Rules Adding a New Rule Modifying Rule Activation Overrides Modifying a Rule PivotalVRP 6 0 User Manual o o o Ol 14 17 18 19 20 21 22 23 23 24 28 BW 32 8 33 33 34 34 35 36 3 38 38 39 39 40 40 2 43 PivotalVRP PivotalVRP 6 0 User Manual Removing a Rule 43 Rules best practices 43 Chapter 5 Working with Graphs 45 Accessing the Graphs 46 The PivotalVRP Graph Window 47 Top Queries
45. fication or the activation of another rule You can define the same situation and have multiple actions happen in parallel For instance if a particular user runs a certain transaction and the load on your system is beyond a pre defined threshold you can set PivotalVRP to notify you via e mail and reduce the resources available by a certain percentage Aule Action Dropdown Menu ote IVRP Define Rule a da Rule Information m 4 Rule Name eg Dashboard Administrator demo Rule Creator administrator o ast Update 17 02 2014 E 10 59 E Acceleration Transactions 15 active sessions Refi CPU 32 Rule Remark stem Dat O Secs a ma Segment DE er js Netes E Rule Thresholds gt dem moredem pad a Basic General Advanced Rule Activation Overrides fer moredem oped d dem moredem oped DB Names L nam X 2s a b Physical Reads o Physical Writes 0 JE d I CPU Usage 0 Buffer Hit Ratio 0 Reads 7347 Writes 133 Reads g Writes There are four types of Rule Action e Control Execute Script e Send Email Activate Rule Each is described below 28 PivotalVRP PivotalVRP 6 0 User Manual 1 Control With control you can use the slider to set the throttle level for the rule o select the option Distribute resources equally among all controlled jobs click the checkbox and click on OK This will distribute resources equally to
46. he from Date and to Date period and the Start and End Time 3 In the Host Name field select the server that is being controlled 4 Click Calculate The information is displayed Graphs Q Top Queries Load Vs Runtime Statistics Query Distribution Query Analysis Runtime Statistics From 09 12 2012 E 09 00 DE Name demo Vv To 09 12 2012 EH 18 00 Calculate Calculate J Set server as well SetTime For All Graphs 100 80 60 40 20 PN NA pwvw j 0 A ab DAM CN aal AM Alas Ad ype ma o 9 00 10 00 11 00 12 00 13 00 15 00 7 00 14 00 peo1 ndo 16 00 1 18 00 2000000000 2000000000 1600000000 1600000000 m lt M 1200000000 1200000000 5 H3 ni 800000000 800000000 400000000 400000000 9 00 10 00 11 00 12 00 13 00 14 00 15 00 16 00 17 00 18 00 In the Graph GUI there are 2 sections CPU Load IO s read amp write Query Distribution The Query Distribution graph shows how the load is distributed over several entities To create the Query Distribution graph 1 In the from and to fields select the required time period 90 PivotalVRP PivotalVRP 6 0 User Manual 2 In the Host Name field select the server that is being controlled 3 From the Calculate According To drop down list select the required option as follows Total Reads Percent e Read Per Sec Percent Total Writes Percent Writes Per Sec Percent e Runtime Percent CPU Per Sec Percent
47. he SQL The Program that runs All can be controlled by normal literal or by Regex 26 PivotalVRP PivotalVRP 6 0 User Manual c Advanced Tab Rule Thresholds Basic General Advanced Rule Activation Overrides Module _ Regex a Litera Action postgres Regex e Liters Client Into _ Regex ej Liens Optimizer Cost Hash Value 562033263 SOL ID 5904 1J2 VJ BExvRxVEIHM J Ivuwmm eons n Liters Use the Advanced Tab to define Module Action Client InfoHash Value SQL ID All can be controlled by normal or by regex d Rule Activation Overrides Rule Thresholds Basic General Advanced Rule Activation Overrides Only activated when total CPU load is above Only activated when total Physical 10 is above 10000 Use both CPU and IO thresholds Allow activation by other rules Rule Priority 25 highest priority 5 Use the Rule Activation Tab to define Rule activation threshold defined by CPU load level in Rule activation threshold defined by Physical IO load level Rule activation threshold defined by both CPU and Physical IO loads Allow activation by other rules Rule Priority The Rule activation overrides are triggered by resource usage at the server level 2 PivotalVRP PivotalVRP 6 0 User Manual Rule Action In Rule Action you can choose what action a specific rule will trigger A rule can trigger a certain level of control of the available resources the execution of scripts noti
48. he table below Setting Functions Opening and closing the application Connect to database Settings definition e General System Settings and login information Repository Settings e User Access Privileges Create and activate rules Create and activate SQL enhancers Create reports and graphs All right click functions Opening and closing the application Connect to database Access to all screens Limited right click functions Activate pre defined rules View only access within the main application e Dashboard e Graphs amp Modules except for Locks view PivotalVRP 6 0 User Manual e Settings only My User Settings amp My EmailGraphs Settings are accessible Description User Name Password Login and passwords the user Servers Minimum manual control Allows to choose what access level is enabled on which database administrator operator viewer Define the level of Operator control allowed for manually managing the resources 3 Define Minimum manual control allows you to define for each user the minimum resource control allowable 4 Click on Save Privileges to save the changes made to the User access control settings 15 PivotalVRP PivotalVRP 6 0 User Manual Note If you forget your Administrator password you may contact the PivotalVRP support center by e mail support OmoreVRP com Following a short verification procedure you will receive a password reset file for the Administrator
49. he table below lists important files that are located in the MoreDB directory on the PivotalVRP server File name RuntimeLog log RuntimeDebugLog log Rules db Settings db MoreDB key Privileges rmf Servers db InstallUtil InstallLog DBDataTable xml AuditLog log Description More Log file More Debug log file if exists Rules file Setting and configuration file More License file Security configuration file encrypted Servers configuration file passwords encrypted Installer log Setting file Log file of all IP amp User names of all Rules and Modules state changes including kill operations 19
50. her mission critical applications PivotalVRP communicates with the database and the operating system and then displays the results on a dashboard Armed with this information you are then able to define specific rules to reduce the resources allocated to exceptionally heavy transactions that could cripple your system while leaving resources available for other transactions PivotalVRP collects various statistics correlates them and then logs them into an internal repository You can then monitor the system defined rules and correct them as necessary When a rule is defined the virtual partitioning of the server resources is carried out immediately It is completely transparent to the database and therefore there are no special configuration modifications required at the database level PivotalVRP provides the following functionality Immediate real time improvement in your IT systems Real time capability to reallocate resources in order to reduce unexpected heavy loads in systems in production Real time and historical monitoring of your databases e Control of resources and management of rollback that avoids both additional unwanted loads as well as any need to kill transactions Improved Performance Availability Stability and QoS throughout the daytime hours Ability to specify computing resources CPU I O for specific transactions Ability to run Bl batches backups and other heavy transactions together in the middle o
51. iltered by e Execution e I O s e Hit Ratio e Optimizer Cost e CPU e Runtime Double Clicking any part of the pie will open a new window representing the Top Queries up to 1000 Start Time Runtime SQL Text gt 2012 12 09 10 07 18 00 00 11 00 select count from dw b 2012 12 09 10 23 27 00 00 13 45 create table dvh zzz dii b 2012 12 09 09 28 57 00 00 09 02 vacuum full dwh dim co b 2012 12 09 09 48 53 00 00 00 24 select a attrelid 0 b 2012 12 09 09 39 54 00 00 00 05 select from pg lock demo 00000005 select from polock b 2012 12 09 10 12 00 demo 00 00 00 02 lock table dwh dim poli b 2012 12 09 09 33 19 demo 00 00 00 21 create table zzz ofir as b 2012 12 09 10 15 50 demo 00 00 00 53 vacuum analyze dwh dii b 2012 12 09 07 09 42 demo 00 00 00 09 select psa procpid ra re Y 2012 12 09 08 55 37 demo 00 00 00 01 select from pg lock 2012 12 09 08 55 3 sdw1 1 40002 00 00 00 01 select from pg lock 2012 12 09 08 55 3 sdw2 1 40000 00 00 00 01 select from pg lock 2012 12 09 08 55 3 sdw8 1 40000 00 00 00 01 select from pg lock 2012 12 09 08 55 3 sdw5 1 40001 00 00 00 01 select from pg lock b 2012 12 09 07 03 47 demo 00 00 00 02 select psa procpid ra re b 2012 12 09 04 15 37 demo 00 00 00 02 select from pg lock b 2012 12 09 07 01 22 demo 00 00 00 01 select psa procpid ra re b 2012 12 09 09 39 04 demo 00 00 00 01 select database l pid 1 b 2012 12 09 07 04 11 demo 00 00 00 02 select psa
52. ime period for the new rule In the Basic TAB Machine Enter the machine that is running the application in the General TAB User Name Enter the user name in the General TAB Program Enter the program running the application in the General TAB Module The module name if the application tags its sessions in the Advanced TAB Action The action name if the application tags its sessions in the Advanced TAB Client Info in the Advanced TAB Hash Value in the Advanced TAB SQL ID in the Advanced TAB Rule Actions Defines the Action created by the rule e Control manages resources Select check box to distribute resources equally among jobs controlled by the same rule Execute script allows the execution of scripts e Send Email send an e mail e Activate rule activates a pre selected rule 41 PivotalVRP PivotalVRP 6 0 User Manual 1 Enter all the required information and click OK The rule is added to the list of rules displayed in the Rules screen Notes All the textual fields are treated with a Contains filter This means that if you type in a partial string only all the strings that contain the inserted string will trigger the rule For example if you enter count in the SQL Text field all queries that contain this text will be managed If some of the fields remain empty PivotalVRP ignores the filter For example if you leave the UserName field empty the
53. imrb imaat 1 2 388 LE 222 pee 2 12 3 1 E4 Lo gee eee Ga 98 33 12 malactrount 192 508 15 227 poyan nz z dir 11 z4 DSi peri eS Do 08 33 13 BHi oani F iti ahi Lb 123 pee x 2412 31 54 DT gpm ie DO 28 33 13 salen mpari 1 3 388 L5 222 pee r1 BUR dhe DST gee in eS DO DE Lo malactrount JALIN LE ID poyan Ez AIr aJ pd 12 8 DEN Hiie Pheri Ha rmgrg Phar Litera Fhar T1 BEID BrE Eas ec Tois mri band Ber econ Toha PFomurha GPU Fer tee Spline Ceol Hi fie Daril Perel Calculata Tal alam Tune Teve Ln LIEU I Hi Tat bigashina uaertagzis 1BL3 LL 14 choi qua ra Ro DE as bul io ae LEI CAR DIS panipi COLT LEIA Gare pee ee DE Dee meee es OL oie HOLNI LGA E2 375 8 gere rrair AEQUE DE por3 13 Pau comem 6070 LET ODEEO10 227 pipa 1BL1 LL 14 chide qua mai BP de wii oO die CT LI piip Z L2 LL D4 Gs peed EUIS ge Cees Bec La elie IDLI L5 14 iror por read rA EO DE por13 13 pe cem 0 LEEZIDEES 40 2272 peer 1DL3 LL 14 shod qua ma eH as built EET de 7 IoD Belgie ZBL2 LL 14 KIF peed ie 2E DOES 1 eee coa lo o LESS ais center Wika stot peer OG fdas Pauw emen LES periph 4BL4 Lr 14 shite quais tds SE wiit Gee iso 7 LEI CAN O10 3I pripra IDLI LEi 14 22 37 b DOII3 1i paw coir 3 LEE LER dO Shpa tM RS drin Acid HOL bent to bubble graph Add SEL bast do radar gap Aud SCIL best 9g KR Ard SOL beet to KP compen E py SQL Dt Crean su nan gi aede Crente sg le from diet Cru role from SOL be
54. iple background processes running and you want to have additional resource bandwidth available you create these rules with thresholds lower than the rules of stability These are usually used during certain periods and activated on processes that run beyond a particular set time 43 PivotalVRP PivotalVRP 6 0 User Manual Important The PivotalVRP resource management and rule engine operate in real time once the triggers aren t valid the VRP ceases Please note When using the rules to trigger alerts keep in mind that every single occurrence will send an email so when sending runtime based alerts select only the master as the db for the trigger 44 PivotalVRP Chapter 5 Working with Graphs Topics Accessing the Graphs e The PivotalVRP Graph Window Top Queries Load vs Runtime Statistics Query Distribution Query Analysis Runtime statistics Right click and double click functions PivotalVRP 6 0 User Manual 45 PivotalVRP PivotalVRP 6 0 User Manual Accessing the Graphs To access the graphs 1 From the Main Menu select Graphs Note The data that is presented in each of the graphs is data that is held in the Repository This data is updated based on the frequency defined in the Data cycling parameter in the Repository Settings screen see Repository Settings 46 PivotalVRP PivotalVRP 6 0 User Manual The PivotalVRP Graph Window The graph section is divided into several tabs Each tab giv
55. licking any selection brings up a few options such as opening a tuning task showing the statistical analysis with details of the selected session or exporting the selected list as a csv Right clicking the graph allows you to export it as a jpeg Username sQLTex Q Filter3 M M Drag Here From 09 12 2012 E 09 00 c To 09 12 2012 E 18 Clientinfo DB Name v JIV Group by host Undo Recalculate Set Time For All Graphs Li Set server as well Order By Runtime Rs Commandtype Controllingrule Hashvalue CPU Time Machine Module OSUser Program Planhashvalue Servicename SQLID Wascontrolled insert into dwh dim ma gp etl engine d 04 01 24 44 insert into dwh dim_key gp etl engine d 03 21 16 01 internal select update dwh di insert into dwh Settings Global Settings About Adobe Flash Player 12 0 0 70 select sum pg relation ofirm 00 15 22 00 00 14 01 28 29 02 40 28 47 13 26 46 02 12 31 24 122 07 33 12 02 15 29 22 03 21 04 03 03 11 32 55 00 12 12 08 00 02 13 57 00 01 01 41 00 02 03 11 00 04 31 11 00 01 22 05 select sum pg relation ofirm 00 00 00 00 01 03 46 40 02 07 33 20 03 11 20 00 Runtime Right clicking any result will present a host of options selecting Query Segmentation will open an new window with the performance metrics related to the results e 20 60 200 220 240
56. min select count from test tz select count from test tab test tab small select count from select count from test tz select count from test tz select count from test tz select count from test tz select count from test tz select count from test tz select count from test tz select count from test tz select count from test tz select count from test tz select count from test tz select count from test tz select count from test tz select count from test tz select count from test tz Login into an account with viewer privileges Dashboard Viewer Mode 0 5 0 0 0 2 0 0 9 3 0 3 0 0 0 2 0 5 13 4 0 3 0 0 0 0 0 5 0 2 0 0 Memory MB 35 33 27 30 141 o Boy O ES O EG our ou O FDI O Fae O PivotalVRP 6 0 User Manual u Recieved MB H Sent MB 12 PivotalVRP PivotalVRP 6 0 User Manual Chapter 2 Managing System Settings Topics User Management e General Settings e Repository Settings My User Settings PivotalVRP User Management Administrators control users access to the application To Manage User Privileges 1 As an Administrator from the Settings menu option select User Management User Management Screen PivotalVRP 6 0 User Manual 14 PivotalVRP User type Administrator Operator Viewer 2 Define the required user privileges as described in t
57. n and select Copy SQL Text The SQL Text s copied to the clipboard and you may paste it to any other SQL editor Creating a tuning task To create a tuning task 1 Right click on the required transaction and select Create tuning task The Create tuning task dialog box Is displayed with opening date automatically defined 2 Fill the Task Creator Developer Name Developer Email and Remarks fields 3 Click the Task Query tab to display the information that is being sent to the developer 4 Clicking OK will have the Tuning Task available for follow up within the Tuning Task add on 4 32 PivotalVRP Tagging SQL Text To tag SQL Text 1 Right click on the required transaction and select Edit SQL Tag The Set a Tag dialog box is displayed Tag Definition SQL Text Select count from dba extents Tag Name Tag DBA Extents ancl 2 Enter a tag for the selected SQL Text and click OK It can be any free text SQL text or DB Table Display session info To display a session info 1 Right click on the required transaction and select Display session info A new window will open with the session info 2 All the important information of the transaction is displayed within the window PivotalVRP 6 0 User Manual 33 PivotalVRP Transaction SID 15884 31811 select count from select char length 4 name as namechar char length E phone as phonechar char length E alue 1
58. n mr TU DammeTpart on mmmR UQ UGE L 07T ponam sade ee Ham loori i i D rpwesr ilzg ride gt Tag ao an pinia i locat p MI i ii reep rideral gt Hasi Lafr Jais omega DB ES reari ede Mash Condo a ftlic gee Fon cid Hash Ledo hia Demesk28 dd 24a eee widths Hamh Come no rmntabhemparw prid Hash Join irawmtELT 04 23 08 corel ride Hama Cond i aid E x irdaxralid 743 Jmn an pq class i oraret DO E 88 Kill Session To kill a session PivotalVRP 6 0 User Manual 34 PivotalVRP PivotalVRP 6 0 User Manual 1 Right click on the required transaction and select Kill Session A confirmation messages is displayed Are you sure Killing a session can be a harmful action Deo wou wish to proceed Yes to kill No to cancel 2 Click yes to continue The selected transaction is stopped Changing User You can change the user type currently defined in the system from the Dashboard To change user 1 In the Dashboard Main GUI click logout The Privileges Login dialog box s displayed Onganizatian MarewkP Liter Marr 2 Select the required user enter the relevant password and click Login The application functionality changes according to the user type now logged in 35 PivotalVRP PivotalVRP 6 0 User Manual Chapter 4 Administering Rules Topics Rules Overview e Managing Modules e Adding a New Module e Removing a Module e Editing a Module
59. net browser To open the PivotalVRP application 1 Launch a web browser and type the PivotalVRP server IP address and port number as follows https lt MoreServerIPAddress gt Port9191 lt MoreVRP HTML page gt In the address field For example https XXX YYY ZZZ XYY 9191 MoreVRP html 2 Enter the company name registered at the time of installation login in as administrator with the default password and click on Login This field enables you to keep track of which PivotalVRP domain you are logged in in environments with multiple PivotalVRP installations Note The default password for the Administrator is Admin2010 It is highly recommended to change all default passwords during the first activation of PivotalVRP PivotalVRP PivotalVRP 6 0 User Manual 3 After Login to PivotalVRP you need to connect to the GP Therefore you need to configure the connection to the GP Select the Settings TAB from the Main Menu The General Settings Screen opens 4 Click on the Add button and the Server Information window opens Enter the following information Connection Name Enter whatever you wish to call the master view Host Name IP x x x x x x x x is the IP of the master node it can be the PUBLIC IP When adding single segments the IP of the segment host Port When using the auto connect the master port default is 5432 When adding single segments the port of the segment Username Password As define
60. nnection use the port As defined according to the installation manual As defined according to the installation manual Selector for full environment connection vs single segment Verifies the connection settings and communication with the segment s By default this is checked attempts re connection to segments if connection is lost By default this is unchecked gives you manual control of re connection attempts Data polling interval from the database memory Statistics polling interval from the OS Timeout settings in seconds IO per second threshold setting User definable from 2 weeks to 12 month it is recommended to go up to 6 month 11 PivotalVRP nod8 40007 nodi4 4000t nod13 4000 nod26 4000 nod21 4000 mdw 40002 mdw 40002 nod16 4000 nod13 4000t nod25 4000 mdw 40007 mdw 40007 B Free cB E used cB nod7 40007 2 In Viewer Mode the Rules are not applicable In settings only the My User Settings ls accessible nodi9 4000 nod21 4000 nod15 4000 nod17 4000 Return to the Privileges screen and click Logout as defined in the User Privileges settings see User Management postgres postgres postgres postgres postgres postgres postgres postgres postgres postgres postgres postgres postgres postgres postgres postgres postgres gpadmin gpadmin gpadmin gpadmin gpadmin gpadmin gpadmin gpadmin gpadmin gpadmin gpadmin gpadmin gpadmin gpadmin gpadmin gpadmin gpad
61. nt Display supa pian Sel Tire For Bl rapi Expert to CS Ghakal settings Aiel doe Flash Aap 115312 l Dhj Pas Seer O Esas Pa 3 a au aa 2 1 d a 2 d a 3 2 a 24 a a a 3 3 a4 1 8 qa a a8 ee ud a n Lad Ri TEL ug e FE au Test Eaves Fes AM Geapha fi Tebal Ftrpmcm Fas Weba Par Co 8 SE 2a fe amp 2 G 53 PivotalVRP PivotalVRP 6 0 User Manual Blade blues Pinetree CT Lrinral Fitters imar METH Program Crereri amp rd Toa hl HaT Chant res La aa dos miih Abo TE uma Fhad itu Palli ks Hagkoalom Bg IL E alo leia Lai ula ia Char AN Sat Erra Por AI Geaphe Sibert Tire Hest usher TOW Part Behera Lipe ara CE Puer rar Boeeral aad Fa Tebel Ppp Va Beka Por Tite JETE n Jis behest cami T Ted rostpnad Z Qd 31 14 diaria gfe Lrs E EBD i Bai a wabwil im 7 i Z ILBE ODZI I Bool ye E4 1 S gar manu po 03 33 13 palact crant FOLI LIIE peepee 3 aE n a Sr ie e oe a DO Oe id paket cat T SELL pipra 112 31 24 odiar ites genre E E OS a dd dd Gabi ice ll ger nd d d JD ere o peri ie O 2 33 13 Baber rrap WIOIBE J 27 peers Jiz ji i dois grement DO is Hiwi auni T SRLS perairan Ls E qa rig dr LESS DU Gr o ado dos BEHI Cissa CO JPZ LW DS Ell ger etn di dela 13 NT DR Jr rrumim rd TZ A DO Gana Baibeart rras T OSS Empada peers 1 3 z0 i1z 2 E4 E Aie oe agro main pd D DIF iz Hiki amami DOZE loca rcgtpnad hk 1L gd D 2112 31 54 WT jpa EO Qmm Babai iaa ZU D OLB
62. op right hand side of the window Playback The Playback is a virtual time machine At PivotalVRP we know that situations don t happen out of the blue The chain of events leading to a situation will usually point to the reason to the situation With the unique Playback module you control time Just set the time you want to investigate press play and live things as they happened 00 00 00 Control time 68 PivotalVRP PivotalVRP 6 0 User Manual SQL Text select count i 159956 5 select count fr 159956 select count fr 159956 select count fr 159956 select count fr 159956 select count fn 159956 select count fr 159956 select count fn 159956 select count A 159956 select count fn 159956 select count fn 159956 select count fn 159956 select count fr 159956 u D select count fn 159956 0 select count fn In case you want to get more info or start the investigation here you have the ability to use right click actions Performance BI The Performance BI module lets you dynamically create a drill down path based on your specific needs Filter List SQLText O Action O Filter 3 M M Drag Here Controllingrule From 03 01 2013 14 00 DB Name Group by host Undo Recalculate Set Time For All Graphs Set server as well Hashvalue s 4 00 E i mU Li dachte To 03 01 2013 Ed 18 00 H Order By Runtime iy Redo Clear Selections
63. own menu Right clicking the lock will allow you to export the information As an administrator and operator you have the option to release them through a right click option IMPORTANT Releasing the lock will KILL the locking session DB Name mdw 5432 v Relation ID Host Name Process ID SQLText Database ID User Name Client Add Applicatio Status Resource Queue Management Lock Mode Transactio Lock Type 26433 update test tab 10900 gpadmin 10 76 72 36 pgAdmin III Q LOCKING Release Lock Export Table Settings Global Settings About Adobe Flash Player 11 7 700 224 relation ExclusiveLock 558252 64 PivotalVRP PivotalVRP 6 0 User Manual The second tab is the DCR report window which enables you to create customized DCR reporis The DCR Detailed Custom Report provides a wide variety of information regarding the state of the GP environment Information such as free space per segment size of databases resource queues and more is available through this report In order to generate the report select the master segment from the pull down menu and select the information you wish to display pressing generate report will start the process When the report is ready the status log icon will flash red Once generated you can always revisit existing DCR reports by retrieving them from the existing reports list DCR Report Resource Queue Management DB Name vm27 5432 v Ple
64. redemo gpadmin count from select 63 496 10 110 127 86 moredemo gpadmin count from select 51 096 10 110 127 86 moredemo gpadmin count from select 36 196 10 110 127 86 moredemo gpadmin count from select 25 2 10 110 127 8 moredemo gpadmin count from select lt 0 0 gt demo moredemo gpadmin Select count from sek 101 2 PivotalVRP 6 0 User Manual B Free cB E used cB The table below describes each element displayed in the Dashboard Acceleration Chart Health QoS Indicator Sessions Log Database Data CPU Utilization Chart I O Operations Chart Memory Networking Server Selection Displays the relationship between transactions that are running and those that are managed Calculates the Quality of Service provided by the database server to reflect the user experience in terms of transaction response time Displays a list of transactions currently running on the database server with live information In high level view clicking the little triangle on the left of the session will open up the session tree with all the slices info Double clicking on a session drills down to show more information about the specific session right clicking displays additional options Graphically displays the current percentage of CPU of the currently selected server Graphically displays the current usage of read write I O operations of the currently selected server
65. rformance Runtime Performance I O Performance What s New Env amp 1 sgamesi v Env 2 sgamesi Zu SQL Sensitivity From 07 05 2012 ad From 06 05 2012 ud Filter SQL Text v To 07 05 2012 adi To 06 05 2012 N By Calculate Calculate Set server as well Set Time For All Graphs Env 1 Vs Env 2 CPU Difference Env 1 Vs Env 2 CPU 22000 20000 18000 Deteriorated CPU Time 16000 13084 Total CPU Time 13084 14000 12009 Export graph to image 10000 Settings 8000 Env 1 Vs Env 2 Quantity Global Settings 6000 About Adobe Flash Player 11 5 31 5 21737 Total CPU Time 13084 Total CPU Time E Improved CPU Time E Deteriorated CPU Time What s New displays sessions that were running in one environment and not the other Having the ability to dig into comparative performance data and information will often provide the insight into performance degradation causes When running multiple variance models on a single baseline can also help forecast future loads and environment behavior 63 PivotalVRP Statistics Comparison Skew Analysis CPU Performance PivotalVRP 6 0 User Manual Runtime Performance I O Performance What s New 4 Env amp 1 sgamesi Env 2 sgamesi v E 09 00 lt Filter SQL Text v Li Set server as well Set Time For All Graphs update users2 set realba 1 update userdetails2 set 1 update servers set numc upd
66. rom dba extents dba OMS begin emd notification queue ready 1 The Variance Add on is the DBA s ultimate tool Given the vast amount of information available within the PivotalVRP repository the variance Add on is an amazing analytic tool It can help you prepare your database upgrades by comparing processes running in two different environments In depth graphs show you where you have performance improvements and where the performance deteriorated By pinpointing these transactions you can quickly decide if your database is ready for the upgrade or if you still need to prepare it before you go online with it It s simple graphs and in depth analytic ability allow you to quickly determine in a performance degradation situation what has changed The tab what s new gives you immediate access to the changes that happened within comparative time frames that have different performances The Skew Analysis provides performance information relating to skewing within your segments Statistics comparison will display the CPU amp IO resource consumption differences Runtime Performance I O Performance ual Env 1 From 07 05 2012 E 09 00 To 07 05 2012 EH 18 00 From 06 05 2012 E To 06 05 2012 E Env 2 sgamesi 09 00 18 00 E Cei cante V Set server as well Set Time For All Graphs m Env amp 1 m Env 2 ta

PivotalVRP 6.0 User Guide, A01

Contents

Download Pdf Manuals

Related Search

Related Contents