IBM Support

Multi-CPU multi core SQL 2000 server Parallelism setting causes slow performance and errors

Troubleshooting


Problem

Customer upgrades to new high-specification SQL server. End users experience slower performance, and may have intermittent issues and perhaps system crashes.

Symptom

In other words, users are experiencing poor performance and error messages, with a high-specification SQL 2000 server.

There may be various different error messages, but in particular there will be events recorded inside the 'application log' of the Application and SQL server, referring to deadlocks.

[{"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Controller","Platform":[{"code":"PF033","label":"Windows"}],"Version":"8.3","Edition":"Not Applicable","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SSMRTZ","label":"IBM Cognos Controller on Cloud"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Historical Number

1038843

Document Information

More support for:
IBM Cognos Controller

Software version:
8.3

Operating system(s):
Windows

Document number:
123505

Modified date:
08 May 2025

UID

swg21371449

Manage My Notification Subscriptions