New answers tagged database-tuning
Got some feedback on this question from this Postgres listserv, so thought I'd share it here: Jeff: I'd go with a small shared_buffers, like 128MB, and let the OS cache as much as possible. This minimizes the amount of double buffering. And set work_mem to about 6GB, then bump it up if that doesn't seem to cause problems. In the scenario you ...
As per KB 2728419 You have to install atleast SQL Server 2012 + SP1 + CU1. On a sidenote, CU8 is out as well which is the latest one for SQL Server 2012 SP1. Also, you need to be a member of SYSADMIN role. DB_OWNER wont work as per the above KB.
Top 50 recent answers are included