Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nhuanlieu
Starting Member
27 Posts |
 Posted - 2008-04-04 : 18:22:35
|
| Hi, I'm using SQL2005 v9.00.3042.00 (SP2) on Windows 2003. I have a situation, when I turn on and begin to trace a database using the "SQL server Profiler", that particular VB application that uses the databases freezes (hourglass) when user click on anywhere that require a data query (download list, etc.) until I either pause or stop the trace, what gives? Thanks in advance. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-04-04 : 18:47:56
|
| This is why it is highly recommended to trace the data to a file and not directly to a table. You will see a huge performance improvement. It is also recommended that you run SQL Profiler from a client machine and not on the actual database server.You can query the trace file while the data is being collected via fn_trace_gettable.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-04-05 : 03:15:27
|
| Also , you can manage traces via t-sql code , rather then using the Profiler app.Collect only data you requireJack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
|
|
|
|
|
|
SQL server Profiler freezes application?