?
Solved

SQL Trace

Posted on 2014-12-15
7
Medium Priority
?
160 Views
Last Modified: 2014-12-26
Hi experts:

i am reading about SQL Trace
but i do not understand: Can be used from within applications
0
Comment
Question by:enrique_aeo
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
7 Comments
 
LVL 75

Assisted Solution

by:Aneesh Retnakaran
Aneesh Retnakaran earned 2000 total points
ID: 40501580
If you could provide a link / context that would be helpful. I think it referring to the fact that, you can create / start / stop a trace from application
0
 

Author Comment

by:enrique_aeo
ID: 40501674
it is about: Using SQL Trace for Auditing.
there are two options
1. SQL Server Profiler
and
2. SQL Trace
but i do not understand : can be used from within applications

can you give me an example with T-SQL
0
 
LVL 49

Expert Comment

by:PortletPaul
ID: 40501942
Where did you come across "can be used from within applications"? In a book? a conversation? a web page? here at EE?

Please provide a larger quotation or a reference.
0
Get proactive database performance tuning online

At Percona’s web store you can order full Percona Database Performance Audit in minutes. Find out the health of your database, and how to improve it. Pay online with a credit card. Improve your database performance now!

 

Author Comment

by:enrique_aeo
ID: 40502273
In a book. Oficial course 10775
0
 

Author Comment

by:enrique_aeo
ID: 40508082
SQL Server Profiler is used to trace commands sent to the server and errors returned
Can be heavy on resources
Is run interactively
Can trace command executions
SQL Trace
Supplied as a set of system stored procedures that allow creation of traces
Can be used from within applications
Is relatively light-weight when well-filtered
0
 
LVL 75

Accepted Solution

by:
Aneesh Retnakaran earned 2000 total points
ID: 40508099
That's correct you can initiate a trace within the application, for example all the sql server monitoring tools uses sql server traces.
0
 

Author Comment

by:enrique_aeo
ID: 40510244
Can you give me T-SQL
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Suggested Courses

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question