Shulou(Shulou.com)06/01 Report--

Sybase does not install mda tables by default, and you need to create them using the installmontables script in the $SYBASE/ASE-12_5/scripts directory (SYBASE%\ ASE-12_5\ scripts for NT)

The file space of the PS:master database must be large enough, otherwise insufficient space will be reported when creating the table.

1. Create a server named "loopback"

Sp_addserver loopback, null, @ @ servername

Go

two。 Add an access interface for "loopback", open Dsedit, and add a service interface for "loopback" (this is why the MDA table cannot be created)

3. If you want to use the mda table, you must have mon_role permission

Grant role mon_role to your login user name

Go

4. Configure the enable monitoring parameter to use the mda table

Sp_configure "enable monitoring", 1

Go

View the mda table using parameters that can be adjusted

Sp_configure Monitoring

Go

4. Installation script

The installmon script in the $SYBASE/ASE-12_5/scripts directory. You need to copy the contents of the script to the isql interface, and then execute it.

5. Install the MDA table

The installmontables script in the $SYBASE/ASE-12_5/scripts directory. You need to copy the contents of the script to the isql interface, and then execute it.

6. Configure relevant parameters (save 300 records at a time, which can be adjusted by yourself)

Sp_configure 'max SQL text monitored',300

Go

Sp_configure 'SQL batch capture',1

Go

Sp_configure 'sql text pipe max messages',300

Go

Sp_configure 'sql text pipe active',1

Shutdown

Go

Net start "Sybase SQLServer _ XXX"

Simple description of the mda table

MonTables

Provide a description of all monitoring tables

MonTableParameters

Provides a description of all optional parameters for each monitor table.

MonTableColumns

Describe all columns of each monitor table

MonState

Provides information about the overall status of Adaptive Server

MonEngine

Provides statistics about the Adaptive Server engine

MonDataCache

Returns statistics related to the Adaptive Server data cache.

MonProcedureCache

Returns statistics related to the Adaptive Server procedure cache.

MonOpenDatabases

Provide status information and statistics related to the database currently in use

MonSysWorkerThread

Returns server-wide statistics related to worker threads.

MonNetworkIO

Returns the network Icano statistics.

MonErrorLog

Returns the latest error message from the Adaptive Server error log.

MonLocks

Returns a list of all locks held by any process and requested for each object.

MonDeadLock

Provides information about the latest deadlocks that have emerged in Adaptive Server.

MonWaitClassInfo

Provide text description for all waiting classes

MonWaitEventInfo

Provides a textual description of every possible scenario that forces the process to wait within the Adaptive Server.

MonCachedObject

Returns statistics for all objects and indexes that currently have pages in the cache.

MonCachePool

Provides statistics for all pools allocated to all caches.

MonOpenObjectActivity

Provides statistics for all open objects.

MonIOQueue

Provides device Icano statistics, broken down into data and logs from regular and tempdb databases on each device

MonDeviceIO

Returns statistics related to the device.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.