Maximizer client access is very very slow - Maximizer CRM Software

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

Posts: 498 | Location: PO Box 162,Newbury,Berks | Registered: January 03, 2000

Ignored post by CABC Support posted

Member

Posted

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.

Posts: 7 | Registered: January 13, 2003

Ignored post by z_monir posted

Posted

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

Posts: 498 | Location: PO Box 162,Newbury,Berks | Registered: January 03, 2000

Ignored post by CABC Support posted

Member

Posted

---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.]

Posts: 7 | Registered: January 13, 2003

Ignored post by z_monir posted

Gord

Master

Posted

SmartScout may prove helpful here as well.

Posts: 723 | Location: Canada | Registered: July 14, 2000

Ignored post by Gord posted

Member

Posted

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\" www.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.

Posts: 7 | Registered: January 13, 2003

Ignored post by z_monir posted

Posted

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

Posts: 498 | Location: PO Box 162,Newbury,Berks | Registered: January 03, 2000

Ignored post by CABC Support posted

Member

Posted

[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.

Posts: 7 | Registered: January 13, 2003

Ignored post by z_monir posted

Member

Posted

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

Posts: 7 | Registered: January 13, 2003

Ignored post by z_monir posted

Posted

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

Posts: 498 | Location: PO Box 162,Newbury,Berks | Registered: January 03, 2000

Ignored post by CABC Support posted

Member

Posted

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

Posts: 7 | Registered: January 13, 2003

Ignored post by z_monir posted