Is SQL profiler dangerous?
Recently, I was somewhat surprised to find out that in one of the departments of the large company where I work, launching SQL profiler during business hours is prohibited. I don't know how they manage to analyze performance issues that occur during business hours. Performance views often do not provide an accurate picture, especially if one or two procedures/queries are causing the slowdown without heavily loading the system. […]
