SQL server is takes all memory

Question

SQL server is takes all memory

yuvipoy

SSChampion

Points: 10469
More actions
April 3, 2014 at 12:47 am

#289999

While inserting the data cpu usage goes high.
From the front end we are just inserting the data to the table. while inserting the memory taken by sql server is almost full,
Max config for memory is 2GB for sql in 4GB of RAM.
why SQL server is taking all memory.-
while running the insert query almost cpu reaches 80-90% every time why this is so?

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

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

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

By design, normal, documented behaviour. SQL will take all the memory it is allowed to use.

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

yuvipoy SSChampion Points: 10469 More actions · Answer 2

GilaMonster (4/3/2014)
By design, normal, documented behaviour. SQL will take all the memory it is allowed to use.

Thanks Gail for quick replay.

Then the Insert should be that much fast right if it is one transaction?

My question is if for the one transaction it utilise all memory then how about other queries it will be internally splitting the memory?

how the weightage of query? how sql will decide about each transactions weightage.

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

SQL manages its own memory very well. There's a hell of a lot to it. If you want the details, get a copy of "Troubleshooting SQL Server: A guide for the accidental DBA" and read chapter 4.

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

yuvipoy SSChampion Points: 10469 More actions · Answer 4

Thanks for that reference book, it is really nice.:-)