Wednesday, April 17, 2013

A bit too new to blogging....? How to ask me questions...

Hi, all,

Looks like I've had some comments sitting out there for a couple of years of which I was unaware... (I'm much better at database things...)

In the future, you're welcome to post here, but for a quick answer, email me directly, jeff@soaringeagle.biz.

Have a fantastic day!

Jeff

Thursday, April 4, 2013

What's the plan of the process currently spinning out of control?

Sometimes you want to know what's going on NOW, not later after everything is done running. ASE 15 & later, you can run sp_showplan, which will get you that information while the spid is running.


sp_showplan spid, batch_id output, context_id output, stmt_num output

To display the showplan output for the current SQL statement without specifying the batch_id, context_id, or stmt_num:
 
sp_showplan spid, null, null, null