Memory Issue

Question

Post reply

Memory Issue

clarification

Mr or Mrs. 500

Points: 558
More actions
August 8, 2011 at 11:42 pm

#241812

task manager showing sql server taking 9.88gb out of 10 gb memory? afraid of this. what are the steps and checks to be done?

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

muthukkumaran Kaliyamoorthy SSCoach Points: 19026 More actions · Answer 1

First check the perfmon and let us know what it's shows?

Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/

clarification Mr or Mrs. 500 Points: 558 More actions · Answer 2

clarification

Mr or Mrs. 500

Points: 558

August 9, 2011 at 12:02 am

#1365630

can u please guide me in how to use perf monitor

BuntyBoy SSCommitted Points: 1876 More actions · Answer 3

Today nly i was reading the below linked articles. I hope it will help you .

http://www.mssqltips.com/tip.asp?tip=2454

http://www.mssqltips.com/tip.asp?tip=1917

===========================================
Better try and fail than not to try at all...

Database Best Practices[/url]

SQL Server Best Practices[/url]

colin.Leversuch-Roberts SSC Guru Points: 52643 More actions · Answer 4

you should set the max memory to a figure you're happy with. The actual value would depend upon the o/s and the box but on an average server I generally set sql memory somewhere between 4 and 8 GB less than physical memory.

[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/

clarification Mr or Mrs. 500 Points: 558 More actions · Answer 5

old hand:thanks for ur information

in my server i can not select particular instance for per monitor counter