We our using maximizer enterprise 7.5 with pervasive server 2000(sp4) under Nt 4.0.
But the client performance is very very slow what may be the reason
Original Post
Replies sorted oldest to newest
Is this machine NT4 Server or Workstation?
NT4 Server maybe having difficulties, NT4 Workstation will definatly have problems.
A workstation OS is not a very good idea for a database server if you have more than say 5+ clients trying to access it.
How much memory does the machine have?
What is the performance of the Processor?
How much space is there on the Disk Drive containing the data?
What else is it running?
Have you tried the Task Manager to see what other processes maybe swallowing processor and memory time?
Regards
CABC Support
NT4 Server maybe having difficulties, NT4 Workstation will definatly have problems.
A workstation OS is not a very good idea for a database server if you have more than say 5+ clients trying to access it.
How much memory does the machine have?
What is the performance of the Processor?
How much space is there on the Disk Drive containing the data?
What else is it running?
Have you tried the Task Manager to see what other processes maybe swallowing processor and memory time?
Regards
CABC Support
THE PERVASIVE SERVER IN AT NT 4.0 SERVER. The server DELL Power edge 4600 with 2MB RAM, Xeon Processor, 108 GB HDD.
The 4% CPU time is used by total load in the Server.
The drive has 20 GB Free space.
The 4% CPU time is used by total load in the Server.
The drive has 20 GB Free space.
Can you try a couple of tests on a client.
Go to Start>Run and type 'Command' or 'CMD' then OK
try typing;
PING [server_name] enter
next
PING -A [server_IP_address] enter
then
TRACERT [server_name] enter
substitute [server_name] and [server_IP_address] with the name or IP address of this server on the LAN
If you don't know these details, go to the server and type 'CMD' in Start>Run and then type in the DOS prompt
IPCONFIG /ALL and then Enter
you will see something similar to;
Windows IP Configuration
Host Name . . . . . . . . . . . . : MACHINE1 {*}
Primary Dns Suffix . . . . . . . : cabc.co.uk
Node Type . . . . . . . . . . . . : Hybrid
IP Routing Enabled. . . . . . . . : No
WINS Proxy Enabled. . . . . . . . : No
DNS Suffix Search List. . . . . . : cabc.co.uk
Ethernet adapter Local Area Connection:
Connection-specific DNS Suffix . :
Description . . . . . . . . . . . : CNet PRO200WL PCI Fast Ethernet Adapter
Physical Address. . . . . . . . . : xx-xx-xx-xx-xx-xx
Dhcp Enabled. . . . . . . . . . . : Yes
Autoconfiguration Enabled . . . . : Yes
IP Address. . . . . . . . . . . . : 167.160.0.12 {*}
Subnet Mask . . . . . . . . . . . : 255.255.255.0
Default Gateway . . . . . . . . . : 167.160.0.1
DHCP Server . . . . . . . . . . . : 167.160.0.2
DNS Servers . . . . . . . . . . . : 167.160.0.2
Primary WINS Server . . . . . . . : 167.160.0.2
Lease Obtained. . . . . . . . . . : 22 January 2003 09:14:06
Lease Expires . . . . . . . . . . : 25 January 2003 09:14:06
The {*} marks are the Machine name and IP Address
Firstly what do the tests on the client show?
and secondly do the IP Address and Machine name of the server on the servers IPCONFIG test match what the Client machine thinks it is looking for?
Regards
CABC Support
Go to Start>Run and type 'Command' or 'CMD' then OK
try typing;
PING [server_name] enter
next
PING -A [server_IP_address] enter
then
TRACERT [server_name] enter
substitute [server_name] and [server_IP_address] with the name or IP address of this server on the LAN
If you don't know these details, go to the server and type 'CMD' in Start>Run and then type in the DOS prompt
IPCONFIG /ALL and then Enter
you will see something similar to;
Windows IP Configuration
Host Name . . . . . . . . . . . . : MACHINE1 {*}
Primary Dns Suffix . . . . . . . : cabc.co.uk
Node Type . . . . . . . . . . . . : Hybrid
IP Routing Enabled. . . . . . . . : No
WINS Proxy Enabled. . . . . . . . : No
DNS Suffix Search List. . . . . . : cabc.co.uk
Ethernet adapter Local Area Connection:
Connection-specific DNS Suffix . :
Description . . . . . . . . . . . : CNet PRO200WL PCI Fast Ethernet Adapter
Physical Address. . . . . . . . . : xx-xx-xx-xx-xx-xx
Dhcp Enabled. . . . . . . . . . . : Yes
Autoconfiguration Enabled . . . . : Yes
IP Address. . . . . . . . . . . . : 167.160.0.12 {*}
Subnet Mask . . . . . . . . . . . : 255.255.255.0
Default Gateway . . . . . . . . . : 167.160.0.1
DHCP Server . . . . . . . . . . . : 167.160.0.2
DNS Servers . . . . . . . . . . . : 167.160.0.2
Primary WINS Server . . . . . . . : 167.160.0.2
Lease Obtained. . . . . . . . . . : 22 January 2003 09:14:06
Lease Expires . . . . . . . . . . : 25 January 2003 09:14:06
The {*} marks are the Machine name and IP Address
Firstly what do the tests on the client show?
and secondly do the IP Address and Machine name of the server on the servers IPCONFIG test match what the Client machine thinks it is looking for?
Regards
CABC Support
---PING [server_name] enter
Pinging Statistics for 192.168.0.50
Packets sent =4, receive=4, lost = 0 (0%)
Approximate round up trip time in milli seconds:
Minimum = 0, Maximum = 3 ms, Average= 1 ms
--PING -A [server_IP_address] enter
Pinging Statistics for 192.168.0.50
Packets sent =4, receive=4, lost = 0 (0%)
Approximate round up trip time in milli seconds:
Minimum = 0, Maximum = 1 ms, Average= 0 ms
--TRACERT [server_name] enter
1 <10 ms <10ms <10ms alruqeent[192.168.0.50]
--Firstly what do the tests on the client show?
Showing the above result
--and secondly do the IP Address and Machine name of the server on the servers IPCONFIG test match what the Client machine thinks it is looking for?
How I can test it. Is there any parameter In Pervasive or maximizer which will show the server name it is looking for?
Regards
[This message was edited by z_monir on January 25, 2003 at 01:45 PM.]
Pinging Statistics for 192.168.0.50
Packets sent =4, receive=4, lost = 0 (0%)
Approximate round up trip time in milli seconds:
Minimum = 0, Maximum = 3 ms, Average= 1 ms
--PING -A [server_IP_address] enter
Pinging Statistics for 192.168.0.50
Packets sent =4, receive=4, lost = 0 (0%)
Approximate round up trip time in milli seconds:
Minimum = 0, Maximum = 1 ms, Average= 0 ms
--TRACERT [server_name] enter
1 <10 ms <10ms <10ms alruqeent[192.168.0.50]
--Firstly what do the tests on the client show?
Showing the above result
--and secondly do the IP Address and Machine name of the server on the servers IPCONFIG test match what the Client machine thinks it is looking for?
How I can test it. Is there any parameter In Pervasive or maximizer which will show the server name it is looking for?
Regards
[This message was edited by z_monir on January 25, 2003 at 01:45 PM.]
SmartScout may prove helpful here as well.
Test of Pervasive Analyzer produced this result. Is there any clue whether my client is rightly configured or not:
Tuesday, January 28, 2003, 08:07 ---Step 1 : Establish the workstation environment.Information : Winsock description : Microsoft wsock32.dll, ver2.2, 32bit of Jul 26 1999, at 07:41:28.
Warning : Winsock SPX is unavailable
Warning : socket error = 0
Warning : SPX closesocket error = 33685761
Information : Winsock TCP/IP is available
Information : Microsoft Networking API is available
Warning : Could not load CALWIN32.DLL
Warning : NetWare API is not available
Warning : Could not load W3NSR122.DLL
Tuesday, January 28, 2003, 08:07 ---Step 2 : Determine full target name.Information : Input target name is S:\MAXIMIZER_DATA
Information : IDSHOSTS file found as C:\PVSW\BIN\idshosts
Information : IDSHOSTS entry : #
Information : IDSHOSTS entry : # Example IDSHOSTS file.
Information : IDSHOSTS entry : #
Information : IDSHOSTS entry : # IDSHOSTS is a text file that resembles the standard Windows LMHOSTS
Information : IDSHOSTS entry : # specifications. The file must reside the %SystemRoot%\system32
Information : IDSHOSTS entry : # directory on Windows NT, or %SystemRoot%\system on Windows 95 and 98.
Information : IDSHOSTS entry : #
Information : IDSHOSTS entry : # IDSHOSTS is formated as the following:
Information : IDSHOSTS entry : #
Information : IDSHOSTS entry : # 1. All comments must be preceded by #
Information : IDSHOSTS entry : # 2. The server or drive being mapped has to be the first entry on
Information : IDSHOSTS entry : # a new line.
Information : IDSHOSTS entry : # 3. One or more spaces must separate the drive or server being
Information : IDSHOSTS entry : # mapped from the IDS server name.
Information : IDSHOSTS entry : # 4. If the path contains spaces it must be enclosed in double
Information : IDSHOSTS entry : # spaces.
Information : IDSHOSTS entry : # 5. An optional IDS Database Set name may be specified after the
Information : IDSHOSTS entry : # IDS server name, separated by one or more spaces. The IDS
Information : IDSHOSTS entry : # Database Set name is only used by the Btrieve Win32 Requester.
Information : IDSHOSTS entry : # 6. Server mappings have to start with two back slashes.
Information : IDSHOSTS entry : #
Information : IDSHOSTS entry : #
Information : IDSHOSTS entry : # j: www.pervasive.com # Drive mapping
Information : IDSHOSTS entry : # k:\myData\ 10.1.1.1 # IP notation can be used
Information : IDSHOSTS entry : # \\dataServer\public www.pervasive.com # Server names need \\
Information : IDSHOSTS entry : # "m:\my data\" yourserver.com # If there are spaces in
Information : IDSHOSTS entry : # # path the whole path must
Information : IDSHOSTS entry : # # be enclosed by ""
Information : IDSHOSTS entry : # l:\accounting AcctServer AcctDB # Example with IDS
Information : IDSHOSTS entry : # # Database Set name
Information : IDSHOSTS entry :
Information : Target does not appear to be IDS.
Warning : NetWare NDS API is not available
Warning : NetWare API not available for name parsing.
Information : Calling Microsoft Networking API to parse input target.
Information : Target server name ALRUQEENT
Information : Fully qualified name \\ALRUQEENT\APPL\MAXIMIZER_DATA
Tuesday, January 28, 2003, 08:07 ---Step 3 : Resolve full target name into a network address.Warning : NetWare NDS API not available for address resolution
Warning : Unable to query NetWare NDS
Warning : NetWare API not available for address resolution
Warning : Unable to read NetWare Bindery via NetWare API
Information : Using Winsock Name Resolution API to read NetWare Bindery
Information : There may be a slight delay - please wait
Warning : Unable to resolve server name via Winsock Name Resolution API
Information : Attempting to access Windows NT server ALRUQEENT
Information : Target engine TCP address : 192.168.0.50:3351
Warning : Unrecognized server protocol (17)
Tuesday, January 28, 2003, 08:07 ---Step 4 : Establish a connection to the target engine.Information : Attempting to connect via WinSock TCP/IP
Warning : TCP/IP setsockopt (SO_LINGER) error = 10014
Information : Local TCP/IP address : 192.168.0.100
Information : TCP/IP connection established (0x0040)
Tuesday, January 28, 2003, 08:07 ---Step 5 : Send data to/receive data from target server.Information : Making Btrieve Version call with TCP/IP.
Information : Btrieve Version is 7.90 Windows NT.
Information : Beginning TCP/IP Stress Test
Information : TCP/IP Stress test canceled by user
Information : Total TCP/IP requests processed : 75
Tuesday, January 28, 2003, 08:07 ---Step 6 : Terminate the established connection.Information : TCP/IP connection terminated successfully.
Information : -----
Information : Test completed on Tue Jan 28 08:07:12 2003
Information : -----
The network test was successful.
Tuesday, January 28, 2003, 08:07 ---Network test completed.
Tuesday, January 28, 2003, 08:07 ---Log ended.
Tuesday, January 28, 2003, 08:07 ---Step 1 : Establish the workstation environment.Information : Winsock description : Microsoft wsock32.dll, ver2.2, 32bit of Jul 26 1999, at 07:41:28.
Warning : Winsock SPX is unavailable
Warning : socket error = 0
Warning : SPX closesocket error = 33685761
Information : Winsock TCP/IP is available
Information : Microsoft Networking API is available
Warning : Could not load CALWIN32.DLL
Warning : NetWare API is not available
Warning : Could not load W3NSR122.DLL
Tuesday, January 28, 2003, 08:07 ---Step 2 : Determine full target name.Information : Input target name is S:\MAXIMIZER_DATA
Information : IDSHOSTS file found as C:\PVSW\BIN\idshosts
Information : IDSHOSTS entry : #
Information : IDSHOSTS entry : # Example IDSHOSTS file.
Information : IDSHOSTS entry : #
Information : IDSHOSTS entry : # IDSHOSTS is a text file that resembles the standard Windows LMHOSTS
Information : IDSHOSTS entry : # specifications. The file must reside the %SystemRoot%\system32
Information : IDSHOSTS entry : # directory on Windows NT, or %SystemRoot%\system on Windows 95 and 98.
Information : IDSHOSTS entry : #
Information : IDSHOSTS entry : # IDSHOSTS is formated as the following:
Information : IDSHOSTS entry : #
Information : IDSHOSTS entry : # 1. All comments must be preceded by #
Information : IDSHOSTS entry : # 2. The server or drive being mapped has to be the first entry on
Information : IDSHOSTS entry : # a new line.
Information : IDSHOSTS entry : # 3. One or more spaces must separate the drive or server being
Information : IDSHOSTS entry : # mapped from the IDS server name.
Information : IDSHOSTS entry : # 4. If the path contains spaces it must be enclosed in double
Information : IDSHOSTS entry : # spaces.
Information : IDSHOSTS entry : # 5. An optional IDS Database Set name may be specified after the
Information : IDSHOSTS entry : # IDS server name, separated by one or more spaces. The IDS
Information : IDSHOSTS entry : # Database Set name is only used by the Btrieve Win32 Requester.
Information : IDSHOSTS entry : # 6. Server mappings have to start with two back slashes.
Information : IDSHOSTS entry : #
Information : IDSHOSTS entry : #
Information : IDSHOSTS entry : # j: www.pervasive.com # Drive mapping
Information : IDSHOSTS entry : # k:\myData\ 10.1.1.1 # IP notation can be used
Information : IDSHOSTS entry : # \\dataServer\public www.pervasive.com # Server names need \\
Information : IDSHOSTS entry : # "m:\my data\" yourserver.com # If there are spaces in
Information : IDSHOSTS entry : # # path the whole path must
Information : IDSHOSTS entry : # # be enclosed by ""
Information : IDSHOSTS entry : # l:\accounting AcctServer AcctDB # Example with IDS
Information : IDSHOSTS entry : # # Database Set name
Information : IDSHOSTS entry :
Information : Target does not appear to be IDS.
Warning : NetWare NDS API is not available
Warning : NetWare API not available for name parsing.
Information : Calling Microsoft Networking API to parse input target.
Information : Target server name ALRUQEENT
Information : Fully qualified name \\ALRUQEENT\APPL\MAXIMIZER_DATA
Tuesday, January 28, 2003, 08:07 ---Step 3 : Resolve full target name into a network address.Warning : NetWare NDS API not available for address resolution
Warning : Unable to query NetWare NDS
Warning : NetWare API not available for address resolution
Warning : Unable to read NetWare Bindery via NetWare API
Information : Using Winsock Name Resolution API to read NetWare Bindery
Information : There may be a slight delay - please wait
Warning : Unable to resolve server name via Winsock Name Resolution API
Information : Attempting to access Windows NT server ALRUQEENT
Information : Target engine TCP address : 192.168.0.50:3351
Warning : Unrecognized server protocol (17)
Tuesday, January 28, 2003, 08:07 ---Step 4 : Establish a connection to the target engine.Information : Attempting to connect via WinSock TCP/IP
Warning : TCP/IP setsockopt (SO_LINGER) error = 10014
Information : Local TCP/IP address : 192.168.0.100
Information : TCP/IP connection established (0x0040)
Tuesday, January 28, 2003, 08:07 ---Step 5 : Send data to/receive data from target server.Information : Making Btrieve Version call with TCP/IP.
Information : Btrieve Version is 7.90 Windows NT.
Information : Beginning TCP/IP Stress Test
Information : TCP/IP Stress test canceled by user
Information : Total TCP/IP requests processed : 75
Tuesday, January 28, 2003, 08:07 ---Step 6 : Terminate the established connection.Information : TCP/IP connection terminated successfully.
Information : -----
Information : Test completed on Tue Jan 28 08:07:12 2003
Information : -----
The network test was successful.
Tuesday, January 28, 2003, 08:07 ---Network test completed.
Tuesday, January 28, 2003, 08:07 ---Log ended.
You didnt include registry settings so i couldn't see what protocols Maximizer/Pervasive is using.
Did the TCP/IP test run quite smoothly (i.e. the count didn't stop and start or pause at all?) let it run beyond 75, a couple of thousand perhaps
If TCP/IP runs ok try going to the Pervasive Control Centre and changing both Server and Client Communications Protocols to TCP/IP only at both ends.
See how this goes.
When i asked about the each machine wondering if they had the correct details i was enquiring about Routing and Name Resolution
What else does this machine do?
Is this the only server or do you have others?
If it is the only one, how many clients do you have?
I assume it has 2Gb of Ram not 2Mb
The (SO_Linger) error in the SmartScout can be ignored, and the rest doesn't to reveal much.
If the total load on the server is only 4% then i would suspect a Protocol issue, but if this is a Primary Domain Controller with lots of clients then 4% is quite low.
Regards
CABC Support
Did the TCP/IP test run quite smoothly (i.e. the count didn't stop and start or pause at all?) let it run beyond 75, a couple of thousand perhaps
If TCP/IP runs ok try going to the Pervasive Control Centre and changing both Server and Client Communications Protocols to TCP/IP only at both ends.
See how this goes.
When i asked about the each machine wondering if they had the correct details i was enquiring about Routing and Name Resolution
What else does this machine do?
Is this the only server or do you have others?
If it is the only one, how many clients do you have?
I assume it has 2Gb of Ram not 2Mb
The (SO_Linger) error in the SmartScout can be ignored, and the rest doesn't to reveal much.
If the total load on the server is only 4% then i would suspect a Protocol issue, but if this is a Primary Domain Controller with lots of clients then 4% is quite low.
Regards
CABC Support
[QUOTE]Originally posted by CABC Support:
You didnt include registry settings so i couldn't see what protocols Maximizer/Pervasive is using.
Pervasive Server:
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Btrieve Requester]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Btrieve Requester\Version 7]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Btrieve Requester\Version 7\Settings]
"Splash Screen"="No"
"Embedded Spaces"="no"
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Communications Requester]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Communications Requester\Version 7]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Communications Requester\Version 7\Settings]
"TCP connect timeout"=dword:0000000f
"Supported protocols"="TCPIP"
"Runtime server"="Yes"
"Enable AutoReconnect"="No"
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Control Center]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Control Center\2.0]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Control Center\2.0\Extendable]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Control Center\2.0\Extendable\{A3896D81-BDF8-11d3-BC90-00104B12EF1F}]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Control Center\2.0\Extendable\{A3896D81-BDF8-11d3-BC90-00104B12EF1F}\Menu]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Control Center\2.0\Extendable\{A3896D81-BDF8-11d3-BC90-00104B12EF1F}\Namespace]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Control Center\2.0\Extendable\{C1273D0E-92A5-4242-BDAB-E945472D13C2}]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Control Center\2.0\Extendable\{C1273D0E-92A5-4242-BDAB-E945472D13C2}\Menu]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Control Center\2.0\Extendable\{C1273D0E-92A5-4242-BDAB-E945472D13C2}\Namespace]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Control Center\2.0\Extendable\{C1273D0E-92A5-4242-BDAB-E945472D13C2}\Namespace\{140B1898-B47A-11D3-9194-00A024C8C314}]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Control Center\2.0\Pervasive.SQL BCP]
"ExternalTools"=hex(7):46,75,6e,63,74,69,6f,6e,20,45,78,65,63,75,74,6f,72,00,\
43,3a,5c,50,56,53,57,5c,42,49,4e,5c,57,42,45,58,45,43,33,32,2e,45,58,45,00,\
00,4d,61,69,6e,74,65,6e,61,6e,63,65,00,43,3a,5c,50,56,53,57,5c,42,49,4e,5c,\
57,33,32,4d,41,49,4e,54,2e,45,58,45,00,00,4d,6f,6e,69,74,6f,72,00,43,3a,5c,\
50,56,53,57,5c,42,49,4e,5c,57,33,4d,4f,4e,56,37,35,2e,45,58,45,00,00,52,65,\
62,75,69,6c,64,00,43,3a,5c,50,56,53,57,5c,42,49,4e,5c,57,33,32,52,42,4c,44,\
2e,45,58,45,00,00,55,73,65,72,20,43,6f,75,6e,74,20,41,64,6d,69,6e,69,73,74,\
72,61,74,6f,72,00,43,3a,5c,50,56,53,57,5c,42,49,4e,5c,57,33,32,55,43,41,44,\
4d,2e,45,58,45,00,00,4f,44,42,43,20,41,64,6d,69,6e,69,73,74,72,61,74,6f,72,\
00,43,3a,5c,57,49,4e,4e,54,5c,53,79,73,74,65,6d,33,32,5c,4f,44,42,43,41,44,\
33,32,2e,45,58,45,00,00,00
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Control Center\2.0\Providers]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Control Center\2.0\Providers\{140B1898-B47A-11D3-9194-00A024C8C314}]
@="Pervasive Config ECP"
"Name"="Pervasive.SQL 2000 Configuration"
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Control Center\2.0\Providers\{140B1898-B47A-11D3-9194-00A024C8C314}\Extendable]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Control Center\2.0\Providers\{8CDB7CF7-8206-484A-A3FB-CE42CFEFDD8B}]
@="Pervasive.SQL 2000 BCP"
"Name"="Pervasive.SQL 2000 Base Content Provider"
"BaseProvider"=dword:00000001
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Control Center\2.0\Providers\{8CDB7CF7-8206-484A-A3FB-CE42CFEFDD8B}\Extendable]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Control Center\2.0\Providers\{8CDB7CF7-8206-484A-A3FB-CE42CFEFDD8B}\Extendable\{A3896D81-BDF8-11d3-BC90-00104B12EF1F}]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Control Center\2.0\Providers\{8CDB7CF7-8206-484A-A3FB-CE42CFEFDD8B}\Extendable\{C1273D0E-92A5-4242-BDAB-E945472D13C2}]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Database Names]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Database Names\Version 4.00]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Database Names\Version 4.00\Settings]
"DBNamesDirectory"="C:\\PVSW\\Bin\\MKDE"
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Microkernel Router]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Microkernel Router\Version 7]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Microkernel Router\Version 7\Settings]
"Local"="yes"
"Requester"="yes"
"Use IDS"="yes"
"IDS Username"="<None>"
"IDS Password"="<None>"
"Compress IDS Data"="no"
"Load Retries"=dword:00000005
"Target Engine"=dword:00000002
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\MicroKernel Server Engine]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\MicroKernel Server Engine\Version 7]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\MicroKernel Server Engine\Version 7\Settings]
"DBNamesDirectory"="C:\\PVSW\\Bin\\MKDE"
"Max Files"=dword:00002710
"Max Handles"=dword:000186a0
"Balanced Trees"="NO"
"File Version"="0700"
"System Data"="YES"
"Max Databases"=dword:000003e8
"Logging"="NO"
"Cache Size"=dword:000665e4
"Compression Buffer Size"=dword:00000005
"Extended Buffer Size"=dword:00000010
"Merge Sort Buffer Size"=dword:00000000
"Max Communication Buffer Size"=dword:0000003f
"Transaction Durability"="YES"
"Transaction Log Buffer Size"=dword:00000100
"Transaction Log File Size"=dword:00000200
"Systrans Bundle Limit"=dword:0000ffff
"Systrans Time Limit"=dword:00002710
"Max Clients"=dword:00002710
"Background Threads"=dword:00000004
"Wait-lock Timeout"=dword:0000000f
"Transaction Log Directory"="C:\\PVSW\\BIN\\MKDE\\LOG"
"Work Space"=""
"Trace"="NO"
"Trace File"="C:\\PVSW\\BIN\\MKDE.TRA"
"Trace Databuf Len"=dword:00000080
"Trace Keybuf Len"=dword:00000080
"Trace Ops"="ALL"
"System Cache"="YES"
"Preallocate"="NO"
"Minimal States"="YES"
"Minimal States Delay"=dword:0000001e
"Worker Threads"=dword:00000001
"Max Remote Communications Buffer Size"=dword:0000003f
"Remote Read Buffer Size"=dword:0000003c
"Max Remote Sessions"=dword:00000064
"Remote Worker Threads"=dword:00000010
"Remote Sessions Enabled"="YES"
"Supported Protocols"=hex(7):54,43,50,2f,49,50,00,4e,45,54,42,49,4f,53,00
"Home Directory"="C:\\PVSW\\BIN"
"Protocol Init Timeout"=dword:0000003c
"TCPIP Multi-Homed"="NO"
"Listen IP Address"="192.168.0.50"
"NetBIOS Port Number"=dword:00000042
"Enable AutoReconnect"="NO"
"AutoReconnect Timeout"="180"
"Validate Request"="NO"
"Max Async IO"=dword:00000800
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Monitor Utility]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Monitor Utility\Version 7.90]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Monitor Utility\Version 7.90\Settings]
"Save Settings"="Yes"
"Refresh Rate"=dword:00000004
"MKDE Resource Usage Window AutoRefresh"="Yes"
"MKDE Communication Statistics Window AutoRefresh"="Yes"
"MKDE Active Files Window AutoRefresh"="Yes"
"MKDE Active Users Window AutoRefresh"="Yes"
"SQL Connection Manager Window AutoRefresh"="Yes"
"Save Layout"="Yes"
"Main Window X"=dword:00000084
"Main Window Y"=dword:00000084
"Main Window Width"=dword:00000258
"Main Window Height"=dword:0000019b
"Show MKDE Resource Usage Window"="No"
"Show MKDE Communication Statistics Window"="No"
"Show MKDE Active Files Window"="No"
"Show MKDE Active Users Window"="No"
"Show SQL Connection Manager Window"="No"
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Products]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Products\Pervasive.SQL 2000 NT Server]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Products\Pervasive.SQL 2000 NT Server\InstallInfo]
"InstallDir"="C:\\PVSW"
"SystemDir"="C:\\WINNT\\System32\\"
"InstallIniName"="PTKSETUP.INI"
"VersionLevel"="7.94"
"PatchLevel"="4"
"BuildLevel"="251"
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\SQL Connection Manager]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\SQL Connection Manager\SERVER.INI]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\SQL Connection Manager\SERVER.INI\Processes]
"W3ODBCEI"="2001"
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\SQL Connection Manager\SERVER.INI\SQLManager]
"LogEvent"="1"
"MgrPort"="1583"
"MgrSPXPort"="29320"
"MgrUseTransport"="TCP"
"MgrMaxConnections"="2001"
Pervasive Client
[HKEY_LOCAL_MACHINE\Software\Pervasive Software]
[HKEY_LOCAL_MACHINE\Software\Pervasive Software\Products]
[HKEY_LOCAL_MACHINE\Software\Pervasive Software\Products\Pervasive.SQL 2000 Workstation]
[HKEY_LOCAL_MACHINE\Software\Pervasive Software\Products\Pervasive.SQL 2000 Workstation\InstallInfo]
"InstallDir"="C:\\PVSW"
"SystemDir"="C:\\WINDOWS\\SYSTEM\\"
"InstallIniName"="PTKSETUP.INI"
"VersionLevel"="7.94"
"PatchLevel"="4"
"BuildLevel"="251"
[HKEY_LOCAL_MACHINE\Software\Pervasive Software\Btrieve Requester]
[HKEY_LOCAL_MACHINE\Software\Pervasive Software\Btrieve Requester\Version 7]
[HKEY_LOCAL_MACHINE\Software\Pervasive Software\Btrieve Requester\Version 7\Settings]
"Splash Screen"="No"
"Embedded Spaces"="no"
[HKEY_LOCAL_MACHINE\Software\Pervasive Software\Control Center]
[HKEY_LOCAL_MACHINE\Software\Pervasive Software\Control Center\2.0]
[HKEY_LOCAL_MACHINE\Software\Pervasive Software\Control Center\2.0\Providers]
[HKEY_LOCAL_MACHINE\Software\Pervasive Software\Control Center\2.0\Providers\{8CDB7CF7-8206-484A-A3FB-CE42CFEFDD8B}]
@="Pervasive.SQL 2000 BCP"
"Name"="Pervasive.SQL 2000 Base Content Provider"
"BaseProvider"=dword:00000001
[HKEY_LOCAL_MACHINE\Software\Pervasive Software\Control Center\2.0\Providers\{8CDB7CF7-8206-484A-A3FB-CE42CFEFDD8B}\Extendable]
[HKEY_LOCAL_MACHINE\Software\Pervasive Software\Control Center\2.0\Providers\{8CDB7CF7-8206-484A-A3FB-CE42CFEFDD8B}\Extendable\{C1273D0E-92A5-4242-BDAB-E945472D13C2}]
[HKEY_LOCAL_MACHINE\Software\Pervasive Software\Control Center\2.0\Providers\{8CDB7CF7-8206-484A-A3FB-CE42CFEFDD8B}\Extendable\{A3896D81-BDF8-11d3-BC90-00104B12EF1F}]
[HKEY_LOCAL_MACHINE\Software\Pervasive Software\Control Center\2.0\Providers\{140B1898-B47A-11D3-9194-00A024C8C314}]
@="Pervasive Config ECP"
"Name"="Pervasive.SQL 2000 Configuration"
[HKEY_LOCAL_MACHINE\Software\Pervasive Software\Control Center\2.0\Providers\{140B1898-B47A-11D3-9194-00A024C8C314}\Extendable]
[HKEY_LOCAL_MACHINE\Software\Pervasive Software\Control Center\2.0\Extendable]
[HKEY_LOCAL_MACHINE\Software\Pervasive Software\Control Center\2.0\Extendable\{C1273D0E-92A5-4242-BDAB-E945472D13C2}]
[HKEY_LOCAL_MACHINE\Software\Pervasive Software\Control Center\2.0\Extendable\{C1273D0E-92A5-4242-BDAB-E945472D13C2}\Namespace]
[HKEY_LOCAL_MACHINE\Software\Pervasive Software\Control Center\2.0\Extendable\{C1273D0E-92A5-4242-BDAB-E945472D13C2}\Namespace\{140B1898-B47A-11D3-9194-00A024C8C314}]
[HKEY_LOCAL_MACHINE\Software\Pervasive Software\Control Center\2.0\Extendable\{C1273D0E-92A5-4242-BDAB-E945472D13C2}\Menu]
[HKEY_LOCAL_MACHINE\Software\Pervasive Software\Control Center\2.0\Extendable\{A3896D81-BDF8-11d3-BC90-00104B12EF1F}]
[HKEY_LOCAL_MACHINE\Software\Pervasive Software\Control Center\2.0\Extendable\{A3896D81-BDF8-11d3-BC90-00104B12EF1F}\Namespace]
[HKEY_LOCAL_MACHINE\Software\Pervasive Software\Control Center\2.0\Extendable\{A3896D81-BDF8-11d3-BC90-00104B12EF1F}\Menu]
[HKEY_LOCAL_MACHINE\Software\Pervasive Software\Control Center\2.0\Pervasive.SQL BCP]
"ExternalTools"=hex(7):46,75,6e,63,74,69,6f,6e,20,45,78,65,63,75,74,6f,72,00,\
43,3a,5c,50,56,53,57,5c,42,49,4e,5c,57,42,45,58,45,43,33,32,2e,45,58,45,00,\
00,47,61,74,65,77,61,79,20,4c,6f,63,61,74,6f,72,00,43,3a,5c,50,56,53,57,5c,\
42,49,4e,5c,50,56,4c,4f,43,41,54,45,2e,45,58,45,00,00,4d,61,69,6e,74,65,6e,\
61,6e,63,65,00,43,3a,5c,50,56,53,57,5c,42,49,4e,5c,57,33,32,4d,41,49,4e,54,\
2e,45,58,45,00,00,4d,6f,6e,69,74,6f,72,00,43,3a,5c,50,56,53,57,5c,42,49,4e,\
5c,57,33,4d,4f,4e,56,37,35,2e,45,58,45,00,00,52,65,62,75,69,6c,64,00,43,3a,\
5c,50,56,53,57,5c,42,49,4e,5c,57,33,32,52,42,4c,44,2e,45,58,45,00,00,55,73,\
65,72,20,43,6f,75,6e,74,20,41,64,6d,69,6e,69,73,74,72,61,74,6f,72,00,43,3a,\
5c,50,56,53,57,5c,42,49,4e,5c,57,33,32,55,43,41,44,4d,2e,45,58,45,00,00,4f,\
44,42,43,20,41,64,6d,69,6e,69,73,74,72,61,74,6f,72,00,43,3a,5c,57,49,4e,44,\
4f,57,53,5c,53,59,53,54,45,4d,5c,4f,44,42,43,41,44,33,32,2e,45,58,45,00,00,\
00
[HKEY_LOCAL_MACHINE\Software\Pervasive Software\MicroKernel Workstation Engine]
[HKEY_LOCAL_MACHINE\Software\Pervasive Software\MicroKernel Workstation Engine\Version 7]
[HKEY_LOCAL_MACHINE\Software\Pervasive Software\MicroKernel Workstation Engine\Version 7\Settings]
"Remote Sessions Enabled"="Yes"
"Max Files"=dword:00002710
"Max Handles"=dword:000186a0
"Balanced Trees"="NO"
"File Version"="0700"
"System Data"="YES"
"Max Databases"=dword:000003e8
"Logging"="NO"
"Cache Size"=dword:00002000
"Compression Buffer Size"=dword:00000005
"Extended Buffer Size"=dword:00000010
"Merge Sort Buffer Size"=dword:00000000
"Max Communication Buffer Size"=dword:0000003f
"Transaction Durability"="YES"
"Transaction Log Buffer Size"=dword:00000100
"Transaction Log File Size"=dword:00000200
"Systrans Bundle Limit"=dword:0000ffff
"Systrans Time Limit"=dword:00002710
"Max Clients"=dword:00002710
"Background Threads"=dword:00000004
"Wait-lock Timeout"=dword:0000000f
"Transaction Log Directory"="C:\\PVSW\\BIN\\MKDE\\LOG"
"DBNamesDirectory"="C:\\PVSW\\Bin\\MKDE"
"Trace"="NO"
"Trace File"="C:\\PVSW\\BIN\\MKDE.TRA"
"Trace Databuf Len"=dword:00000080
"Trace Keybuf Len"=dword:00000080
"Trace Ops"="ALL"
"Validate Request"="NO"
"System Cache"="YES"
"Preallocate"="NO"
"Minimal States"="YES"
"Minimal States Delay"=dword:0000001e
"Worker Threads"=dword:00000001
"Max Remote Communications Buffer Size"=dword:0000003f
"Remote Read Buffer Size"=dword:0000003c
"Max Remote Sessions"=dword:00000064
"Remote Worker Threads"=dword:00000010
"Supported protocols"=hex(7):54,43,50,2f,49,50,00
"Protocol Init Timeout"=dword:0000003c
"TCPIP Multi-Homed"="NO"
"Listen IP Address"="192.168.0.50"
"NetBIOS Port Number"=dword:00000042
"Home Directory"="C:\\PVSW\\BIN"
"Enable AutoReconnect"="NO"
"AutoReconnect Timeout"="180"
[HKEY_LOCAL_MACHINE\Software\Pervasive Software\Communications Requester]
[HKEY_LOCAL_MACHINE\Software\Pervasive Software\Communications Requester\Version 7]
[HKEY_LOCAL_MACHINE\Software\Pervasive Software\Communications Requester\Version 7\Settings]
"TCP connect timeout"=dword:0000000f
"Supported protocols"="TCPIP"
"Runtime server"="Yes"
"Enable AutoReconnect"="No"
[HKEY_LOCAL_MACHINE\Software\Pervasive Software\Microkernel Router]
[HKEY_LOCAL_MACHINE\Software\Pervasive Software\Microkernel Router\Version 7]
[HKEY_LOCAL_MACHINE\Software\Pervasive Software\Microkernel Router\Version 7\Settings]
"Local"="yes"
"Requester"="yes"
"Use IDS"="yes"
"IDS Username"="<None>"
"IDS Password"="<None>"
"Compress IDS Data"="no"
"Load Retries"=dword:00000005
"Target Engine"=dword:00000001
[HKEY_LOCAL_MACHINE\Software\Pervasive Software\Database Names]
[HKEY_LOCAL_MACHINE\Software\Pervasive Software\Database Names\Version 4.00]
[HKEY_LOCAL_MACHINE\Software\Pervasive Software\Database Names\Version 4.00\Settings]
"DBNamesDirectory"="C:\\PVSW\\Bin\\MKDE"
[HKEY_LOCAL_MACHINE\Software\Pervasive Software\SQL Connection Manager]
[HKEY_LOCAL_MACHINE\Software\Pervasive Software\SQL Connection Manager\SERVER.INI]
[HKEY_LOCAL_MACHINE\Software\Pervasive Software\SQL Connection Manager\SERVER.INI\Processes]
"W3ODBCEI"="2001"
[HKEY_LOCAL_MACHINE\Software\Pervasive Software\SQL Connection Manager\SERVER.INI\SQLManager]
"LogEvent"="1"
"MgrPort"="1583"
"MgrSPXPort"="29320"
"MgrUseTransport"="TCP"
"MgrMaxConnections"="2001"
Does this reveals any clue if no then I will inform your other queries.
You didnt include registry settings so i couldn't see what protocols Maximizer/Pervasive is using.
Pervasive Server:
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Btrieve Requester]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Btrieve Requester\Version 7]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Btrieve Requester\Version 7\Settings]
"Splash Screen"="No"
"Embedded Spaces"="no"
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Communications Requester]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Communications Requester\Version 7]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Communications Requester\Version 7\Settings]
"TCP connect timeout"=dword:0000000f
"Supported protocols"="TCPIP"
"Runtime server"="Yes"
"Enable AutoReconnect"="No"
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Control Center]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Control Center\2.0]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Control Center\2.0\Extendable]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Control Center\2.0\Extendable\{A3896D81-BDF8-11d3-BC90-00104B12EF1F}]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Control Center\2.0\Extendable\{A3896D81-BDF8-11d3-BC90-00104B12EF1F}\Menu]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Control Center\2.0\Extendable\{A3896D81-BDF8-11d3-BC90-00104B12EF1F}\Namespace]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Control Center\2.0\Extendable\{C1273D0E-92A5-4242-BDAB-E945472D13C2}]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Control Center\2.0\Extendable\{C1273D0E-92A5-4242-BDAB-E945472D13C2}\Menu]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Control Center\2.0\Extendable\{C1273D0E-92A5-4242-BDAB-E945472D13C2}\Namespace]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Control Center\2.0\Extendable\{C1273D0E-92A5-4242-BDAB-E945472D13C2}\Namespace\{140B1898-B47A-11D3-9194-00A024C8C314}]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Control Center\2.0\Pervasive.SQL BCP]
"ExternalTools"=hex(7):46,75,6e,63,74,69,6f,6e,20,45,78,65,63,75,74,6f,72,00,\
43,3a,5c,50,56,53,57,5c,42,49,4e,5c,57,42,45,58,45,43,33,32,2e,45,58,45,00,\
00,4d,61,69,6e,74,65,6e,61,6e,63,65,00,43,3a,5c,50,56,53,57,5c,42,49,4e,5c,\
57,33,32,4d,41,49,4e,54,2e,45,58,45,00,00,4d,6f,6e,69,74,6f,72,00,43,3a,5c,\
50,56,53,57,5c,42,49,4e,5c,57,33,4d,4f,4e,56,37,35,2e,45,58,45,00,00,52,65,\
62,75,69,6c,64,00,43,3a,5c,50,56,53,57,5c,42,49,4e,5c,57,33,32,52,42,4c,44,\
2e,45,58,45,00,00,55,73,65,72,20,43,6f,75,6e,74,20,41,64,6d,69,6e,69,73,74,\
72,61,74,6f,72,00,43,3a,5c,50,56,53,57,5c,42,49,4e,5c,57,33,32,55,43,41,44,\
4d,2e,45,58,45,00,00,4f,44,42,43,20,41,64,6d,69,6e,69,73,74,72,61,74,6f,72,\
00,43,3a,5c,57,49,4e,4e,54,5c,53,79,73,74,65,6d,33,32,5c,4f,44,42,43,41,44,\
33,32,2e,45,58,45,00,00,00
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Control Center\2.0\Providers]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Control Center\2.0\Providers\{140B1898-B47A-11D3-9194-00A024C8C314}]
@="Pervasive Config ECP"
"Name"="Pervasive.SQL 2000 Configuration"
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Control Center\2.0\Providers\{140B1898-B47A-11D3-9194-00A024C8C314}\Extendable]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Control Center\2.0\Providers\{8CDB7CF7-8206-484A-A3FB-CE42CFEFDD8B}]
@="Pervasive.SQL 2000 BCP"
"Name"="Pervasive.SQL 2000 Base Content Provider"
"BaseProvider"=dword:00000001
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Control Center\2.0\Providers\{8CDB7CF7-8206-484A-A3FB-CE42CFEFDD8B}\Extendable]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Control Center\2.0\Providers\{8CDB7CF7-8206-484A-A3FB-CE42CFEFDD8B}\Extendable\{A3896D81-BDF8-11d3-BC90-00104B12EF1F}]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Control Center\2.0\Providers\{8CDB7CF7-8206-484A-A3FB-CE42CFEFDD8B}\Extendable\{C1273D0E-92A5-4242-BDAB-E945472D13C2}]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Database Names]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Database Names\Version 4.00]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Database Names\Version 4.00\Settings]
"DBNamesDirectory"="C:\\PVSW\\Bin\\MKDE"
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Microkernel Router]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Microkernel Router\Version 7]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Microkernel Router\Version 7\Settings]
"Local"="yes"
"Requester"="yes"
"Use IDS"="yes"
"IDS Username"="<None>"
"IDS Password"="<None>"
"Compress IDS Data"="no"
"Load Retries"=dword:00000005
"Target Engine"=dword:00000002
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\MicroKernel Server Engine]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\MicroKernel Server Engine\Version 7]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\MicroKernel Server Engine\Version 7\Settings]
"DBNamesDirectory"="C:\\PVSW\\Bin\\MKDE"
"Max Files"=dword:00002710
"Max Handles"=dword:000186a0
"Balanced Trees"="NO"
"File Version"="0700"
"System Data"="YES"
"Max Databases"=dword:000003e8
"Logging"="NO"
"Cache Size"=dword:000665e4
"Compression Buffer Size"=dword:00000005
"Extended Buffer Size"=dword:00000010
"Merge Sort Buffer Size"=dword:00000000
"Max Communication Buffer Size"=dword:0000003f
"Transaction Durability"="YES"
"Transaction Log Buffer Size"=dword:00000100
"Transaction Log File Size"=dword:00000200
"Systrans Bundle Limit"=dword:0000ffff
"Systrans Time Limit"=dword:00002710
"Max Clients"=dword:00002710
"Background Threads"=dword:00000004
"Wait-lock Timeout"=dword:0000000f
"Transaction Log Directory"="C:\\PVSW\\BIN\\MKDE\\LOG"
"Work Space"=""
"Trace"="NO"
"Trace File"="C:\\PVSW\\BIN\\MKDE.TRA"
"Trace Databuf Len"=dword:00000080
"Trace Keybuf Len"=dword:00000080
"Trace Ops"="ALL"
"System Cache"="YES"
"Preallocate"="NO"
"Minimal States"="YES"
"Minimal States Delay"=dword:0000001e
"Worker Threads"=dword:00000001
"Max Remote Communications Buffer Size"=dword:0000003f
"Remote Read Buffer Size"=dword:0000003c
"Max Remote Sessions"=dword:00000064
"Remote Worker Threads"=dword:00000010
"Remote Sessions Enabled"="YES"
"Supported Protocols"=hex(7):54,43,50,2f,49,50,00,4e,45,54,42,49,4f,53,00
"Home Directory"="C:\\PVSW\\BIN"
"Protocol Init Timeout"=dword:0000003c
"TCPIP Multi-Homed"="NO"
"Listen IP Address"="192.168.0.50"
"NetBIOS Port Number"=dword:00000042
"Enable AutoReconnect"="NO"
"AutoReconnect Timeout"="180"
"Validate Request"="NO"
"Max Async IO"=dword:00000800
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Monitor Utility]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Monitor Utility\Version 7.90]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Monitor Utility\Version 7.90\Settings]
"Save Settings"="Yes"
"Refresh Rate"=dword:00000004
"MKDE Resource Usage Window AutoRefresh"="Yes"
"MKDE Communication Statistics Window AutoRefresh"="Yes"
"MKDE Active Files Window AutoRefresh"="Yes"
"MKDE Active Users Window AutoRefresh"="Yes"
"SQL Connection Manager Window AutoRefresh"="Yes"
"Save Layout"="Yes"
"Main Window X"=dword:00000084
"Main Window Y"=dword:00000084
"Main Window Width"=dword:00000258
"Main Window Height"=dword:0000019b
"Show MKDE Resource Usage Window"="No"
"Show MKDE Communication Statistics Window"="No"
"Show MKDE Active Files Window"="No"
"Show MKDE Active Users Window"="No"
"Show SQL Connection Manager Window"="No"
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Products]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Products\Pervasive.SQL 2000 NT Server]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Products\Pervasive.SQL 2000 NT Server\InstallInfo]
"InstallDir"="C:\\PVSW"
"SystemDir"="C:\\WINNT\\System32\\"
"InstallIniName"="PTKSETUP.INI"
"VersionLevel"="7.94"
"PatchLevel"="4"
"BuildLevel"="251"
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\SQL Connection Manager]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\SQL Connection Manager\SERVER.INI]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\SQL Connection Manager\SERVER.INI\Processes]
"W3ODBCEI"="2001"
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\SQL Connection Manager\SERVER.INI\SQLManager]
"LogEvent"="1"
"MgrPort"="1583"
"MgrSPXPort"="29320"
"MgrUseTransport"="TCP"
"MgrMaxConnections"="2001"
Pervasive Client
[HKEY_LOCAL_MACHINE\Software\Pervasive Software]
[HKEY_LOCAL_MACHINE\Software\Pervasive Software\Products]
[HKEY_LOCAL_MACHINE\Software\Pervasive Software\Products\Pervasive.SQL 2000 Workstation]
[HKEY_LOCAL_MACHINE\Software\Pervasive Software\Products\Pervasive.SQL 2000 Workstation\InstallInfo]
"InstallDir"="C:\\PVSW"
"SystemDir"="C:\\WINDOWS\\SYSTEM\\"
"InstallIniName"="PTKSETUP.INI"
"VersionLevel"="7.94"
"PatchLevel"="4"
"BuildLevel"="251"
[HKEY_LOCAL_MACHINE\Software\Pervasive Software\Btrieve Requester]
[HKEY_LOCAL_MACHINE\Software\Pervasive Software\Btrieve Requester\Version 7]
[HKEY_LOCAL_MACHINE\Software\Pervasive Software\Btrieve Requester\Version 7\Settings]
"Splash Screen"="No"
"Embedded Spaces"="no"
[HKEY_LOCAL_MACHINE\Software\Pervasive Software\Control Center]
[HKEY_LOCAL_MACHINE\Software\Pervasive Software\Control Center\2.0]
[HKEY_LOCAL_MACHINE\Software\Pervasive Software\Control Center\2.0\Providers]
[HKEY_LOCAL_MACHINE\Software\Pervasive Software\Control Center\2.0\Providers\{8CDB7CF7-8206-484A-A3FB-CE42CFEFDD8B}]
@="Pervasive.SQL 2000 BCP"
"Name"="Pervasive.SQL 2000 Base Content Provider"
"BaseProvider"=dword:00000001
[HKEY_LOCAL_MACHINE\Software\Pervasive Software\Control Center\2.0\Providers\{8CDB7CF7-8206-484A-A3FB-CE42CFEFDD8B}\Extendable]
[HKEY_LOCAL_MACHINE\Software\Pervasive Software\Control Center\2.0\Providers\{8CDB7CF7-8206-484A-A3FB-CE42CFEFDD8B}\Extendable\{C1273D0E-92A5-4242-BDAB-E945472D13C2}]
[HKEY_LOCAL_MACHINE\Software\Pervasive Software\Control Center\2.0\Providers\{8CDB7CF7-8206-484A-A3FB-CE42CFEFDD8B}\Extendable\{A3896D81-BDF8-11d3-BC90-00104B12EF1F}]
[HKEY_LOCAL_MACHINE\Software\Pervasive Software\Control Center\2.0\Providers\{140B1898-B47A-11D3-9194-00A024C8C314}]
@="Pervasive Config ECP"
"Name"="Pervasive.SQL 2000 Configuration"
[HKEY_LOCAL_MACHINE\Software\Pervasive Software\Control Center\2.0\Providers\{140B1898-B47A-11D3-9194-00A024C8C314}\Extendable]
[HKEY_LOCAL_MACHINE\Software\Pervasive Software\Control Center\2.0\Extendable]
[HKEY_LOCAL_MACHINE\Software\Pervasive Software\Control Center\2.0\Extendable\{C1273D0E-92A5-4242-BDAB-E945472D13C2}]
[HKEY_LOCAL_MACHINE\Software\Pervasive Software\Control Center\2.0\Extendable\{C1273D0E-92A5-4242-BDAB-E945472D13C2}\Namespace]
[HKEY_LOCAL_MACHINE\Software\Pervasive Software\Control Center\2.0\Extendable\{C1273D0E-92A5-4242-BDAB-E945472D13C2}\Namespace\{140B1898-B47A-11D3-9194-00A024C8C314}]
[HKEY_LOCAL_MACHINE\Software\Pervasive Software\Control Center\2.0\Extendable\{C1273D0E-92A5-4242-BDAB-E945472D13C2}\Menu]
[HKEY_LOCAL_MACHINE\Software\Pervasive Software\Control Center\2.0\Extendable\{A3896D81-BDF8-11d3-BC90-00104B12EF1F}]
[HKEY_LOCAL_MACHINE\Software\Pervasive Software\Control Center\2.0\Extendable\{A3896D81-BDF8-11d3-BC90-00104B12EF1F}\Namespace]
[HKEY_LOCAL_MACHINE\Software\Pervasive Software\Control Center\2.0\Extendable\{A3896D81-BDF8-11d3-BC90-00104B12EF1F}\Menu]
[HKEY_LOCAL_MACHINE\Software\Pervasive Software\Control Center\2.0\Pervasive.SQL BCP]
"ExternalTools"=hex(7):46,75,6e,63,74,69,6f,6e,20,45,78,65,63,75,74,6f,72,00,\
43,3a,5c,50,56,53,57,5c,42,49,4e,5c,57,42,45,58,45,43,33,32,2e,45,58,45,00,\
00,47,61,74,65,77,61,79,20,4c,6f,63,61,74,6f,72,00,43,3a,5c,50,56,53,57,5c,\
42,49,4e,5c,50,56,4c,4f,43,41,54,45,2e,45,58,45,00,00,4d,61,69,6e,74,65,6e,\
61,6e,63,65,00,43,3a,5c,50,56,53,57,5c,42,49,4e,5c,57,33,32,4d,41,49,4e,54,\
2e,45,58,45,00,00,4d,6f,6e,69,74,6f,72,00,43,3a,5c,50,56,53,57,5c,42,49,4e,\
5c,57,33,4d,4f,4e,56,37,35,2e,45,58,45,00,00,52,65,62,75,69,6c,64,00,43,3a,\
5c,50,56,53,57,5c,42,49,4e,5c,57,33,32,52,42,4c,44,2e,45,58,45,00,00,55,73,\
65,72,20,43,6f,75,6e,74,20,41,64,6d,69,6e,69,73,74,72,61,74,6f,72,00,43,3a,\
5c,50,56,53,57,5c,42,49,4e,5c,57,33,32,55,43,41,44,4d,2e,45,58,45,00,00,4f,\
44,42,43,20,41,64,6d,69,6e,69,73,74,72,61,74,6f,72,00,43,3a,5c,57,49,4e,44,\
4f,57,53,5c,53,59,53,54,45,4d,5c,4f,44,42,43,41,44,33,32,2e,45,58,45,00,00,\
00
[HKEY_LOCAL_MACHINE\Software\Pervasive Software\MicroKernel Workstation Engine]
[HKEY_LOCAL_MACHINE\Software\Pervasive Software\MicroKernel Workstation Engine\Version 7]
[HKEY_LOCAL_MACHINE\Software\Pervasive Software\MicroKernel Workstation Engine\Version 7\Settings]
"Remote Sessions Enabled"="Yes"
"Max Files"=dword:00002710
"Max Handles"=dword:000186a0
"Balanced Trees"="NO"
"File Version"="0700"
"System Data"="YES"
"Max Databases"=dword:000003e8
"Logging"="NO"
"Cache Size"=dword:00002000
"Compression Buffer Size"=dword:00000005
"Extended Buffer Size"=dword:00000010
"Merge Sort Buffer Size"=dword:00000000
"Max Communication Buffer Size"=dword:0000003f
"Transaction Durability"="YES"
"Transaction Log Buffer Size"=dword:00000100
"Transaction Log File Size"=dword:00000200
"Systrans Bundle Limit"=dword:0000ffff
"Systrans Time Limit"=dword:00002710
"Max Clients"=dword:00002710
"Background Threads"=dword:00000004
"Wait-lock Timeout"=dword:0000000f
"Transaction Log Directory"="C:\\PVSW\\BIN\\MKDE\\LOG"
"DBNamesDirectory"="C:\\PVSW\\Bin\\MKDE"
"Trace"="NO"
"Trace File"="C:\\PVSW\\BIN\\MKDE.TRA"
"Trace Databuf Len"=dword:00000080
"Trace Keybuf Len"=dword:00000080
"Trace Ops"="ALL"
"Validate Request"="NO"
"System Cache"="YES"
"Preallocate"="NO"
"Minimal States"="YES"
"Minimal States Delay"=dword:0000001e
"Worker Threads"=dword:00000001
"Max Remote Communications Buffer Size"=dword:0000003f
"Remote Read Buffer Size"=dword:0000003c
"Max Remote Sessions"=dword:00000064
"Remote Worker Threads"=dword:00000010
"Supported protocols"=hex(7):54,43,50,2f,49,50,00
"Protocol Init Timeout"=dword:0000003c
"TCPIP Multi-Homed"="NO"
"Listen IP Address"="192.168.0.50"
"NetBIOS Port Number"=dword:00000042
"Home Directory"="C:\\PVSW\\BIN"
"Enable AutoReconnect"="NO"
"AutoReconnect Timeout"="180"
[HKEY_LOCAL_MACHINE\Software\Pervasive Software\Communications Requester]
[HKEY_LOCAL_MACHINE\Software\Pervasive Software\Communications Requester\Version 7]
[HKEY_LOCAL_MACHINE\Software\Pervasive Software\Communications Requester\Version 7\Settings]
"TCP connect timeout"=dword:0000000f
"Supported protocols"="TCPIP"
"Runtime server"="Yes"
"Enable AutoReconnect"="No"
[HKEY_LOCAL_MACHINE\Software\Pervasive Software\Microkernel Router]
[HKEY_LOCAL_MACHINE\Software\Pervasive Software\Microkernel Router\Version 7]
[HKEY_LOCAL_MACHINE\Software\Pervasive Software\Microkernel Router\Version 7\Settings]
"Local"="yes"
"Requester"="yes"
"Use IDS"="yes"
"IDS Username"="<None>"
"IDS Password"="<None>"
"Compress IDS Data"="no"
"Load Retries"=dword:00000005
"Target Engine"=dword:00000001
[HKEY_LOCAL_MACHINE\Software\Pervasive Software\Database Names]
[HKEY_LOCAL_MACHINE\Software\Pervasive Software\Database Names\Version 4.00]
[HKEY_LOCAL_MACHINE\Software\Pervasive Software\Database Names\Version 4.00\Settings]
"DBNamesDirectory"="C:\\PVSW\\Bin\\MKDE"
[HKEY_LOCAL_MACHINE\Software\Pervasive Software\SQL Connection Manager]
[HKEY_LOCAL_MACHINE\Software\Pervasive Software\SQL Connection Manager\SERVER.INI]
[HKEY_LOCAL_MACHINE\Software\Pervasive Software\SQL Connection Manager\SERVER.INI\Processes]
"W3ODBCEI"="2001"
[HKEY_LOCAL_MACHINE\Software\Pervasive Software\SQL Connection Manager\SERVER.INI\SQLManager]
"LogEvent"="1"
"MgrPort"="1583"
"MgrSPXPort"="29320"
"MgrUseTransport"="TCP"
"MgrMaxConnections"="2001"
Does this reveals any clue if no then I will inform your other queries.
Other answers:
--->Did the TCP/IP test run quite smoothly (i.e. the count didn't stop and start or pause at all?) let it run beyond 75, a couple of thousand perhaps
Sent = 2556, received = 2512 , 44(1% loss)
Minimum = 0, Max=164ms, Average = 0
Please note that request time out occurs when I start Maximizer. And some times it pauses. The max time occurred during maximizer start.
---->If TCP/IP runs ok try going to the Pervasive Control Centre and changing both Server and Client Communications Protocols to TCP/IP only at both ends.
Both ends are already TCP/IP
See how this goes.
When i asked about the each machine wondering if they had the correct details i was enquiring about Routing and Name Resolution
What else does this machine do?
Is this the only server or do you have others?
We have two servers. Both are NT
If it is the only one, how many clients do you have?
40 clients
I assume it has 2Gb of Ram not 2Mb
IT Is 2 GB
The (SO_Linger) error in the SmartScout can be ignored, and the rest doesn't to reveal much.
If the total load on the server is only 4% then i would suspect a Protocol issue, but if this is a Primary Domain Controller with lots of clients then 4% is quite low.
Regards
--->Did the TCP/IP test run quite smoothly (i.e. the count didn't stop and start or pause at all?) let it run beyond 75, a couple of thousand perhaps
Sent = 2556, received = 2512 , 44(1% loss)
Minimum = 0, Max=164ms, Average = 0
Please note that request time out occurs when I start Maximizer. And some times it pauses. The max time occurred during maximizer start.
---->If TCP/IP runs ok try going to the Pervasive Control Centre and changing both Server and Client Communications Protocols to TCP/IP only at both ends.
Both ends are already TCP/IP
See how this goes.
When i asked about the each machine wondering if they had the correct details i was enquiring about Routing and Name Resolution
What else does this machine do?
Is this the only server or do you have others?
We have two servers. Both are NT
If it is the only one, how many clients do you have?
40 clients
I assume it has 2Gb of Ram not 2Mb
IT Is 2 GB
The (SO_Linger) error in the SmartScout can be ignored, and the rest doesn't to reveal much.
If the total load on the server is only 4% then i would suspect a Protocol issue, but if this is a Primary Domain Controller with lots of clients then 4% is quite low.
Regards
Right, haven't seen anything out of the ordinary yet.
Do any machines run any Virus software at all? (in particular Norton?)
Is this speed issue constant?
does it occur not just at peak office hours but 1 machine logged on in the evening when everyone else has gone home?
how about switching how the data is accessed by going to File>New address book and creating 3 different ways of browsing to the same data like so;
\\192.168.0.50\MxData\MainData (i'll be most intrigued by the result of this one!)
or
\\ALRUQEENT\MxData\MainData
or map a drive to MxData to access like so
Z:\MainData
Which, if any, of these methods shows any improvement?
How about stopping and restarting the Pervasive Transactional and Relational Services on the server?
Other than a Maximizer server what else does this machine do?
Is it a PDC? DNS/WINS or DHCP machine?
Does it run any backups jobs during the day? (tape backups?)
Is it the Internet Gateway machine?
How many Network Cards does it have?
If you look at the performance moniter in the Task Manager does it run flat line or does it run constantly spiked (flat line and this is not a load on the server CPU problem)
One thing i forgot to ask, what Operating System are the clients and what is their performance like?
What is the speed of the Network Cards, 10 or 100Mb?
What colour are they flashing, Red or Green?
What are your Hubs doing, are any of them flashing a red light instead of a green one?
Is the cabling (CAT5) twisted anywhere?
Network cabling is not like Electrical cables
If it becomes twisted then your LAN starts to suffer.
How long is the cabling between Client and Server?
(including Hub, because Hubs don't boost signals)
If the CPU usage on the server doesn't reveal much then most people would test the TCP/IP Overhead and Throughput using the NETSTAT command in a DOS Prompt, but i prefer to use a little utility from AnalogX called NetStat Live, it produces a similar 'chart' type presentation of TCP/IP Overhead on the fly rather than a DOS Text layout.
When told that a Word document opens quickly from a server but why dosn't my Maximizer database, put simply a Word Document is one file, have you seen how many files make up a Maximizer database?
However, slow performance is not an issue with a Maximizer database its self or indeed the software, it runs extremely well on the vast majority of setups, but in this case we are trying to find out at what point in the Chain between Client and Server the process is falling over.
Regards
CABC Support
Do any machines run any Virus software at all? (in particular Norton?)
Is this speed issue constant?
does it occur not just at peak office hours but 1 machine logged on in the evening when everyone else has gone home?
how about switching how the data is accessed by going to File>New address book and creating 3 different ways of browsing to the same data like so;
\\192.168.0.50\MxData\MainData (i'll be most intrigued by the result of this one!)
or
\\ALRUQEENT\MxData\MainData
or map a drive to MxData to access like so
Z:\MainData
Which, if any, of these methods shows any improvement?
How about stopping and restarting the Pervasive Transactional and Relational Services on the server?
Other than a Maximizer server what else does this machine do?
Is it a PDC? DNS/WINS or DHCP machine?
Does it run any backups jobs during the day? (tape backups?)
Is it the Internet Gateway machine?
How many Network Cards does it have?
If you look at the performance moniter in the Task Manager does it run flat line or does it run constantly spiked (flat line and this is not a load on the server CPU problem)
One thing i forgot to ask, what Operating System are the clients and what is their performance like?
What is the speed of the Network Cards, 10 or 100Mb?
What colour are they flashing, Red or Green?
What are your Hubs doing, are any of them flashing a red light instead of a green one?
Is the cabling (CAT5) twisted anywhere?
Network cabling is not like Electrical cables
If it becomes twisted then your LAN starts to suffer.
How long is the cabling between Client and Server?
(including Hub, because Hubs don't boost signals)
If the CPU usage on the server doesn't reveal much then most people would test the TCP/IP Overhead and Throughput using the NETSTAT command in a DOS Prompt, but i prefer to use a little utility from AnalogX called NetStat Live, it produces a similar 'chart' type presentation of TCP/IP Overhead on the fly rather than a DOS Text layout.
When told that a Word document opens quickly from a server but why dosn't my Maximizer database, put simply a Word Document is one file, have you seen how many files make up a Maximizer database?
However, slow performance is not an issue with a Maximizer database its self or indeed the software, it runs extremely well on the vast majority of setups, but in this case we are trying to find out at what point in the Chain between Client and Server the process is falling over.
Regards
CABC Support
quote:
Originally posted by CABC Support:
Right, haven't seen anything out of the ordinary yet.
>>Do any machines run any Virus software at all? (in particular Norton?)
--Server and client have the anivirus software. But that is Mcafee not Norton Anti Virus.
>>Is this speed issue constant?
-- Yes
>>does it occur not just at peak office hours but 1 machine logged on in the evening when everyone else has gone home?
--It changes little bit depending on the load but that is not significant
how about switching how the data is accessed by going to File>New address book and creating 3 different ways of browsing to the same data like so;
\\192.168.0.50\MxData\MainData (i'll be most intrigued by the result of this one!)
or
\\ALRUQEENT\MxData\MainData
or map a drive to MxData to access like so
Z:\MainData
Which, if any, of these methods shows any improvement?
-- Not significant
How about stopping and restarting the Pervasive Transactional and Relational Services on the server?
--- Same
Other than a Maximizer server what else does this machine do?
-- Some cliupper and Microsoft access and Sybase based software.
Is it a PDC? DNS/WINS or DHCP machine?
-- PDC ; DNS/WINS
Does it run any backups jobs during the day? (tape backups?)
--- NO
Is it the Internet Gateway machine?
--- NO
How many Network Cards does it have?
-- One
If you look at the performance moniter in the Task Manager does it run flat line or does it run constantly spiked (flat line and this is not a load on the server CPU problem)
-- CPU usage history little spiked ; Some times sharp rises. Memoru usage history always constant
One thing i forgot to ask, what Operating System are the clients and what is their performance like?
- Windows 98 with at least pentium 2
What is the speed of the Network Cards, 10 or 100Mb?
-- 100 MB
What colour are they flashing, Red or Green?
-- Green
What are your Hubs doing, are any of them flashing a red light instead of a green one?
-- Always green but collission is there
Is the cabling (CAT5) twisted anywhere?
Network cabling is not like Electrical cables
If it becomes twisted then your LAN starts to suffer.
-- Not sure
How long is the cabling between Client and Server?
(including Hub, because Hubs don't boost signals)
-- 30/40 meter
If the CPU usage on the server doesn't reveal much then most people would test the TCP/IP Overhead and Throughput using the NETSTAT command in a DOS Prompt, but i prefer to use a little utility from http://www.analogx.com called NetStat Live, it produces a similar 'chart' type presentation of TCP/IP Overhead on the fly rather than a DOS Text layout.
When told that a Word document opens quickly from a server but why dosn't my Maximizer database, put simply a Word Document is one file, have you seen how many files make up a Maximizer database?
However, slow performance is not an issue with a Maximizer database its self or indeed the software, it runs extremely well on the vast majority of setups, but in this case we are trying to find out at what point in the Chain between Client and Server the process is falling over.
Regards
CABC Support