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 Administration
 ALTERNATIVE OF SQL PROFILER

Author  Topic 

scottichrosaviakosmos
Yak Posting Veteran

66 Posts

Posted - 2011-06-26 : 04:22:36
Is there any alternative of sql server profiler. infact an option of any tool. I want to have an option to get data like that of profiler but it should be some good option since i profiler is creating extra load on server. I tried the option SET Profiler. This option is very tricky since when i m using loop upto 1000 then this option displays data 1000 times.
I want some good inbuild feature of sql server that can be an alternative to sql profiler tool.


scoo

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-06-26 : 04:28:05
The best option is to use a server-side trace. You'll need to get very comfortable with the sp_trace* system stored procedures. You can use Profiler to generate the trace though, and then modify it as needed.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -