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

Chevy Mark Sunderland 61 Reputation points

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,


Not Monitored
Not Monitored
Tag not monitored by Microsoft.
26,999 questions
0 comments No comments
{count} votes

0 additional answers

Sort by: Most helpful