SQL Server 2005 Memory Usage - Windows Task Manager Mem Usage working set > 2 GB

Question

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.

System info:

Microsoft Windows Server 2008 R2 Enterprise
Service Pack 1
Intel(R) Xeon(R) CPU E5504 @ 2.00 GHZ
4.00 GB of RAM
64 bit

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.

Thank you,

Chevy

Answer 1

Hi,

Q&A currently supports the products listed in right-hand pane (more to be added later on)

You can reach the experts in the dedicated SQL Server forum over here:
https://social.technet.microsoft.com/Forums/en-US/home?category=sqlserver

(please don't forget to mark helpful replies as answer)

Best regards,
Leon