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

Ivan Nikolaev 1 Reputation point
2021-09-23T17:11:47.32+00:00

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
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,605 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,242 questions

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Erland Sommarskog 100.8K Reputation points MVP
    2021-09-23T22:00:47.797+00:00

    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.

    0 comments
  2. Olaf Helper 40,576 Reputation points
    2021-09-24T05:36:01.133+00:00

    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.

    0 comments
  3. CarrinWu-MSFT 6,851 Reputation points
    2021-09-24T07:25:05.11+00:00

    Hi @Ivan Nikolaev ,

    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.

    0 comments