F
F
fan92rus2020-06-26 12:40:25
Entity Framework
fan92rus, 2020-06-26 12:40:25

Ms SQL server load is jumping. where to look?

I looked in the profiler (they load the usual selects). (but the point is if you reboot the machine then (30-40k of the same pass the norms). just after a while the load jumps.)

Answer the question

In order to leave comments, you need to log in

4 answer(s)
F
fan92rus, 2020-07-14
@fan92rus

I believed the Profiler and Pushka. there was the norm.
Solved by adding RAM...

K
Konstantin Tsvetkov, 2020-06-26
@tsklab

Use server performance reports.
There's a gun too: Database Engine Tuning Assistant

A
Alex Chistyakov, 2014-10-06
@alexclear

> Buy a VPS in Europe and set up OpenVPN on it?
It is not clear what you have been waiting for all this time?
I did this many years ago. OpenVPN on a server in Europe (and another on a server in the US) on port 443/tcp.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question