Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
john.burns
Posting Yak Master
100 Posts |
 Posted - 2009-12-03 : 08:37:06
|
| Now that Lock Pages is available for STD edition in SP3CU4 I've installed this on a dev box and am currently testing.One of my many sql servers (ver 9.00.3054) is exhibiting strange memory behaviour (high pages/sec etc..under medium workload)Has anyone had any benefit with employing lock pages.. does this result in faster batch runtime executions for anyone??thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
john.burns
Posting Yak Master
100 Posts |
Posted - 2009-12-03 : 13:20:51
|
| Tara,I just ran a subset of our reporting flow (3 1/4 hrs) and came up with no runtime difference.Do you any evidence on performance gains in your environment??thanks |
 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-12-03 : 16:09:44
|
| Look at the perfmon counter Page Life Expectancy. that will show you a difference.By the way, depending on how large the dataset you're processing for your reporting, and how much physical RAM, you can still shuffle pages in and out of memory.We enable lock pages in memory on all of our servers too. |
|
|
|
john.burns
Posting Yak Master
100 Posts |
Posted - 2009-12-03 : 16:58:37
|
| Even if PLE measures are better... would'nt you expect better runtimes...by a sizeable percent? |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-12-03 : 17:13:12
|
| Not if you're plowing through more data than you have RAM |
|
|
|
john.burns
Posting Yak Master
100 Posts |
Posted - 2009-12-04 : 08:54:06
|
| Yes I am .. my bottleneck is IO ... I just thought that enhancing memory mgmt./capability would produce a net gain in runtimes. |
|
|
|
|
|
|
Lock Pages