(If you don’t know…TLA = Three Letter Acronym)
Rounding out the first 5 (not the top 5) lesser known new features in SQL Server 2008 is what I call STP. STP you say?
Standard Temperature and Pressure?
Wow those are 3 things I never thought I’d be giving a “shout out” to on my blog.
To me STP means “Shortcut To Profiler”
So you’re in SSMS and you’re writing some code and decide Hey… I need to run me some profiler and see what is going on. Gone are the days of having to leave the comfy confines of Management Studio.
There are 2 ways to run profiler from SSMS.
1) On the Query menu there is a “Trace Query in SQL Server Profiler” option
or my new favorite shortcut
2) CTRL-ALT-P
This will open SQL Server Profiler, Default to the TSQL_SPs, “automagically” be filtered to your SPID, and will start the trace…(You will still need to execute the code back in SSMS).
One thing that I haven’t been able to figure out yet is how to for Profiler to use my default trace template when opening it with CTRL-ALT-P. Regardless of what template I have setup as my default when I open profiler using CTRL-ALT-P it always uses TSQL_SPs. If I can figure that out I’ll post about it but either way I’m quite happy with the added feature.
You down with STP? Yeah you know me…. sorry bad 90′s music reference.
Enjoy!!
