MichaelJasson (7/2/2009)
Yes this is on Vista. My TL took a decision to have this on Vista and not Microsoft sql server 2008 which we proposed. I was not able to convince him with facts. Do you have any doc which informs me that this should not be on Vista.
Vista is a client operating system. It's for workstation machines, not servers. It's neither designed nor optimised for server apps. That you're running Vista instead of a server OS is very likely a major cause of memory problems. Vista is a memory hog and it uses a lot of resources to look good for the user.
Microsoft SQL Server 2008 (SP1) - 10.0.2714.0 (X64) May 14 2009 16:08:52
There's no point in you adding the /3GB switch. It will have no effect since both the OS and SQL are 64 bit. /3GB is only used on 32 bit operating systems to allow apps to access 3GB of memory instead of 2GB.
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