Environment
NetIQ AppManager Repository
NetIQ AppManager 6..x
NetIQ AppManager 7.0.x
Situation
Resolution
Following are simple statements that can be used to gather important configuration information from a SQL Server. This information can be useful when trying to determine if the SQL server configuration is suitable for the AppManager Repository database. Open any SQL Query Tool and select the QDB database. Run the following commands to obtain specific information. To get the SQL Server's version, language configuration, catalog version, etc.:
sp_server_info
To get the SQL Server's memory and performance tuning information:
sp_configure
To get the current space used for a database:
sp_spaceused @updateusage = true
To get the default Sort Order and Character Set for the SQL Server:
sp_helpsort
To get details on a given database or device:
sp_helpdb
sp_helpdevice
To display information for a given login_id or all users and processes:
sp_who2