Greetings SQL Gurus,
Has been experiencing performance issue and as of right now myguess is that it is at the SQL Server\Data tier that the issue is occuring at.
Microsoft Windows Server 2008 R2 Enterprise
Service Pack 1
Intel(R) Xeon(R) CPU E5504 @ 2.00 GHZ
4.00 GB of RAM
Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)
Oct 14 2005 00:33:37
Copyright (c) 1988-2005 Microsoft Corporation
Standard Edition on Windows NT 6.1 (Build 7601: Service Pack 1)
One thing I noticed is, when we look at Task Manager--> Processes tab --> Mem Usage column shows around 2,5Gb.
Is SQL Server is consuming more than it can use and causing poor performance issue?
Any comments\advise\input will greatly be appreciated.