Dear all,

We have problem with SQL Server Profiler, running on machine with WinNT 4.0
Ent Ed SP6a, SQL Server 7.0 Ent Ed, SP2. Until just recently it was working
without any problems. The only thing we changed in meantime is "sa"
password, witch does not seem to have anything to do with Profiler.

In Event Viewer there are 20+ error messages every 30 sec:

Executable                               : C:\MSSQL7\binn\sqlservr.exe

Description                             : Invalid_Pointer

Source                                     : ..\..\..\..\src\addtoq.c

Line                                         : 743



Executable                               : C:\MSSQL7\binn\sqlservr.exe

Description                             : Invalid_Pointer

Source                                     : ..\..\..\..\src\filters.c

Line                                         : 196



Executable                               : C:\MSSQL7\binn\sqlservr.exe

Description                             : Invalid_Pointer

Source                                     : ..\..\..\..\src\tokentst.c

Line                                         : 119



Executable                               : C:\MSSQL7\binn\sqlservr.exe

Description                             : Invalid_Pointer

Source                                     : ..\..\..\..\src\tokentst.c

Line                                         : 161






We are using a stored procedure. Main commands are following:

-- Create the trace queue

  EXEC xp_trace_addnewqueue 11000, 10000, 95, 90, @column_value,
@queue_handle output



  EXEC xp_trace_seteventclassrequired @Queue_Handle, 10, 1

  EXEC xp_trace_seteventclassrequired @Queue_Handle, 11, 1

  ...



  EXEC xp_trace_settextfilter @queue_handle, NULL, 'EXEC xp_trace%;SET
ANSI%...'

  EXEC xp_trace_setntnmfilter @Queue_Handle, N'User1;User2;User3', N''

  EXEC xp_trace_setappfilter @Queue_Handle, N'', N'SQL Profiler'

  EXEC xp_trace_setuserfilter @Queue_Handle, N'User4;User5;User6', N''





If we start the Profiler, using this procedure, the system becames extremly
slow and almost bloked. Processor usage goes up to 99%.



Any help would be appreciated.



Thank you in advance.



Best Regards,

Biljana

Help with SQL 2005 and Sourcesafe 6
SSIS and polling
Little Lock Symbols
SQL - Fast LOCALHOST , Slow IP
Database Tuning Advisor question (against sql server 2000 trace fi