Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

What is DCEXEC? Expand / Collapse
Author
Message
Posted Monday, November 19, 2012 12:57 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, December 6, 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
Posted Monday, November 19, 2012 1:30 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 5:03 AM
Points: 2,840, Visits: 3,975
i guess you are looking for this
http://msdn.microsoft.com/en-us/library/ms162810(v=sql.105).aspx


-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done
Post #1386201
Posted Monday, November 19, 2012 2:29 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, December 6, 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
Posted Monday, November 19, 2012 3:47 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: 2 days ago @ 3:46 AM
Points: 709, Visits: 1,442
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
Posted Wednesday, November 28, 2012 7:57 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Thursday, November 29, 2012 3:33 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, December 6, 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 »

Add to briefcase

Permissions Expand / Collapse