View Single Post
  #1 (permalink)  
Old January 28th, 2011, 04:07 AM
Dirk.Hondong Dirk.Hondong is offline
Registered User
Join Date: Aug 2010
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Server-Side SQL Trace

Hello all,

I tried to analyse a process ouf our merchandise management system with the help of the modified PerfStatsScripts which are provided through this site.
I used the SQLDiagPerfStats_SQLNexus.XML. I know that a lot of data is gathered then.
My problem is that the process (or better the app initiating the process) I want to analyse times out when SQL:StmtStarting and SQL:StmtCompleted are gathered as well.
But I am interested in these data among the other.
So, how can I tweek the SQL Trace (or maybe provide additional Ressources to the VM hosting the SQL Server) to get all necessary information for SQLNexus to analyse. I need to take a look at Unique Statements Report. Unique Batches do not provide enough inofrmation in this case.