4

Is it possible to Connect MS SQL Server 2012 Express Through DAC. After moving from SQL Server 2012 Enterprise to MS SQL Server 2012 Express, some performance problem were there. When i have checked out using this TSQL

select * from sys.dm_os_schedulers;

The schedular is not showing DAC (Dedicated administrator connections) scheduler ID.

Any idea or suggestion will be appreciate.

6

To use the DAC in Express, you need to enable startup trace flag 7806. This is documented here and in more detail here.

Open Configuration Manager, in your SQL Server Services pane right-click the Express instance and select Properties. On the Startup Parameters tab add -t7806, hit Add, then OK, and restart the service.

Startup Parameters Tab

You can check the error log or the DMVs after the restart to verify the DAC is enabled.

The reason this is disabled by default in SQL Server Express is for performance reasons (you're already limited to 1GB of memory, and DAC locks up a chunk of that). So, unless you are really sure you're going to need the DAC, it might be best to leave it off.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.