System Registry Entry for SystemCacheDirtyPageThreshold

[Ovatvvon]

Hello all,

The problem
We have 3 servers that we transfer a 50 GB database between daily. With new servers we just implemented to replace the old ones, we've been having some issues where memory drops to nothing, and people cannot even login. I found others on the internet having similar issues (i.e.

http://sqlblogcasts.com/blogs/tonyr...it-sql-server-2005-lock-pages-in-memory.aspx)

Possible solution using a Microsoft reference
That article pointed me to

http://support.microsoft.com/kb/920739,

which I think may help a lot. In here, it talks about making a registry change to alter SystemCacheDirtyPageThreshold so that it will handle data in groups more than 500 MB. I'm thinking about raising it to 1,024 MB.

Question:
In the article, it says 0x20 = 32 MB. If I want to enter 1 GB (i.e. 1,024 MB), I've calculated this to be a Hex value of 0x400. Can anyone else confirm if 0x400 is the correct value for 1 GB?





-Ovatvvon :-Q

 

[Ovatvvon]

Nevermind, I was able to confirm it right within the Registry.

Thanks anyway.

-Ovatvvon :-Q

 

[itsp1965]

To always make sure, you can use the Windows Calculator in Scientific mode which would give you the result you have indicated.