The reason I want to do that is that my application is running very slow. I want to allocate more memory to sql server because page reads/sec and page writes/sec are really havoc.
But we're talking a client OS. Doing this on a server that's dedicated to SQL is one thing, doing it on a client OS (especially one as memory-hungry as Vista) is something completely different.
Where is the SQL server that your app is using? One the Vista machine? If so, I recommend you move it to a proper server environment.
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass