Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 profile CDC

Author  Topic 

basicconfiguration
Constraint Violating Yak Guru

358 Posts

Posted - 2014-11-19 : 13:03:40
How do you SQL profile CDC activities?
I tried and it doesn't display anything on SQL Profiler.
Is there a specific event I should select?

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2014-11-19 : 14:47:37
What do you mean by CDC?

Some possibilties:

Cult of the Dead Cow
California Department of Corrections
Communicable Disease Centre
Combat Direction Center
Croatian Defense Council

... and many, many others
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-11-19 : 15:04:12
If I recall correctly, the CDC stuff happens in the resource database which is not visible in Profiler. Maybe through DAC? Hmmm, can you run Profiler via a DAC connection?

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-11-19 : 15:04:51
quote:
Originally posted by gbritton

What do you mean by CDC?

Some possibilties:

Cult of the Dead Cow
California Department of Corrections
Communicable Disease Centre
Combat Direction Center
Croatian Defense Council

... and many, many others



The SQL Server Change Data Capture feature - aka CDC

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

basicconfiguration
Constraint Violating Yak Guru

358 Posts

Posted - 2014-11-28 : 19:04:54
quote:
Originally posted by gbritton

What do you mean by CDC?

Some possibilties:

Cult of the Dead Cow
California Department of Corrections
Communicable Disease Centre
Combat Direction Center
Croatian Defense Council

... and many, many others



LOL

Change data Capture.
Go to Top of Page
   

- Advertisement -