sqlfriends (2/5/2013)
Thanks ALL.I read a tutorial and recommend this option should be enabled for all instances. Read and still a little confusing about when I should enable or disable it.
I will dig more.
Cite that article please.
I wouldn't agree that it is something that must be done on all instances. Test it first for your environment and then make a decision whether or not to implement it in prod - but certainly not just a blanket yes for all instances.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events