In this video you will learn step by step process of starting SQL Server Profiler automatically after SQL Server services restart. It shows how to create a sample trace using SQL Server Profiler (GUI), how to export Trace settings to a file, how to provide trace location, how to create store procedure from the trace definition, how to execute store procedure to verfiy if trace is running on the SQL Server, how to Mark Store procedure to run at startup in SQL Server, how to enable store procedure startup scan in SQL Server Configuration and finally how to check if the settings are working after SQL Server restarts.
Blog post link for the video
http://sqlage.blogspot.com/2015/03/st...
Visit our website to check out SQL Server DBA Tutorial Step by Step
http://www.techbrothersit.com/2014/12...
On this page of the site you can watch the video online SQL DBA 134-Start SQL Server Profiler Trace Automatically After SQL Server Service Restart with a duration of hours minute second in good quality, which was uploaded by the user TechBrothersIT 29 March 2015, share the link with friends and acquaintances, this video has already been watched 14,053 times on youtube and it was liked by 50 viewers. Enjoy your viewing!