Question/Issue:
Troubleshooting IM Manager sometimes requires logging database activity. The SQL Server Profiler tool that is included with SQL server installations can perform this logging. In addition, ODBC connections can also be logged to assist in troubleshooting and IM Manager database.


Solution:
Depending on the type of trace that needs to be done, follow the steps provided.

SQL Server 2000 Using SQL Profiler

Use these steps to run a SQL 2000 Profiler trace to capture information about the IM Manager database.

SQL Server 2000 Trace Template: TraceTemplate.tdf


To capture a trace:

1. Download and copy the template to a machine that has the SQL Profiler installed.
2. Open SQL Profiler application.
3. Click on New Trace, and connect to the SQL Server that hosts the IM Manager database.
4. In the Trace Template field, click on the folder button.
5. Browse to the Trace Template you previously downloaded.
6. Click OK.
7. Click Run.
8. When you have collected enough data, click the red Stop button to finish collecting data.
9. In the Menu, click Save to save the SQL data as a .trc file.

Use these steps to run a SQL 2005 Profiler trace to capture information about the IM Manager database.

SQL Server 2005 Trace Template: IMManagerSQL2005TraceTemplate.tdf


To capture a trace:

1. Download and copy the template to a machine that has the SQL Server Profiler installed.
2. Open SQL Profiler application.
3. Click on File > Templates > Import Trace..., and select the downloaded trace file.
4. Click on File > New Trace, and connect to the SQL Server that hosts the IM Manager database.
5. In the Use the Template drop-down list, select IMManagerSQL2005TraceTemplate.
6. Click on the Events Selection Tab, click on the Column Filters button.
7. Click on the DatabaseName filter option, update the "Like" field to reflect the name of your IM Manager database (default is IMManagerDB).
8. Press OK.
9. Press Run.
10. When you have collected enough data, click the red Stop button to finish collecting data.
11. In the Menu, click Save to save the SQL data as a .trc file.

Use these steps to run an ODBC trace to capture information about the IM Manager database.

To capture a trace:

1. Log into the server as the IM Manager service account
2. Stop the appropriate IM Manager service to be traced.
3. Start the ODBC administration console. by clicking Start > All Programs > Adminstrative Tools > Data Sources (ODBC).
4. Click the Tracing tab.
5. Change the value of the Log File Path as appropriate.
6. Click the Start Tracing Now button.
7. Start the appropriate IM Manager service to be traced.
8. When you have collected enough data, click Stop Tracing Now to stop the ODBC tracing.

Use these steps to capture SQL deadlocks occuring in the IM Manager database. The errors are logged to the SQL server error log.

1. Run the following SQL against the IM Manager database:

DBCC TRACEON(1204, 1222)

go

DBCC TRACEON(1205, -1)

go

DBCC TRACEON(3605, -1)

2. When the problem occurs collect the SQL Server error logs.

Document ID: 2007251188516698
Last Modified: 11/06/2008
Date Created: 06/13/2007
Product(s): IM Manager
Release(s): IM Manager 2007 8.3, IM Manager 7.5, IM Manager 8, IM Manager 8.1, IM Manager 8.2, IM Manager 8.4