Sybase's experience on installing the MDA table

During this period, we studied the Sybase MDA monitoring table. During installation, the system always prompts that the loopback service connection is incorrect! Later I found that the loopback service was not provided in the dsedit tool.

After creating the loopback interface, you must execute the statement in iSQL.

First, set the CIS parameter to 1, indicating

Sp_configure ' Enable CIS ' , 1
Go

Once again, add a loopback service to the servers, and add the corresponding loopback interface while monitoring access to the dsedit tool.

Use Master
Go
Sp_addserver loopback, Null , @ Servername
Go

This sentence is very important because the loopback service can be accessed.

Set Cis_rpc_handling On
Go

You can use the following method to test

Exec Loopback... Sp_who
Go

 

The following is the installation. This step is very important:

ISQL-U sa-P yourpassword-s yourserver
-I $ Sybase/$ sybase_ase/scripts/installmontables
Check the screen output. If there is an error, try to eliminate it.
Now, you have to grant sa the mon_role permission.

Use Master
Go
Grant Role mon_role To SA
Go

Use the following statement to test whether the authorization is successful.

Select   *   From Master... monstate
Go

If the returned result is normal, you can continue the following operations.

 

Sp_configure ' Enable monitoring ' , 1
Go
Sp_configure ' SQL text pipe active ' , 1
Go
Sp_configure ' SQL text pipe Max messages ' , 100
Go
Sp_configure ' Plan text pipe active ' , 1
Go
Sp_configure ' Plan text pipe Max messages ' , 100
Go
Sp_configure ' Statement pipe active ' , 1
Go
Sp_configure ' Statement pipe Max messages ' , 100
Go
Sp_configure ' Errorlog pipe active ' , 1
Go
Sp_configure ' Errorlog pipe Max messages ' , 100
Go
Sp_configure ' Deadlock pipe active ' , 1
Go
Sp_configure ' Deadlock pipe Max messages ' , 100
Go
Sp_configure ' Wait event timing ' , 1
Go
Sp_configure ' Process wait events ' , 1
Go
Sp_configure ' Object lockwait timing ' , 1
Go
Sp_configure ' SQL batch capture ' , 1
Go
Sp_configure ' Statement statistics active ' , 1
Go
Sp_configure ' Per object statistics active ' , 1
Go

Then, you need to modify a static parameter.

 

Sp_configure" Max SQL Text Monitored ", 5120
Go

Now, you need to restart the sybase database server, and then you can use the MDA table to monitor the system performance of the Sybase Database.

2. to modify the master system table, you must add the-M parameter to sqlsrvr startup as a single user!