running Pervasive SQL V8 on a win 2003 Server for a third party commercial applicaiton. The problem were having is sometimes all aplication on the clients hang. During this time CPU at 99% on NTDBSMGR.EXE and I restart the server to resolve the problem.


What sould I do,to resolve this problem.
some log in pvsw.log is ..
03-26-2004 12:14:31 NTMKDE 00000634 NTDBSMGR.EXE DIALOG2 W The file C:\D7000\D7K\@BM2004\CARI00C.DAT is rolling back.
03-26-2004 12:14:32 NTMKDE 00000634 NTDBSMGR.EXE DIALOG2 W The file C:\D7000\D7K\@BM2004\CARI10T.DAT is rolling back.
03-26-2004 12:14:59 NTMKDE 00000634 NTDBSMGR.EXE DIALOG2 W The file C:\D7000\D7K\@BM2004\CRHDSTN.DAT is rolling back.
03-26-2004 12:17:00 NTMKDE 00000634 NTDBSMGR.EXE DIALOG2 W The file C:\D7000\D7K\@BM2004\STOK29T.DAT is rolling back.
03-26-2004 12:18:11 NTMKDE 00000634 NTDBSMGR.EXE DIALOG2 W The file C:\D7000\D7K\@BM2004\STOK74T.DAT is rolling back.
03-26-2004 12:58:14 NTMKDE 000005C0 NTDBSMGR.EXE DIALOG2 W Resources allocated
03-27-2004 09:56:51 NTMKDE 000005C4 NTDBSMGR.EXE DIALOG2 W Resources allocated
03-29-2004 10:02:08 NTMKDE 00000554 NTDBSMGR.EXE DIALOG2

Are you using Pervasive.SQL V8 SP1? If not, you should update. When the engine jumps to 99% CPU utilization, are you running any ODBC/SQL queries? If so, you're probably running an unoptimized query.

I have installed Pervasive.SQL V8 Security Feature Pack (8.5) yesterday to resolve this problem. Should I install service pack1 ?

No. 8.5 was released after SP1. Did installing 8.5 solve the problem?

no ( any advice?

Open a support incident with Pervasive would be my next suggestion.

I turned of cache engine on each client 2 days ago. for 2 days no problem..

Did this fix the problem? The problem that I'm seeing has nearly identical symptoms - only it is 7.95 (2000i). NTDBSMGR goes wild and all other client activity essentially stops.