question

ChevyMarkSunderland-2816 avatar image
0 Votes"
ChevyMarkSunderland-2816 asked ·

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

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

not-supported
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

LeonLaude avatar image
0 Votes"
LeonLaude answered ·

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


· Share
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.