4 votesjrstern commented
There are three or four or five different Azure services that provide some sort of scheduling of things, but none is even as easy to use as SQL Agent - which is itself rather crude, as these things go. We want the ability to run a TSQL script directly. I understand there *is* already something more like SQL Agent already in alpha or beta test today, so I'm not going to waste a vote here. I've just started using Azure Web Jobs as a replacement, but I have to wrap everything in a little C# console app just to get it to run.
Thanks for your feedback here.
SQL Trace is one of our older SQL Server technologies that’s on the path for deprecation. XEvents is the modern replacement. I’d love to learn more about your scenario here. Please reach out to me. Query Store is another alternative.
SQL Trace/Profiler is still the gold standard for monitoring and performance tuning. XEvents is supposed to be the modern replacement and much more efficient than old-style tracing - but XEvents was about 50% completed in SQL 2008 and has been left that way since. It is also much more complex to use, and still very poorly documented or supported. It would be great if Azure could lead the way on providing 100% (or more!) of the old SQL Trace/Profiler functionality, based on XEvents, in a new, and easy to use format.
Query Store is not the same kind of thing, nor is the Plan Cache on which Query Store is based. However, it may be that technically (if I can speculate), a little extension of the Plan/Query store would be a *better* basis for a SQL Trace replacement, than is XEvents.