Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

SQL 2008 Server side Trace vs Client side trace/profiler

Posted on 2011-09-25
1
Medium Priority
?
409 Views
Last Modified: 2012-05-12
Is there any reason not to use server side trace and instead use client side trace?
0
Comment
Question by:itnifl
1 Comment
 
LVL 51

Accepted Solution

by:
Steve Bink earned 2000 total points
ID: 36597217
None that I know of.  The preferred method is a server-side trace due to load concerns.  Here is a very good article explaining the load a client-side trace can create:

http://sqlblog.com/blogs/linchi_shea/archive/2007/08/01/trace-profiler-test.aspx
0

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

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

Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Blockchain technology enhances society similar to the Internet. Its effects are broad, disruptive, and will boost global productivity.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…
Suggested Courses

578 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