• The query times aren't terribly long at 200-800 milliseconds or so. But the fact that you're using sp_trace_getdata to collect information means you gathered this using the GUI. Don't do that. There's a reason it's your number one slow query. Better to run a server-side trace using T-SQL, or better still go to extended events.

    But, that aside, the queries aren't fast, what we can see, but they're not egregiously slow either. Not sure what else to say about what's there.

    "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