Friday, March 15, 2013 10:01 AMI have generated a SQL profiler trace for a database during sequence of actions. How to get statistics from this generated .trc file.
Monday, March 18, 2013 6:09 AMWhat kind of statistics are you interested in? This may not be the right place for this question. Post your question in the T-SQL forum
Please vote as helpful or mark as answer, if it helps
Cheers, Raunak | t: @raunakjhawar | My Blog
Monday, March 18, 2013 6:40 AMModeratorHi Deepthi Kalyan,
Use SQL Server Profiler to view captured event data in a trace. SQL Server Profiler displays data based on defined trace properties. One way to analyze SQL Server data is to copy the data to another program, such as SQL Server or Database Engine Tuning Advisor. Database Engine Tuning Advisor can use a trace file that contains SQL batch and remote procedure call (RPC) events if the Text data column is included in the trace. To make sure that the correct events and columns are captured for use with Database Engine Tuning Advisor, use the predefined Tuning template that is supplied with SQL Server Profiler. Details please see: http://msdn.microsoft.com/en-us/library/ms175848.aspx
TechNet Community Support
- Marked As Answer by Eileen ZhaoMicrosoft Contingent Staff, Moderator Friday, March 22, 2013 6:34 AM