DBCC commands on Azure SQL Database

• vsamantha35

  SSChampion

  Points: 11551

  More actions

  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

• John Mitchell-245523

  SSC Guru

  Points: 148809

  More actions

  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

• Grant Fritchey

  SSC Guru

  Points: 399061

  More actions

  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