Comments
Sort by recent activity
Hi @JGoulet89, SQL prompt supports the following Azure platforms:
Azure SQL Database
SQL Server on Azure VM
Just doing some testing on this as well, which Provider are you using for the linked server? [image] [image] [image] [image] [image] [image] [image] [image] [image] [image] [image] [image] / comments
Hi @JGoulet89,SQL prompt supports the following Azure platforms:
Azure SQL Database
SQL Server on Azure VM
Just doing some testing on this as well, which Provider are you using for the linked server?
Hi @BenKim Thank you for your post. Are you able to clarify what it that you are trying to achieve in SQL Data Compare? If you only want to deploy the rows that exists in the Source rather than rows that exist in both but contain differences, then you are able to filter this at the bottom of the comparison window to show only rows that exist in the left (source DB). / comments
Hi @BenKim Thank you for your post. Are you able to clarify what it that you are trying to achieve in SQL Data Compare? If you only want to deploy the rows that exists in the Source rather than row...
Hi @pgouder, Thank you for your post. I'm afraid that it is not possible to clear alerts automatically. You can post this suggestion to our UserVoice forum though where other users can vote on features they'd like to see: https://sqlmonitor.uservoice.com/forums/91743-suggestions / comments
Hi @pgouder,Thank you for your post. I'm afraid that it is not possible to clear alerts automatically.You can post this suggestion to our UserVoice forum though where other users can vote on featur...
Hi @Severn, I'm afraid that SQL Monitor does not support that and will only monitor the primary. You can vote for this feature here on our User Voice: https://sqlmonitor.uservoice.com/forums/91743-suggestions/suggestions/37975072-suport-for-azure-sql-hyperscale / comments
Hi @Severn, I'm afraid that SQL Monitor does not support that and will only monitor the primary. You can vote for this feature here on our User Voice:https://sqlmonitor.uservoice.com/forums/91743-s...
Hi @pamsauto There is the possibility that SQL Server did not have the plan for us to sample. You can check by running this query on the target entity, filling in the plan handle with the one shown in the SQL Monitor UI: SELECT query_plan FROM sys.dm_exec_query_plan(planHandle)This is also why the recommendations can't load, because the query plan is used to provide the recommendations. / comments
Hi @pamsauto There is the possibility that SQL Server did not have the plan for us to sample. You can check by running this query on the target entity, filling in the plan handle with the one show...
Hi Klaus, Thank you for your post. Are you able to provide a reproduction of the issue that you're seeing so that we can reproduce this issue locally? Or alternatively, I can open a support ticket, and you could send over a copy of the backup that you were comparing? / comments
Hi Klaus,Thank you for your post.Are you able to provide a reproduction of the issue that you're seeing so that we can reproduce this issue locally? Or alternatively, I can open a support ticket, a...
Hi Mike, I'm afraid it isn't possible to see the exact date/time for the individual query execution or the login that it came from. Under the Current activity tab in Overviews, you can see the login for any queries currently running. / comments
Hi Mike,I'm afraid it isn't possible to see the exact date/time for the individual query execution or the login that it came from.Under the Current activity tab in Overviews, you can see the login ...
Hi Mike, From the top of the overview page you can select the time frame you want to view, you can also slide this window along the timeline and shrink or increase the window. Then, the top queries and top procedures shown will update to the ones that ran during the window you highlighted at the top. / comments
Hi Mike,From the top of the overview page you can select the time frame you want to view, you can also slide this window along the timeline and shrink or increase the window. Then, the top queries ...
Hi Ashlynn, I think it would be worth opening a ticket to investigate this issue further. I will open a support ticket and reach out to you through that. / comments
Hi Ashlynn,I think it would be worth opening a ticket to investigate this issue further. I will open a support ticket and reach out to you through that.
Hi Ashlynn, What changes in the config file? Is it the network location or the port number? Or both? I assume the existing config is deleted and replaced with the new one after the upgrade? And to confirm, the checkbox for "Keep existing Base Monitor" is checked? / comments
Hi Ashlynn,What changes in the config file? Is it the network location or the port number? Or both? I assume the existing config is deleted and replaced with the new one after the upgrade?And to co...