July 10, 2012 at 1:56 am
Hi,
i am planing to automate the sql profiler for servers.can any suggest step by step
July 10, 2012 at 2:44 am
Yeah, don't use profiler.
Instead, use trace events which are all done in T-SQL code. It's pretty easy. Here's an article on how to do it[/url].
However, since you're working on 2008, even better, use Extended Events. Once again they're T-SQL based, so they're easy to put together. Extended Events put even less of a load on the server than trace events and the output is in XML which makes it easier to deal with than the text files from trace events. There's good documentation in the Books Online.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 10, 2012 at 12:38 pm
I agree with Grant.
The only issue with Extended Events on 2008 is that there are some key events that aren't available in Extended Events vs. Trace Events.
If you do decide to use or evaluate Extended Events I suggest you go get Extended Events Manager[/url] by Jonathan Keheyias from codeplex
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
July 11, 2012 at 3:11 pm
Jack Corbett (7/10/2012)
I agree with Grant.The only issue with Extended Events on 2008 is that there are some key events that aren't available in Extended Events vs. Trace Events.
If you do decide to use or evaluate Extended Events I suggest you go get Extended Events Manager[/url] by Jonathan Keheyias from codeplex
+1 on 2008 Extended Events, where possible. The good news is the gap has mostly been closed in SQL 2012.
View the Extended Events Equivalents to SQL Trace Event Classes
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 11, 2012 at 4:44 pm
Jack Corbett (7/10/2012)
I agree with Grant.The only issue with Extended Events on 2008 is that there are some key events that aren't available in Extended Events vs. Trace Events.
If you do decide to use or evaluate Extended Events I suggest you go get Extended Events Manager[/url] by Jonathan Keheyias from codeplex
+1
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply