Tariscope 4.x. Administrator's guide
Chapter 4. Tariscope Maintenance
4.1. Control over work of the Tariscope applications
4.1.1. Control over the Tariscope database
The Tariscope database and Tariscope server are the core of the Tariscope system. The Tariscope Management program and the same mode of the Tariscope program allows to monitor a status of the Tariscope database, a list of users and applications which interact with the system.
For this monitoring, in the mentioned above programs, select the Database info branch of the configuration tree. The window of the Tariscope program will be as shown in Figure 4.1.1.1.
Figure 4.1.1.1
The right part of the program window is divided on the two parts:
- the upper part shows the current state of the Tariscope database,
- the lower part shows the Tariscope users who are currently connected to the Tariscope database, and the applications that they use.
The current state of the database contains the following information:
- SQL Server. Displays a SQL Server name where the Tariscope database is located.
- Name. Displays the Tariscope database name.
- Size. Displays the size of the database in megabytes. The administrator should periodically monitor this size. A version of SQL Server 2008 R2, which the Tariscope installation includes, has restrictions on the database size: 10 GB. If the current database size is approaching this boundary, you should do one of the following actions: to archive the call database, or purchase and install a version of Microsoft SQL Server, which has no restrictions on the size of the database.
- Owner. Displays a name of the computer on which the SQL Server is located and your user name used to log into Windows.
- ID. Displays a database identifier.
- Create date. Displays the creation date of the database.
- Status. Displays the current status of the database.
- Compatibility. Displays the code that corresponds to the database compatibility with SQL Server.
- Name1. Displays the file name containing the Tariscope database.
- File path1. The path to the Tariscope.mdf file.
- Size1. Displays the size of the file containing the Tariscope database.
- Name2. Displays the file name containing the transaction to SQL Server: Tariscope_log.
- File path2. Displays the path to the Tariscope_log.ldf file.
- Size2. Displays size of the Tariscope_log.ldf file.
Information about users working with Tariscope is displayed in tabular form with the following columns:
- Process ID. Displays a process identifier.
- User. Displays a name of user who is currently working with the Tariscope database.
- Database. Displays the database name with which the user is working.
- Status. Displays a current status of the process interacting with the database.
- Transactions. Displays the number of executed transactions to the database.
- Command. Displays a command that is being executed.
- Application. Displays a name of the Tariscope application that is used by user.
- Wait time. Displays a wait time of unlocking the process. If the wait time is equal 0, the process is not locked.
- CPU. Displays the total processor time for the process.
- IO. Displays the total number of requests to read and write data.
- Memory. Displays number of pages in the procedure cache that are currently taken for the process. A negative number means that the process is being released from memory, which is allocated to another process.
- Login time. Displays the date and time when the process was connected to the database.
- Last batch. Displays the date and time of the last executed query to the database.
- Host. Displays a name of computer from which the connection to the database was performed.
- Net Library. Displays the protocol used by the client to connect to the database.
- MAC address. Displays MAC address of the computer from which the connection to the database was performed.
The information of the Database info mode is updated periodically. To update information at any desired time, click the Refresh icon on the toolbar or press "F5" on your keyboard.
