![]() ![]() ![]() To allow further tuning SqlPackage’s behavior in these cases, the command line properties “RebuildIndexesOfflineForDataPhase” and “DisableIndexesForDataPhase” were added to the Import action in SqlPackage 18.7. If you are looking to better understand the SqlPackage operations for troubleshooting or performance improvements, there are some essential steps to capture more information. Enabling a diagnostics file with the parameter “/DiagnosticsFile:” is fundamental and in the latest SqlPackage release the version and architecture were standardized at the top of the file to assist in troubleshooting version differences. ![]() Trace data including timestamps for performance can be included by setting an environment variable “DACFX_PERF_TRACE” to true. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |