What is DCEXEC?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » What is DCEXEC?

What is DCEXEC?

Rate Topic

Display Mode

Topic Options

Author

Message

FreeHansje

Posted Monday, November 19, 2012 12:57 AM

SSC Eights!

Group: General Forum Members
Last Login: Thursday, December 06, 2012 8:30 AM
Points: 879, Visits: 810

As the question. It is used in an SQLAgent job. Googling links it to SSIS execution, but no explanation AFAI can find. Link with Data Collector, which tells me something, but not about this executable.
Any link to an overview on this exe? Something about which parameters can be used? How and why you would use it?

TIA,

Greetz,
Hans Brouwer

Post #1386191

Bhuvnesh

Posted Monday, November 19, 2012 1:30 AM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 8:41 AM
Points: 2,562, Visits: 3,451

i guess you are looking for this
http://msdn.microsoft.com/en-us/library/ms162810(v=sql.105).aspx

-------Bhuvnesh----------
While 1 = 1 (Learning SQL....)
Click to get fast response of your post

Post #1386201

FreeHansje

Posted Monday, November 19, 2012 2:29 AM

SSC Eights!

Group: General Forum Members
Last Login: Thursday, December 06, 2012 8:30 AM
Points: 879, Visits: 810

Tnx for answering, I don't know if this is what I am looking for. I can find a relation in BOL between Data Collection and this dcexec utility

I have this command string in a job step on a SQL2008R2 box:
dcexec -c -s 2 -i "MSSQLSERVER" -m 0 -e $(ESCAPE_NONE(STOPEVENT))

This is one of several, with slightly different commands, but all starting with dcexec.
It runs as a CMD command, so possibly I should not look for it in the SQL Server suite at all. BOL does not mention it as a stand-alone utility.

Greetz,
Hans Brouwer

Post #1386241

Joie Andrew

Posted Monday, November 19, 2012 3:47 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 7:00 AM
Points: 545, Visits: 1,019

DCEXEC is used for the Management Data Warehouse as a part of the collector sets that actually grabs performance metrics and pumps it to a management data warehouse for reporting.

Unfortunately I have not been able to find any documentation on the utility anywhere. I fear that it is only available internally at MS.

Joie Andrew
"Since 1982"

Post #1386277

john.bourne

Posted Wednesday, November 28, 2012 7:57 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, February 22, 2013 7:38 AM
Points: 2, Visits: 154

Dont panic, if you have, or your dba has setup a data collection warehouse these are the jobs that get setup automatically. You can confirm this by going into SSMS ->Management -->Data Collection-->System Data Collection Sets. Under this you should find 3 Tasks..Disk Usage, Query Statistics and Server Activity. There may be other because your dba is on the ball. Hope this helps.

Post #1389804

FreeHansje

Posted Thursday, November 29, 2012 3:33 AM

SSC Eights!

Group: General Forum Members
Last Login: Thursday, December 06, 2012 8:30 AM
Points: 879, Visits: 810

Tnx for answering and tnx for the heads-up, John. It makes things clearer indeed.

Greetz,
Hans Brouwer

Post #1390386

« Prev Topic | Next Topic »

Permissions