| Title: | WinNT-Clusters |
| Notice: | Info directories moved to DECWET::SHARE1$:[NT_CLSTR] |
| Moderator: | DECWET::CAPPELLOF |
| Created: | Thu Oct 19 1995 |
| Last Modified: | Fri Jun 06 1997 |
| Last Successful Update: | Fri Jun 06 1997 |
| Number of topics: | 863 |
| Total number of notes: | 3478 |
Can anyone help.
I have a customer who is running sql server on an Intel cluster of dual
Prioris ZX 166's.
Everything with the cluster appears to be OK but Sql queries take a
very long time.
Versions:SQL 6.5,NT clusters 1.0 with service pack 1, NT V3.51 with
service pack 5, clusters are enabled and the failover works OK.
The customer has tested this with a two column table inserting 20
rows in a two column table taking up to 7 seconds.
They run an application on the client called Powerbuilder and the
commands they use are Insert then Go. I dont know SQL but it appears
that the insert/go sequence causes the problem.
As this is all second hand, can anyone help, I am sure something is
wrong but dont know what.
Help,help,help
tks
Vince
| T.R | Title | User | Personal Name | Date | Lines |
|---|---|---|---|---|---|
| 624.1 | CSC32::HOEPNER | A closed mouth gathers no feet | Mon Feb 17 1997 15:03 | 11 | |
Does this application run 'slowly' without the cluster?
What in Performance Monitor have you looked at?
Have you done any traces to see what optimizer strategy is being
used?
Have you used SQL TRACE to see what sql statements are being sent
by Powerbuilder?
| |||||
| 624.2 | Connection establishment is slow | DECWET::CAPPELLOF | My other brain is a polymer | Tue Feb 18 1997 11:16 | 8 |
I suspect that the slow performance is caused when the client makes the
initial connection to the SQL server. The Cluster client software adds
an extra delay when named pipe connections are made. After the
connection is established, there should be no performance impact.
If your client disconnects and reconnects for each query, it could be
pretty slow. Version 1.1 of NT Clusters improves this performance
somewhat. This version will be released soon.
| |||||
| 624.3 | Now Runs Well | CHEFS::vfr750.reo.dec.com::harrisonb | Thu Feb 20 1997 10:37 | 6 | |
The resolution to this problem was to install a new redirector on the client It now flies along. Brynn Harrison (First Hand) | |||||