E
E
Eugene2016-11-06 23:05:32
Microsoft Azure
Eugene, 2016-11-06 23:05:32

SQL Server eats up money on Azhur - how to find the reason?

In Azure there is such an expense item:
Hours of computing - SQL Server Enterprise (up to 4 cores)
It has always had an expense in the region of 1000 r per month. At some point, it began to eat 2,500 per day (75,000 rubles per month). The virtual machine is rather weak (according to the tariff it costs about 7000 rubles per month).
Task Manager on the server shows CPU usage for the SQL Server process <..> 0-2%. The problem arose all at once, there was no smooth rise or peak.
The question is how to find what eats money?
UPDATE: We have been upgraded to a paid subscription and the Enterprise license now costs $1,000 per month regardless of load. That is, it was not the resource that ate money, but the license itself.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Alexander, 2016-11-07
@infeneon

I would start with performance monitoring, turn on the counters.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question