Post reply

DBCC commands on Azure SQL Database

  • December 12, 2017 at 11:49 am

    #326933

    Hi All,

    For tuning poorly performing query on a Testing server or local SQL instance on a Laptopn, we used to run below 2 commands to free the plan cache and buffer cache to properly measure
    query performance. Now, I am getting an error on SQL Azure database that these command s are not supported. IF I want to do this, is there any alternative steps to clean buffers and clear plan cache?

    DBCC FREEPROCCACHE
    DBCC DROPCLEANBUFFERS

    Thanks,

    Sam

  • December 13, 2017 at 2:51 am

    #1971910

    I typed "sql azure freeproccache" into my favourite search engine, and I found this.  Does it help you?

    John

  • December 13, 2017 at 8:21 am

    #1971967

    I pointed you to this bit of documentation once before. I'd suggest reading all through it. It's going to help you quite a bit with Azure SQL Database.

    "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 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply