Timeout error with high speed connection

[Alex]

Hello ,everybody
Please help with our case

1. Client complain ...aplication to slow
They configuration
10 NT connected to 1 SQL server
network speed 10 10 mgb.sec

2. We change network speed to 100 mgb.sec
Our application produce timeout error
3. We connected computer to SQL server using cable
Our application produce timeout error

4. We run aplication on same station with SQL server
The is no error

Query giving error normally runs 1300 -1500 mms with Analyzer
What should we check beside our application


Thanks

Hello

Check every query and indexes using the analyser
When your query is not optimized with indexes, SQL scans the whole table, locks can occur with other users, then your application will have timeouts.

Good luck

------------
Alex at 5/1/01 6:26:33 PM

Hello ,everybody
Please help with our case

1. Client complain ...aplication to slow
They configuration
10 NT connected to 1 SQL server
network speed 10 10 mgb.sec

2. We change network speed to 100 mgb.sec
Our application produce timeout error
3. We connected computer to SQL server using cable
Our application produce timeout error

4. We run aplication on same station with SQL server
The is no error

Query giving error normally runs 1300 -1500 mms with Analyzer
What should we check beside our application


Thanks

[Alex]

we tried 4. run aplication on same station with SQL server 1
the is no locking ...
indexes created
1 user only connected
thanks


------------
at 5/2/01 8:26:09 AM

Hello

Check every query and indexes using the analyser
When your query is not optimized with indexes, SQL scans the whole table, locks can occur with other users, then your application will have timeouts.

Good luck

------------
Alex at 5/1/01 6:26:33 PM

Hello ,everybody
Please help with our case

1. Client complain ...aplication to slow
They configuration
10 NT connected to 1 SQL server
network speed 10 10 mgb.sec

2. We change network speed to 100 mgb.sec
Our application produce timeout error
3. We connected computer to SQL server using cable
Our application produce timeout error

4. We run aplication on same station with SQL server
The is no error

Query giving error normally runs 1300 -1500 mms with Analyzer
What should we check beside our application


Thanks

[Ali Mostofi]

Hi

I have a same problem, please let me know about result.

Thanks
Ali Mostofi

------------
Alex at 5/2/01 6:01:10 PM

we tried 4. run aplication on same station with SQL server 1
the is no locking ...
indexes created
1 user only connected
thanks


------------
at 5/2/01 8:26:09 AM

Hello

Check every query and indexes using the analyser
When your query is not optimized with indexes, SQL scans the whole table, locks can occur with other users, then your application will have timeouts.

Good luck

------------
Alex at 5/1/01 6:26:33 PM

Hello ,everybody
Please help with our case

1. Client complain ...aplication to slow
They configuration
10 NT connected to 1 SQL server
network speed 10 10 mgb.sec

2. We change network speed to 100 mgb.sec
Our application produce timeout error
3. We connected computer to SQL server using cable
Our application produce timeout error

4. We run aplication on same station with SQL server
The is no error

Query giving error normally runs 1300 -1500 mms with Analyzer
What should we check beside our application


Thanks

[Ananth]

At what point does the timeout occur? Is the application able to connect to SQL at all? Is it one specific query or all queries?


------------
Ali Mostofi at 5/3/01 10:09:18 AM

Hi

I have a same problem, please let me know about result.

Thanks
Ali Mostofi

------------
Alex at 5/2/01 6:01:10 PM

we tried 4. run aplication on same station with SQL server 1
the is no locking ...
indexes created
1 user only connected
thanks


------------
at 5/2/01 8:26:09 AM

Hello

Check every query and indexes using the analyser
When your query is not optimized with indexes, SQL scans the whole table, locks can occur with other users, then your application will have timeouts.

Good luck

------------
Alex at 5/1/01 6:26:33 PM

Hello ,everybody
Please help with our case

1. Client complain ...aplication to slow
They configuration
10 NT connected to 1 SQL server
network speed 10 10 mgb.sec

2. We change network speed to 100 mgb.sec
Our application produce timeout error
3. We connected computer to SQL server using cable
Our application produce timeout error

4. We run aplication on same station with SQL server
The is no error

Query giving error normally runs 1300 -1500 mms with Analyzer
What should we check beside our application


Thanks