This post is part of the Hands On With the GP Power Tools (GPPT) – System Module series in which I am taking a hands on look at the varioues tools offered by GPPT.
In the last post, I gave an overview of the Manual Logging Mode and mentioned that the SQL Profile Tracing tool needs to be configured before it can be used.
There are recommend settings for the SQL Profile Tracing, which are configured as follows in this post.
The first step is to create a folder on a local drive of the SQL Server to store the traces as they are being produced:
I have created a folder called Dynamics Central and then a sub folder called SQL Profile Tracing as there are other files which will be shared with users.