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 |
|
rbarlow
Starting Member
26 Posts |
 Posted - 2008-12-19 : 18:55:40
|
| I've ready about a problem with SQL Server 2005 64-bit where Windows pages out the working set of SQL causing huge performance problems. The solution is to add the SQL service account to the "Lock pages in memory" however it is unclear whether this is supported in the Standard Edition. I've read several posts about it only being supported in Enterprise but I noticed the KB (http://support.microsoft.com/kb/918483) has Standard included in the Applies To section.Is this something that has been fixed by a service pack or hotfix?Also, does this issue depend on whether Windows is Standard or Enterprise? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-19 : 22:45:16
|
quote:
Originally posted by rbarlow
I've ready about a problem with SQL Server 2005 64-bit where Windows pages out the working set of SQL causing huge performance problems. The solution is to add the SQL service account to the "Lock pages in memory" however it is unclear whether this is supported in the Standard Edition. I've read several posts about it only being supported in Enterprise but I noticed the KB (http://support.microsoft.com/kb/918483) has Standard included in the Applies To section.Is this something that has been fixed by a service pack or hotfix?Also, does this issue depend on whether Windows is Standard or Enterprise?
Like we said earlier, it is not supported in SQL standard 64-bit edition unless recent SP3 has something to do with it. You might need to contact microsoft for it. |
 |
|
|
|
|
|
SQL 2005 64-bit Standard