Hi,

We got an application which is developed with asp.net 2.0. We got nearly 4000 users. Problem starts with timeout messages. When we lookup the sql server. The sqlserver.exe process allocates 3.7 gb of ram and uses %100 of cpu. The question is how to monitor which query or view or sp causes this.

Any helps welcome..

OMER OZULKU