1
kudos
spam Kudos Remove

SQL Server do not use PROFILER, use Server side trace to upload to table!
published 647 days, 13 hours, 4 minutes ago posted by sasa 656 days, 13 hours, 55 minutes ago
Sunday, August 15, 2010 4:28:29 PM GMT Friday, August 06, 2010 3:37:13 PM GMT
SQL Server do not use PROFILER, use Server side trace to upload to table!
As a followup questions from the post SQL Server Profiler: System is low on disk space on drive 'C'? here I had a feedback of how to save the server-side trace to a table? Well there is no direct path to do so, rather a roundabout method of once you have collected the trace using server-side method, open up the collect trace file in Profiler and click on File --> Save As --> Trace Table (see below): The reason it was disabled that I was already performing the Save-To-Table operation, as you...(read more)
category: News | clicked: 0 | | source: sqlserver-qa.net | show counter code
tags: benchmarking, Best Practices, DBA, disk space, server side, SQL Server, table, trace, XML

No comments yet, be the first one to post comment.

To post your comment please login or signup