In a follow up to my earlier post on TFS2010 and memory utilization on a VM (found here), I have applied the following setting to my SQL2008 instance and I’m restricting SQL to 1.5gb of RAM (out of 4gb). I feel this should be plenty for my small amount of usage.
EXEC sp_configure 'show advanced options', 1 RECONFIGURE WITH OVERRIDE /* set server to 1.5gb */ EXEC sp_configure 'max server memory (MB)', 1536 RECONFIGURE WITH OVERRIDE
After running the command (and replacing the value with whatever you decide to use), you can run a command to check the “config_value” and “run_value” to make sure it is actually using your settings.
EXEC sp_configure 'max server memory (MB)'
Seems to be working out alright right now, but I do have to run a perfmon on the I/O usage to see how much paging may be occurring during heavy hits, like setting up a new TFS project.
Figure this may be an option for those of you setting up TFS on a PC or machine without a ton of RAM available. And, in all reality, this is more of a SQLServer config issue than Team Foundation Server item.
If you’re a SQL2008 guru and I committed a major sin by making this change, drop me a note with some ideas, please. I know there is a resource governor in 2008, but my understanding is that it is only available on the Enterprise, Dev, and Eval versions. Since I’m running SQL2008 Standard Edition, I looked at other options.
Post a Comment