1

Topic: How to define who it is guilty in basis reading for the speed 2GB/sek?

All greetings!
A bit atypical situation, I ask the help. There is server SQL 2012R2.
Today on it there was a WILD reading of one basis.
In it there live approximately 400-450 persons.
At a normal mode of reading/record: 10/15 MB\S, today periodic peaks on reading on  minutes to 1,5-2 GB/sek
Whether it is possible to understand any tool what requests or something else give such loading on reading?

2

Re: How to define who it is guilty in basis reading for the speed 2GB/sek?

sys.dm_exec_requests

3

Re: How to define who it is guilty in basis reading for the speed 2GB/sek?

Did not help... There tens requests, but they do not create such loading.
And there is something that can to show real reading at level of tables and indexes?
That is how many the data from what table or an index is read?

4

Re: How to define who it is guilty in basis reading for the speed 2GB/sek?

ReaLord;
If users are not found out, the system does it.