Hitachi

JP1 Version 12 JP1/Performance Management - Agent Option for Microsoft(R) SQL Server


I.1 Procedure for deleting A4QHITACHIPROCSPDATABASES

You can delete the A4QHITACHIPROCSPDATABASES stored procedure by using the sp_drop.sql script provided by PFM - Agent for Microsoft SQL Server.

To delete A4QHITACHIPROCSPDATABASES:

  1. Set up an environment in which the sqlcmd utility of Microsoft SQL Server can be executed.

    The sqlcmd utility is provided by Microsoft. For details about the environment settings for Microsoft SQL Server, see your Microsoft SQL Server documentation.

  2. Move to the folder in which the sp_drop.sql script is located.

    The script is located in the following folder:

    installation-folder\agtq\agent\sql
  3. Execute the script with the monitored Microsoft SQL Server instance specified.

    The command line for executing the sp_drop.sql script depends on the type of the monitored Microsoft SQL Server instance and the method of authentication used for connecting to Microsoft SQL Server. The following shows the command line for each condition.

    • When the default instance of Microsoft SQL Server is being monitored

      Authentication

      Command line for executing the sp_drop.sql script

      SQL Server

      sqlcmd -S host-name -U user-name -P password -d master -i sp_drop.sql #

      Windows

      sqlcmd -S host-name -E -d master -i sp_drop.sql #

    • When a named instance of Microsoft SQL Server is being monitored

      Authentication

      Command line for executing the sp_drop.sql script

      SQL Server

      sqlcmd -S host-name\instance-name -U user-name -P password -d master -i sp_drop.sql #

      Windows

      sqlcmd -S host-name\instance-name -E -d master -i sp_drop.sql #

      #

      The following describes the items that the user specifies:

      host-name: Name of the host on which the monitored Microsoft SQL Server instance operates

      instance-name: Name of the monitored Microsoft SQL Server instance

      user-name: sa or a user account having the permissions equivalent to sa (account of a member of the sysadmin fixed server role)

      password: Password for the specified user name