Script to bifercate sql server eaten memory
-
In machine Sql server eaten 1 GB above memory .
I want to bifurcate it, means in sql server which component eaten how much memory.
SO is there any query or sys proc to find it?
-
I think that the word you want is "bifurcate". Even with the corrected spelling, most people are going to have to Google it to figure out what you mean. 😉
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font] -
I think I did that to my chin once when I was a kid...6 stitches if I remember correctly.
The Redneck DBA
-
Anyone can tell me?
I got some script to bifurcate memory as per database..
But is there any?
My Server eaten more than 1 GB?
Why more ?..How to identify memory eaten by server?
-
Heh. Sorry, I understood the question, but not the answer. 🙁
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font] -
Not sure if you've got the right wording there, but it does look impressive 😀
Basically, to bifurcate is to split. Not sure what you'd be wanting to split your memory for. Maybe you need to do some reading about the SQL Server Memory Architecture to understand why your server is using memory the way it is.
If splitting your memory is not want you want to do, then maybe try explaining your current situation and what you'd like to end up with.
eg: Server has 4GB ram, SQL has taken 3GB and 1GB is left. I want to have 2GB left over.
--------------------
Colt 45 - the original point and click interface
-
I assmued that he wanted "to split" memory in terms of figuring out how much is being used by each database.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font] -
In machine Sql server eaten 1 GB above memory.
I got some script to bifurcate memory as per database.
These statements sort of indicate to me that the OP doesn't understand how SQL Server uses memory.
I see a lot of these type of statements where people expect SQL Server to release the memory when its not doing anything. That ain't gonna happen until the OS screams for it. They load their 10GB database onto a server with 4GB of memory and are suddenly shocked when SQL chews up 3GB of memory and doesn't give it back.
--------------------
Colt 45 - the original point and click interface -
DBCC MEMORYSTATUS?? search online for documentation.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply