Dimitri Furman

My feedback

  1. 2 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
    Dimitri Furman shared this idea  · 
  2. 3 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
    Dimitri Furman commented  · 

    MAXTRANSFERSIZE is supported for backup to block blobs, for SQL Server 2016 and later.

  3. 1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  SQL Database  ·  Flag idea as inappropriate…  ·  Admin →
    Dimitri Furman commented  · 

    In terms of hardware resources, all replicas are identical. Currently, you can see resource utilization and other performance metrics (i.e. waits) on a Read Scale-out secondary if you connect to it in SSMS or another client specifying ApplicationIntent=ReadOnly, and then query corresponding DMVs, such as sys.dm_db_resource_stats and sys.dm_db_wait_stats.

  4. 4 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  SQL Managed Instance  ·  Flag idea as inappropriate…  ·  Admin →
    Dimitri Furman commented  · 

    Thanks for bringing this up. Could you please elaborate on what you are trying to achieve in more detail? Would the information provided by sys.server_principals and sys.server_permissions DMVs be sufficient, and if not, why?

  5. 225 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    7 comments  ·  SQL Database  ·  Flag idea as inappropriate…  ·  Admin →
    Dimitri Furman commented  · 

    SQL Trace and SQL Profiler are deprecated. Similar functionality is provided by Extended Events. Please see https://docs.microsoft.com/en-us/azure/sql-database/sql-database-xevent-db-diff-from-svr, and http://www.mssqlgirl.com/using-extended-events-on-azure-sql-database.html.

Feedback and Knowledge Base