Freitag, 15. März 2013 10:01I have generated a SQL profiler trace for a database during sequence of actions. How to get statistics from this generated .trc file.
Montag, 18. März 2013 06:09What 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
Montag, 18. März 2013 06:40ModeratorHi 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
- Als Antwort markiert Eileen ZhaoMicrosoft Contingent Staff, Moderator Freitag, 22. März 2013 06:34