ApexSQL Profile
General
|
How can I make sure that ApexSQL Profile is installed?
|
When the product is installed, ApexSQL Profile menu is shown in the SQL Server Management Studio main menu
|
|
I have multiple SQL Server versions. Can the add-in run on all of them?
|
Yes. During the installation select the SQL Server Management Studio versions you want to use ApexSQL Profile with
|
|
Does ApexSQL Profile support SQL Server 2000?
|
|
|
Can I use ApexSQL Profile on a remote SQL Server?
|
Yes. Just make sure that security has been properly configured. Learn more on how to configure security in ApexSQL Profile Troubleshooting section
Profiling
|
|
What types of objects can be profiled with ApexSQL Profile?
|
ApexSQL Profile can be used to profile stored procedures and user-defined functions
|
|
Where can I see how long did it take for each SQL statement to execute and what variables were changed in the process?
|
Information on the execution time as well as on all parameter and variable changes is located in the Variable/Parameter History tab of the Profiling report
|
|
Where can I find the profiling commands in SQL Server Management Studio?
|
Right-click on a function or a stored procedure in SQL Server Management Studio Object Explorer and select ApexSQL Profile
|
|
Can I use default values for parameters? Do I have to input each value manually?
|
Yes. Select the Use default checkbox next to the appropriate parameter
|
|
Can I export the profiling results to a file?
|
Yes. The results can be saved to an Excel or a PDF file using the “Lazy profiling” report export options