Reputation
261
Top tag
Next privilege 300 Rep.
Create new tags
Badges
4 12
Impact
~24k people reached

  • 0 posts edited
  • 0 helpful flags
  • 121 votes cast
Aug
27
comment How to trace an SSIS package using Extended Events?
@AaronBertrand Yes, that would be the only thing for this database. From a SQL Task, the application name (client_app_name) is Microsoft SQL Server.
Aug
27
asked How to trace an SSIS package using Extended Events?
Aug
21
awarded  Notable Question
Aug
4
asked Finding when a currently running Extended Events session started?
Aug
4
awarded  Caucus
Aug
4
awarded  Constituent
Jul
31
revised When to use sort_in_tempdb when rebuilding indexes?
added 88 characters in body
Jul
31
comment When to use sort_in_tempdb when rebuilding indexes?
I edited my comment with my tempdb configuration. Thanks, Did not know about the serial online rebuild tip. I'll do some more testing and try to get with the SAN admin, who unfortunately has been less than welcoming. Are there any specific waitstats I should be comparing (ex. PageIOLatch)? Our tempdb writes are super high (4000ms) which is horrendous. Under 40ms for main DBs. That might be a question for another time though...!
Jul
31
revised When to use sort_in_tempdb when rebuilding indexes?
tempdb configuration
Jul
31
asked When to use sort_in_tempdb when rebuilding indexes?
Jun
26
awarded  Commentator
Jun
26
accepted XQuery on Extended Events joining with dm_exec_query_plan not working
Jun
26
comment XQuery on Extended Events joining with dm_exec_query_plan not working
Yes, that's it. I discovered it just a minute ago coincidentally. This can be closed or whatever needs to be done. Thank you.
Jun
26
asked XQuery on Extended Events joining with dm_exec_query_plan not working
Jun
4
revised INSERT INTO with TABLOCK taking longer than without TABLOCK
added 187 characters in body
Jun
4
comment INSERT INTO with TABLOCK taking longer than without TABLOCK
@Kin - No, it is not enabled.
Jun
4
revised INSERT INTO with TABLOCK taking longer than without TABLOCK
add image
Jun
4
asked INSERT INTO with TABLOCK taking longer than without TABLOCK
May
14
awarded  Yearling
Jan
7
awarded  Notable Question