1
kudos
spam Kudos Remove

SQL Server Performance series: Trace Flag 845 and Lock Pages in Memory
published 175 days, 7 hours, 36 minutes ago posted by sasa 178 days, 8 hours, 21 minutes ago
Tuesday, November 29, 2011 3:57:46 AM GMT Saturday, November 26, 2011 3:12:58 AM GMT
SQL Server Performance series: Trace Flag 845 and Lock Pages in Memory
A discussion about trace flags 845 lead to explain the information about the requirement and necessity in case of 32 bit and 64 bit environments. The Lock Pages in Memory has gained importance since version 2005 due to the fact that 32-bit and 64-bit environments are managed. As you may be aware it was only available in Enterprise and Developer editions, since CU4 for SQL Server 2005 SP3 and CU2 for SQL Server 2008 SP1 it is enabled as a trace flag 845 for Standard Edition environment too. Lock Pages...(read more)
category: News | clicked: 0 | | source: sqlserver-qa.net | show counter code
tags: benchmarking, Best Practices, configuration, cumulative update, lock down, lock pages in memory, performance monitoring, Security, SQL Server, Version

No comments yet, be the first one to post comment.

To post your comment please login or signup