1
kudos
spam Kudos Remove

SQL Server do not use PROFILER, use Server side trace to upload to table!
published 540 days, 22 hours, 14 minutes ago posted by sasa 549 days, 23 hours, 6 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