H3C Technologies H3C Intelligent Management Center - Manual (Page 96)

87
When I add a view with the same name as that of an existing view but
different in letter case, why does the system displays that the view
already exists?
This is because the SQL server database is case insensitive. Suppose a
view named router already exists. If you try to add a view with the view
name being ROUTER, the system considers it as the one named router
and display that the view already exists. You must be aware of this when
working with a case-insensitive field to prevent operation failure.
When IMC runs for a period of time using the SQL Server database,
the Memory utilization becomes extremely high and cannot recover.
What shall I do?
You can solve the problem by changing the maximum buffer size for the
SQL server. Do the following:
1. Execute the setsqlservermaxmem.bat -server server -saPwd password
–maxMem maxmem command in the \client\bin\ directory of the IMC
installation path.
Parameter description:
{
-server server: Name or IP address of the SQL Server database
server. This parameter is optional. The default setting is localhost.
{
-saPwd password: Password of the sa user. This parameter is
required.
{
-maxMem maxmem: Maximum buffer size to change, in MB. This
parameter is optional. By default, the current buffer size is displayed.
2. Restart the SQL Server database to validate the configuration.
For example, suppose that IMC is deployed in centralized mode and uses
a remote SQL Server database at 192.168.100.199. The password of sa
user of the databaseis IMC123. To set the buffer size of the database to
1024 MB, execute the following command in the \client\bin directory of
the IMC installation path: