Re: Concurrent executions of "fn_trace_gettable" function are failing.

From: Narayana Vyas Kondreddi (answer_me_at_hotmail.com)
Date: 08/31/04 

Date: Tue, 31 Aug 2004 14:02:28 +0100

I haven't tested this myself, but definitely seems like a locking issue on
the file, and can see why that would be the case.

Can you load the file into one table first, and then use DTS to parallelly
copy that table to multiple locations? 

-- 
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Nilesh" <nilesh.oswal@gmail.com> wrote in message
news:%23rXnKvzjEHA.3664@TK2MSFTNGP12.phx.gbl...
Hi,
While executing
select * from fn_trace_gettable('C:\Program Files\Microsoft SQL
Server\MSSQL.10\MSSQL\DATA\log.trc', default);
query simulateneously from multiple clients, only one
of them succeeds and all others give the following error message:
File 'C:\Program Files\Microsoft SQL Server\MSSQL.10\MSSQL\DATA\log.trc'
either does not exist or is not a recognizable trace file. Or there was an
error opening the file.
Seems like the "fn_trace_gettable" function is locking the trace log file
internally during it's execution. I do not have any alternative other than
executing the query simulateously from multiple clients. Can anyone suggest
a workaround for this problem?
Thanks,
Nilesh

Relevant Pages

  • Concurrent executions of "fn_trace_gettable" function are failing.
    ... of them succeeds and all others give the following error message: ... executing the query simulateously from multiple clients. ...
    (microsoft.public.sqlserver.server)
  • Re: row vs page locking...
    ... There was a major rewrite of much of the core database engine code in SQL 7. ... SQL 7 and above do a great job of row-level locking. ...
    (microsoft.public.sqlserver.server)
  • Re: Concurrency issue - Best Practice wanted
    ... Handling Data Concurrency Using ADO.NET ... 1/ Transactions and 2/ using timestamps. ... >I have been using for learning SQL is Petkovic, SQL Server 2000, A ... >explaining locking. ...
    (microsoft.public.dotnet.languages.csharp)
  • RE: Web page not responding
    ... Thanks for the reply, although I dont think it is locking, as it can happen ... with only one active user on the system. ... Although I will try and ascertain what SQL is doing at the time of the ... > like a record locking problem during the update. ...
    (microsoft.public.dotnet.framework.aspnet)
  • row vs page locking...
    ... Somewhere on these newsgroups I recall reading that SQL Server 6 and prior ... used page locking and not row level ... RDMSs like Interbase have a versioning engine so it was built from the ...
    (microsoft.public.sqlserver.server)
Loading