Running DBCC commands on SQL Azure db

• vsamantha35

  SSChampion

  Points: 11529

  More actions

  December 9, 2017 at 9:52 pm

  #325013

  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

• sqlgrease

  SSC Journeyman

  Points: 84

  More actions

  December 15, 2017 at 9:12 am

  #1972312

  ALTER DATABASE SCOPED CONFIGURATION CLEAR PROCEDURE_CACHE;