Archive for July, 2012
The sort_statistics_tracing extended event can be used to reveal details about the sorts being performed on your SQL Server. Adding the sql_text action and sending the output to a live data window we see this:
It’s possible to filter on the max buffers or bobs (big output buffers) to eliminate all but the larger sorts. In combination with the sort warning extended event we can identify the big sorts that are spilling to tempdb.
If you grant db_owner or ddl_admin rights to a subset of your database users and you also run index maintenance jobs that are run under the context of sysadmin then this security related post is quite worrying: