question

IvanNikolaev-7984 avatar image
0 Votes"
IvanNikolaev-7984 asked CarrinWu-MSFT commented

SQL Profiler and Extended Events - what are the requirements (specifically VS Subscription Pro or Enterprise)?

We currently have VS Enterprise subscription, but would like to downgrade to VS Professional subscription instead. It's quite a shift and therefore would like to make sure we do our due diligence before hand. One of the main questions from the Dev team is whether or not they'll be able to use SQL Profiler/Extended Events with VS Professional. I've confirmed with Visual Studio Subscriptions Team, that we'll be able to install SQL Server Enterprise 2016, 2017 or 2019 after we downgrade, but they were not able to confirm if we'll be able to continue to use Profiler/xEvents. Would SQL Server support be able to answer this question? Thank you in advance!

sql-server-generalsql-server-analysis-services
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @IvanNikolaev-7984, we have not get a reply from you. Could below answers help you? If yes, please do "Accept Answer". By doing so, it will benefit for community members who have this similar issue. Your contribution is highly appreciated. Thank you!

0 Votes 0 ·
ErlandSommarskog avatar image
0 Votes"
ErlandSommarskog answered

Eh? Profiler and Extended Events have nothing to do with Visual Studio. Those are features purely in SQL Server.

Disclaimer: there could be features in VS that leverage on X-Events or Trace that I am not familiar with. But in any case, you can use the plain features.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered

It's quite a shift

What for a shift? You are simply going to change the licensing model for Visual Studio = a tool; there is no shift. You get some more features in VS, that's all.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

CarrinWu-MSFT avatar image
0 Votes"
CarrinWu-MSFT answered

Hi @IvanNikolaev-7984,

Welcome to Microsoft Q&A!

Yes, Profiler and Extended Events both are SQL Server features. SQL Server Enterprise and Standard edition supported SQL Profiler and Extended events feature. For more information, please refer to Editions and supported features of SQL Server. And I just used SQL Server profiler from SSMS to trace SSAS before, not from Visual Studio. Or you would like to run SQL Server Profiler in different ways? I am not sure I had misunderstood your question or not, if yes, please feel free to let me know.


Best regards,
Carrin


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.