how to profile huge qureies/batches

when using profiler, i am getting this by-design error/limitation:

how then can be profile when huge batches/queries are being run, when depending on profiler tool? (this is in sql server 2005 or 2008)

Who is Participating?
ZberteocConnect With a Mentor Commented:
Also there is this free tool from Redgate that keeps a collection of useful queries to get information from SQL server, SQL Script Manager:

You can run the queries against any serve directly from the tool or you can copy and paste them in Management Studio.
Define huge batches/queries.
25112Author Commented:
long query for a huge report.. in profiler, i just see the line "Trace Skipped Records"
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.