0

I have a Table in SQL DB which I know it has a very large number of WRITES into it per day, at the same time our Database often timeout due to insufficient amount of Memory and CPU (it's called DTU, in Azure terminology)

I am wondering how much CPU, Memory can our DB saves if this table were to be completely dropped? Is there a way to calculate the cost of all READS/WRITES agains a specific table in SQL Server?

Benjamin
  • 231
  • 4
  • 8
  • "insufficient amount of Memory and CPU" - This likely is not really related to the high number of writes to the table. But what can be related to the timeouts is excessive locking / blocking because the table is being constantly written to (but then it's not an issue with Memory or CPU consumption). – J.D. Aug 25 '22 at 13:58
  • 1
    Does this answer your question? LOG_RATE_GOVERNOR Wait Stat --- Write-heavy tables tend to hit the log rate governor, as transaction log IO is one of the components that makes up a DTU. – AMtwo Aug 25 '22 at 14:11
  • @AMtwo Nice, you're probably right that in his case the DTU limit he's running into is due to I/O consumption (whether it be data, log, or the combination of both). – J.D. Aug 25 '22 at 14:27
  • Query Store will help you aggregate resource consumption by query, and from there you could probably figure it out. https://learn.microsoft.com/en-us/sql/relational-databases/performance/monitoring-performance-by-using-the-query-store?view=sql-server-ver16 – David Browne - Microsoft Aug 27 '22 at 20:10

0 Answers0