none
SET STATISTICS impact not setting to OFF ? RRS feed

  • Question

  • Hello if I use one of the SET STATISTICS commands like: 

    SET STATISTICS IO ON

    And not setting back to OFF...are there any negative impacts?

    Like will other Developer users or queries on the entire SQL Server or specified DBs will be affected?

    Does it get set back to OFF after I disconnect and log back in?

    Thanks in advance.

    Friday, November 8, 2019 6:24 PM

Answers

  • SET STATISTICS IO is a plain session setting and "effect" only that one session; the "effect" is you get the I/O stats back to the client as information and it doesn't matter is you reset it later; on closing session it's all gone.

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Friday, November 8, 2019 6:44 PM

All replies