August 31, 2018 at 9:07 am
We are evaluating SQL managed instance
I used tutorial bellow to build managed instance and build client machine to manage it
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-managed-instance-get-started
"Since SQL Managed Instance is placed in your private Virtual Network, you need to create an Azure VM with some installed SQL client tool like SQL Server Management Studio or SQL Operations Studio to connect to the Managed Instance and execute queries."
to my surprise when tools installed on Azure VM , I found that also has SQL Profiler (SQL Server Profiler 14.0.17277.0)
I read that is was deprecated
https://docs.microsoft.com/en-us/sql/tools/sql-server-profiler/sql-server-profiler?view=sql-server-2017
does it mean it will be not used when MS will create SQL 2018 or SQL 2019?
September 3, 2018 at 3:14 am
Profiler has been deprecated for a long time. However, there is no indication that it will be removed from the product any time soon. That said, don't use it. Extended Events are superior in every possible manner. Use them instead.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply