Topic: How to define who it is guilty in basis reading for the speed 2GB/sek?
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?