March 23, 2004 at 7:50 am
It causes all of our clients to disconnect from our middleware layer.
We were going after deadlock events only, and it brought the entire company down (350+ application users)
Is there any setting that decreases the load a trace places on the server?
This is not useable, what are we missing?
Thanks in advance,
Tim
March 23, 2004 at 8:23 am
SQL Profiler will run faster if you save the load to a .trc file, because it uses the same technology that sql uses to save to the log file.
Then you can import that file to a table to filter using fn_trace_gettable.
Try to filter as much as you can, and it is better to use a server side trace using trace stored procedures. You can create a trace search with profiler and then script it to t-SQL. Then with the script, you can execute the sp in the server without using the profiler GUI.
Check in bol for fn_trace* functions and sp_trace* stored procedures.
March 24, 2004 at 7:09 am
I've had the same experience in my shop, and am even banned from using Profiler now, which is unacceptable to me. I've searched Microsoft's website for any help, and can't find anything that may provide a clue as to why this has happened on occasion. The only thing that I found when this happened last time, was that there was another log entry in the Events Log on the db server that indicated someone else had started a Profiler session and it was running on the database server itself. I always run the Profiler from my pc and record the data to a file on my local drive. I was monitoring longest running sp's at the time (SQL Server 7.0 sp4). I'm not sure what the other trace was doing. The only thing that I've read about that might be an issue is that the event queue may get too full and may not capture all of the events to be recorded. But, I've never seen any statement that this could cause the server to hang. I mean, we can't even connect to the db at that point. If anyone could offer any type of information or experiences on this subject, I would be most grateful, as probably racosta. Thanks a million!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply