MichaelJasson (7/2/2009)
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability