I have a production SharePoint system with about 100 databases, it just got really slow, users are complaining a lot.
When I run a query against sys.dm_io_virtual_file_stats
and sort by num_of_bytes_read
, one file has massively
more Reads than any other -- it shows 75 TB
! (yes, I double-checked!) It is SharedServices_Search_DB.mdf
, so I know exactly which file is causing the problems. The SAN guy says yes, that LUN is swamping the entire SAN with Read requests.
So how do I find out what application, or what process, or what procedure, or what service account is actually causing all these Reads?
Doing this type of performance analysis is my weakness.
Are there scripts I can run that will answer the question: This one file has a huge number of Reads, and those Reads are caused by X"?
Any help much appreciated!