Archive - Jul 2017

Date
  • All
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31

July 20th

jfilippi's picture

Customize Saving SQLTRACE Data - Long running SQL's

​Here is a way to save SQLTRACE information, but to only save SQL statement that run greater than "X" number of seconds.

This way you can look at your slowest SQL to look at tuning it.

​You will be implementing a task in the SYSADMIN database and creating the table in that database also.