Tag Info

New answers tagged

0

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 ...


2

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