Has anyone ever seen this or know what might be causing it?
Diagnosing performance issues for a .NET app built with MVC 5, EF6, repository pattern, using Ninject, Automapper, AspNet Identity. It was built database-first and uses LINQ to Entities to call a SQL Server 2016 database.
The SQL Server logs show that in production, the following query is called an average of 70 times per second:
(@Table nvarchar(11)) SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = @Table
Not sure where the nvarchar(11) would come from, but could it be based off of a specific table with 11 characters, such as AspNetUsers or AspNetRoles?
Could this possibly be due to some hidden setting in IIS? Something dealing with connection pooling / keeping connections open?
Anyone have any ideas on this one? I'm totally at a loss...
UPDATE
Determined that this is being called from Asp.Net Identity or OWIN functionality. It is passing in 'AspNetUsers' as the table name, so for some reason it is constantly querying the database for column names in the AspNetUsers table.
Any ideas on what would cause this behaviour?