InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 06:56:30 GMT20http://www.sqlservercentral.com/Forums/Topic875825-392-1.aspxThanks a lot.Regards,JMSM ;-)Fri, 05 Mar 2010 02:40:57 GMTJMSMhttp://www.sqlservercentral.com/Forums/Topic875825-392-1.aspx[u][b]Questions: [/b][/u][b]1st[/b] How can i see what event is the one in the first raw as the procedure name appears [b]NULL[/b] [b]-- You can capture EventClass column (27) in your profiler[/b][b]2nd[/b] Am i doing the conversion to minutes well?I need to get all the info that was running more than a minute but i'm completely lost on how should i change the data used to minutes/seconds.:crying:[b]-- in SQL Server 2008, duration field stores microsecond. So, 1,000,000 = 1 second[/b][b]3rd[/b] I put @maxfilesize = 3000 in the profiler template (Aux-Profiler-Template.txt)I need to know if the file will be rewrited if the file growth to 3GB (@maxfilesize) before end time?[b]-- @maxfilesize = 3000 means a new trace file will be generated (automatically) when current trace file reached 3GB of size.[/b][b]4th[/b] Can i use any parameter that create a new file(s) when the maxfilesize will be at limit?[b]-- refer 3rd. you don't need to. file name will be appended will a running number.[/b][/quote]Fri, 05 Mar 2010 00:00:15 GMTLeo Leonghttp://www.sqlservercentral.com/Forums/Topic875825-392-1.aspxHello again,As i was reading in a fantástic link send by Gail Shaw, i put a profiler running to catch all the queries in a period o time but, now i've got more questions about it.I attach a file [b]Aux-Profiler.xlsx[/b] where i've inserted all the data that becomes from one *.trc file:[u][b]Questions: [/b][/u][b]1st[/b] How can i see what event is the one in the first raw as the procedure name appears [b]NULL[/b] [b]2nd[/b] Am i doing the conversion to minutes well?I need to get all the info that was running more than a minute but i'm completely lost on how should i change the data used to minutes/seconds.:crying:The only diference between what i've been doing and the fabulous link (http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/)is that when creating my table i change the field TextData from varchar(4000) to varchar(max)I send you to the file with all the steps (Aux-Profiler-Steps.txt)[b]3rd[/b] I put @maxfilesize = 3000 in the profiler template (Aux-Profiler-Template.txt)I need to know if the file will be rewrited if the file growth to 3GB (@maxfilesize) before end time?[b]4th[/b] Can i use any parameter that create a new file(s) when the maxfilesize will be at limit?Thanks and regards,JMSM ;-)Wed, 03 Mar 2010 04:40:41 GMTJMSM