TempDB Database on Azure VM.

• satnam.singh 44358

  Ten Centuries

  Points: 1300

  More actions

  February 14, 2022 at 7:11 am

  #3983225

  We have a AlwaysOn Cluster configured on an Azure VM; wherein TempDB Database is hosted on the D drive of both the Nodes. As far as what we Understand; D drive is a Temporary drive; Can we have a New drive on both the Nodes with configuration as follows:-

  P30; 5000 IOPS; 200 MB/SEC

  Put the TempDB Database onto this New drive on both the Nodes.

  Kindly advise.

• Johan Bijnens

  SSC Guru

  Points: 135447

  More actions

  February 14, 2022 at 7:23 am

  #3983228

  check: "Checklist: Best practices for SQL Server on Azure VMs"

  Johan
  
  Learn to play, play to learn !

  Dont drive faster than your guardian angel can fly ...
  but keeping both feet on the ground wont get you anywhere :w00t:

  - How to post Performance Problems
  - How to post data/code to get the best help[/url]

  - How to prevent a sore throat after hours of presenting ppt

  press F1 for solution, press shift+F1 for urgent solution

  Need a bit of Powershell? How about this

  Who am I ? Sometimes this is me but most of the time this is me