SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


The Dedicated Administrator Connection


The Dedicated Administrator Connection

Author
Message
Wayne-153714
Wayne-153714
SSC Veteran
SSC Veteran (240 reputation)SSC Veteran (240 reputation)SSC Veteran (240 reputation)SSC Veteran (240 reputation)SSC Veteran (240 reputation)SSC Veteran (240 reputation)SSC Veteran (240 reputation)SSC Veteran (240 reputation)

Group: General Forum Members
Points: 240 Visits: 91
Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/WFillis/2786.asp


When in doubt - test, test, test!

Wayne

philcart
philcart
SSCarpal Tunnel
SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)

Group: General Forum Members
Points: 4344 Visits: 1436

What do you do when you can't connect using the DAC ??

We had a problem on a clients server recently and the CPU was flatlining. We could tell from Task Manager that SQL was the process consuming the CPU. Connecting to SQL using SQLCMD or Management Studio resulted in a rude timeout error.

As we couldn't connect to the server, we couldn't do any diagnosis to determine the reason for the flatline.



Hope this helps
Phill Carter
--------------------
Colt 45 - the original point and click interface

Australian SQL Server User Groups - My profile
Phills Philosophies
Murrumbeena Cricket Club
Wayne-153714
Wayne-153714
SSC Veteran
SSC Veteran (240 reputation)SSC Veteran (240 reputation)SSC Veteran (240 reputation)SSC Veteran (240 reputation)SSC Veteran (240 reputation)SSC Veteran (240 reputation)SSC Veteran (240 reputation)SSC Veteran (240 reputation)

Group: General Forum Members
Points: 240 Visits: 91
If you can't connect remotly, or via DAC then try locally on the server itself. If you still can't connect the only thing I can think of is to restart the SQL instance.

Check your recompiles - use perfmon, under SQL Server: Statistics take a look at Batch Requests, Compilations and Recompilations. Compiling takes CPU, which unavoidable. Recompilations are a problem - if you are using embedded SQL try switching to stored procedures.

Analyse master.dbo.syscacheobjects to see if objects are being dropped from the procedure cache due to memory contention.

Also run profiler, and trace recompilations to see what code is causing recompilations (if you think that is causing your CPU).

Another possibility for high CPU is corrupted software and drivers. I know the guys here had an old version of a Java ODBC (JDBC?) driver that caused CPU to spike. A upgrade fixed the problem. Check google.


When in doubt - test, test, test!

Wayne

Susan Van Eyck
Susan Van Eyck
Mr or Mrs. 500
Mr or Mrs. 500 (535 reputation)Mr or Mrs. 500 (535 reputation)Mr or Mrs. 500 (535 reputation)Mr or Mrs. 500 (535 reputation)Mr or Mrs. 500 (535 reputation)Mr or Mrs. 500 (535 reputation)Mr or Mrs. 500 (535 reputation)Mr or Mrs. 500 (535 reputation)

Group: General Forum Members
Points: 535 Visits: 337
DAC is available in Express, it's just disabled by default.

http://blogs.msdn.com/sqlexpress/archive/2005/09/08/462609.aspx

Steps to enable DAC in Express:
1) Launch Services Applet in Control Panel
2) Stop SQL Server Express Service
3) Launch Properties dialog of SQL Server Express Service
4) Add "-T7806" to the startup parameters
5) Start the SQL Server Express service
Steve Jones
Steve Jones
SSC Guru
SSC Guru (65K reputation)SSC Guru (65K reputation)SSC Guru (65K reputation)SSC Guru (65K reputation)SSC Guru (65K reputation)SSC Guru (65K reputation)SSC Guru (65K reputation)SSC Guru (65K reputation)

Group: Administrators
Points: 65287 Visits: 19118
Phil,

If you can't connect, I'd contact MS immediately. You could try running SQLDiag, but that might fail as well.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Nick Miller-399759
Nick Miller-399759
Forum Newbie
Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)

Group: General Forum Members
Points: 7 Visits: 1

Does anyone know if the DAC works or can be enabled in SQL 2005 Developer Edition?

I've tried enabling Remote DAC and -T7806. SQLCMD reports "Sqlcmd: '-A': Unexpected argument." and Management Studio simply reports reports "Dedicated administrator connections are not supported. (Object Explorer)".

I didn't know if there might be a way to enable it.


Wayne-153714
Wayne-153714
SSC Veteran
SSC Veteran (240 reputation)SSC Veteran (240 reputation)SSC Veteran (240 reputation)SSC Veteran (240 reputation)SSC Veteran (240 reputation)SSC Veteran (240 reputation)SSC Veteran (240 reputation)SSC Veteran (240 reputation)

Group: General Forum Members
Points: 240 Visits: 91
You can't use DAC with Object Explorer in SSMS. You can only use a query window with DAC in Management Studio.

Try running SQLCMD locally.

Are you specifying servername when you run SQLCMD?


When in doubt - test, test, test!

Wayne

Sundar-242319
Sundar-242319
Forum Newbie
Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)

Group: General Forum Members
Points: 7 Visits: 41
Thanks SSC-Enthusiastic.

In SSMS instead of connecting to database engine directly select the new query and connect as admin:server and it connects to master in query mode.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search