Memory Issue - Any help would be greatly appreciated!

Question

Memory Issue - Any help would be greatly appreciated!

Viewing 12 posts - 16 through 26 (of 26 total)

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

sjimmo SSChampion Points: 11139 More actions · Answer 1

Gila
thread stack, backup buffers, CLR, in-process linked server drivers and a couple other things

Question - wouldn't these all show as an external process to windows?

Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan

slanky2 SSChasing Mays Points: 640 More actions · Answer 2

I am using Idera SQL Diagnostics Manager to monitor the server and can see that SQL never uses the full amount allocated to it, but it does appear to use memory outside of what was allocated to it, to the point where all available physical RAM can be used during heavy lifting queries.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

sjimmo (8/11/2011)
Gila
thread stack, backup buffers, CLR, in-process linked server drivers and a couple other things
Question - wouldn't these all show as an external process to windows?

No. Those are all in-process to SQL Server.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

slanky2 SSChasing Mays Points: 640 More actions · Answer 4

Hi Gila,

Anymore suggestions? I'm stumped. Thanks for your help!

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 5

As I've said repeatedly, it's not the queries. The buffer pool (which includes the data cache, plan cache and memory grants for queries) is limited by the server max memory setting.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

slanky2 SSChasing Mays Points: 640 More actions · Answer 6

GilaMonster (8/11/2011)
As I've said repeatedly, it's not the queries. The buffer pool (which includes the data cache, plan cache and memory grants for queries) is limited by the server max memory setting.

Don't mean to sound thick. I totaly agree with you that it shouldn't exceed the maximum setting, it just appeared as though it was.

Does SSIS release memory quickly after use?

slanky2 SSChasing Mays Points: 640 More actions · Answer 7

Another question:

I have SQL Engine, SSIS, SSRS and SQLAgent all using the same domain account which has the lock pages in memory security setting. Is this good or bad to have this account used for all these services?

sjimmo SSChampion Points: 11139 More actions · Answer 8

Gail,

Thanks - still learning;-)

Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 9

If you have confirmed (not through task manager, it lies) that the memory is allocated to SQL, then it's in the non-paged area, the portion that is used for CLR, in-process linked server drivers, backup buffers, etc.

There is information on the net about that, I don't recall where offhend though.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

slanky2 SSChasing Mays Points: 640 More actions · Answer 10

slanky2 (8/11/2011)
Another question:
I have SQL Engine, SSIS, SSRS and SQLAgent all using the same domain account which has the lock pages in memory security setting. Is this good or bad to have this account used for all these services?

Hi Gila,

Could you answer this question for me please. Thank you for all your help.

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

http://support.microsoft.com/kb/321363

read this article

slanky2 SSChasing Mays Points: 640 More actions · Answer 12

Hi All,

Problem has been resolved. The problem was with the memory allocation by the VM host. Even though there is 8GB assigned to the server the limit was set to 4GB. This has now been changed and the server is now running as it should. Thanks all for your help and patience!