All Forums Database
chunxiaohan 1 post Joined 03/10
18 Mar 2010
How to setup and run Higa macros


I'm trying to use Higa macros to find performance bottleneck on a TD12 database, I followed the guide in Support Knowledge Base :

How to install/run Larry Higa's extended resusage Macros

When I tried to run resmacros_TD12.1.4.sql on a testing TD12 database, I met following error messages:

Object "ResCPUByVprocView" does not exist

I have turned on RSS flags in CTL, is there any steps I missed during the setup process, thanks.

Jim Myrna 4 posts Joined 05/09
24 Mar 2010

The resmacros_TD12.1.4.sql script contains a REPLACE VIEW for the ResCPUByVprocView view, so it should be getting created in the script (and then later referenced by some macros in the same script). Check the log from when you ran the script and verify that the view is being created and in the database that you are expecting it to be.

AbeK 24 posts Joined 08/09
26 Aug 2010

Do you know if the charting tool that is available in this pacakge is compatible with Excel 2007, if it is not, is there a place to get this tool for use with Excel 2007

Ekladios 13 posts Joined 02/12
15 Feb 2012

Where are Larry Higa macros?

Adeel Chaudhry 773 posts Joined 04/08
05 Feb 2014

You can find them at T@Ys, you need customer master number for login creation.

-- If you are stuck at something .... consider it an opportunity to think anew.

You must sign in to leave a comment.