A little testing later, the answer to my own question is answer is sp_statement_starting/completed and filter it by the Type to 'Prepared'. You can see the full query of prepared...

The rpc_starting event has a "statement" event field. That is the remote procedure call itself. It will include the procedure name, the parameters passed in, and the values passed to...

I'd talk 'em through it. They may want write access to be able to set up tests. Insert data sets or update them to prep for a particular test. Makes...

Right. So.

You're very focused on that spill. You actually have a couple. However, they're not the core of the issue. There's a lot to unpack here. If i had to...

Here's a formatted copy of the query for anyone who wants to look:

SELECT [Roles].[Role_ID] AS "legalRoleID",
       [Roles].[UserID] AS MainUserID,
  ...

As I said, why not JOIN to the original table? Embedding it as a function doesn't make sense.

You're looking at two very different things. sql_batch_completed is for calls that come in as a batch command and have completed. rpc_starting is for calls that come in from a...

And to see what indexes are being used and how they're being used, you want to look at the Execution Plans. The book in my link is available in digital...

If you could zip the execution plan and post it instead of the picture, we might be able to help. All the good stuff on an execution plan is in...

Your function is a table, not a value. You're trying to compare a value, e.ID, to a table. You can't do that. You can join to your table instead, but...

The actual plan shows the number of threads used. Counting worker threads you're seeing other artifacts from other processes, including system processes. MAXDOP limits the number of concurrent processors used...

Index use depends on the amount of data it's going to filter. Take a look at the estimated number of rows each time it's doing a scan. I'll bet you...

Since a view is a definition of a query, but is not the actual query that is run when the view is accessed, tuning a view is quite difficult. For...

There is an Oracle specific forum. It might have people monitoring it who know more about Oracle.

So, you have 500 rows. You're adding them all with GETDATE(), then your filtering based on the todays date? Right? You realize that all 500 rows are going to have...