I have a Siebel CRM with Sql Server back-end database (Sql server 2008 R2 but the database has compatibility Level 80 (Windows 2000)). Each Siebel client is Windows XP with a front-end installation. The client pc has access to the back-end database through ODBC (Sql Server 2000).
All of the clients suddenly slow down a specific query that has to do with call recognition. When the phone rings the number of the caller is used to make a query in the database to find the contact's informations. The query is issued not server centric but from each client separately.
The strange thing is that only one machine does not show this delay. So I decided to take a trace from the only one machine and from one of the other machines that have the problem. I attached them.
I wondered if the cause was the ODBC driver because it seems to be a local problem and has to do with the way the client issues the query (since there is even one pc that works ok) and change it to native client 10 but nothing. The next step is to reinstall the clients.