Too much reads to sys.schemas
We have in DB to many reads to the following query:
select sys.schemas.name 'TABLE_SCHEM', CASE WHEN sys.schemas.name IN ('dbo', 'guest','INFORMATION_SCHEMA','sys','db_owner', 'db_accessadmin', 'db_securityadmin', 'db_ddladmin' ,'db_backupoperator','db_datareader','db_datawriter','db_denydatareader','db_denydatawriter') THEN null ELSE DB_NAME() END 'TABLE_CATALOG' from sys.schemas order by 2, 1
1. What the meaning of this query?
2. Is that affect on YF performance?
3. Why it's status is sleeping?
4. Why it contains so much reads while sys.schemas contains only 16 rows?