December 9, 2009 at 8:52 am
Must mean in relation to AWE or even possibly 64bit
see
though I note this is in the SQL 2000 forum, so note AWE is not dynamic for SQL2000 and available in enterprise edition only.
who knows?
---------------------------------------------------------------------
December 9, 2009 at 9:01 am
Krasavita (12/9/2009)
It is a lock page setting in memory,
If you mean the "Lock pages in memory" local security policy setting, then these may be of use
http://msdn.microsoft.com/en-us/library/ms187499.aspx
http://msdn.microsoft.com/en-us/library/aa198229%28SQL.80%29.aspx
If I turn on, it will increase our performance
Um, not necessarily. There's no single setting that, if enabled, always makes SQL faster. Think about it, if there was, why would it be an option and why would it ever be disabled?
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
December 9, 2009 at 9:41 am
Yes,Iwas told our LockPage setting in memory needs to be set to true, but wehere is it? Thank you
December 9, 2009 at 9:44 am
Pleae read the articles provided in the urls posted to this thread.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 9, 2009 at 9:54 am
Krasavita (12/9/2009)
Yes,Iwas told our LockPage setting in memory needs to be set to true, but wehere is it? Thank you
I'm assuming that you didn't bother to read the two links that I gave you, seeing as one of them is titled "How to enable the Lock Page in Memory option" and has a nice 7-step process to do exactly that.
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
December 9, 2009 at 10:33 am
GilaMonster (12/9/2009)
Krasavita (12/9/2009)
Yes,Iwas told our LockPage setting in memory needs to be set to true, but wehere is it? Thank youI'm assuming that you didn't bother to read the two links that I gave you, seeing as one of them is titled "How to enable the Lock Page in Memory option" and has a nice 7-step process to do exactly that.
Or the link I provided to the BOL entry on the same topic...
I give.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 9, 2009 at 11:06 am
Thank you for the articles
December 9, 2009 at 11:40 am
OR---and I'm just thinking off the top of my head here --- you could ask the person who told you about it in the first place, since we're all pretty much guessing at what you mean.
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
December 9, 2009 at 11:42 am
GSquared (12/9/2009)
Krasavita (12/9/2009)
I was told there is a switch on sql server that needs to be turn on to increase perfomance on sql serverYes. It's usually located on the front of the server box, with a sort of a circle with a line through part of it, on the switch. If it's turned off, the server won't run very well at all. Turning it on makes all the difference in the world.
That one takes too long, I like the manual switch connected to the cord. You know, the one with the prongs on it. If you wiggle it real hard, sometimes it even shoots out fireworks for you to let you know you're doing real good!
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
December 10, 2009 at 9:40 am
I read the articles,but I still would like to know if I check this option to true Lock pages in memory will this increase a perfomance? Also it is is recommend also setting max server memory, How do I know what is the max server memory will be? Thank you
December 10, 2009 at 9:58 am
Krasavita (12/10/2009)
I still would like to know if I check this option to true Lock pages in memory will this increase a perfomance?
Not necessarily. All it's going to do is stop the OS from paging SQL's memory out to disk. If that was happening then setting the option will help. If it wasn't then setting the option won't do anything.
It's also required for AWE memory which, since SQL 2000 has no x64 edition, you need to be using to access more than 2 GB of memory. (Enterprise edition only) Standard edition on SQL 2000 was limited to 2GB and ignored lock pages.
Also it is is recommend also setting max server memory, How do I know what is the max server memory will be?
Well, how much memory is on the server? Are there other apps on the server that SQL has to share the box with. General rule, total server memory - memory required for other apps - memory required for OS (roughly 1 GB per 4-8GB of memory on the server) = the maximum safe value for SQL's 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
December 10, 2009 at 10:18 am
I already have AWE check and I have Standard Edition.
It's also required for AWE memory which, since SQL 2000 has no x64 edition, you need to be using to access more than 2 GB of memory. (Enterprise edition only) Standard edition on SQL 2000 was limited to 2GB and ignored lock pages.
how much memory is on the server?
8163 (MB)
Are there other apps on the server that SQL has to share the box with.
How Can I check other apps on the server that SQL has to share the box with?
Thank you
December 10, 2009 at 10:27 am
I wonder would you ever use Google 😉
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
December 10, 2009 at 10:35 am
The best answer we could give you is: IT DEPENDS. Gail has explained it well. Now you will need to test the configs on a test server that is similar to your production server. Set those options according to the best results of your testing.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 10, 2009 at 10:37 am
Krasavita (12/10/2009)
I already have AWE check and I have Standard Edition.
If you have Standard edition of SQL 2000 then this entire conversation has been completely, 100%, totally useless.
Standard edition of SQL 2000 is limited to 2GB of memory (http://msdn.microsoft.com/en-us/library/aa933149%28SQL.80%29.aspx)
Standard edition of SQL 2000 cannot use AWE (http://msdn.microsoft.com/en-us/library/aa213764%28SQL.80%29.aspx)
Standard edition of SQL 2000 ignores lock pages in memory
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
Viewing 15 posts - 16 through 30 (of 38 total)
You must be logged in to reply to this topic. Login to reply