I have an ASP.net web application with a lot of user visits. I used NHibernate as my ORM (s SQL Server 2005 SP3) and it worked perfectly. However, for about two months now, my dedicated server has reached 100% CPU utilization. I found that 90% of this use belongs to SQLServr.exe, so I used the NHibernate profiler to find the problem.
I see this in the profiler trace results:
Audit Login
(Some Query Execution)
Audit Logout
When I look at the column "EventSubClass" and all login and logout have been combined!
What is the problem with these multiple inputs and outputs?
source
share