Recently, I was somewhat surprised to learn that in one of the departments of the large company where I work, running the SQL profiler is prohibited during business hours.
I don't know how they manage to analyze performance issues that occur during business hours. After all, performance views often do not provide an accurate picture, especially if one or two procedures/queries are slowing down the server without particularly stressing it. A tiny query that runs several times an hour and takes 10 seconds instead of one (but does very important work) is unlikely to show up in DMV views. Moreover, a select with CROSS APPLY on query texts heavily burdens the server. However, I find it interesting to understand where this fear comes from. In some companies the SQL profiler is a working tool, while in others it is feared like the plague (for a while, I was involved in consulting and could compare). I am almost sure it was like this:Houston, we have a problem. The database is lagging. Sort it out.
There are so many checkboxes here... What do I actually need? SQL profiler Okay, I'll check all the boxes and decide later.
What stays in the minds of high management? Someone ran it
and everything came to a standstill. And then they recount this to each other over a round of golf.
By the way, it adds a special piquancy to try to record such '
let's write everything SQL profiler ' traces not to a file but to the database on the same server—once, I witnessed such a case.
How are things with you? Please participate in the survey.Can you run the SQL profiler on PROD?We're a small company, everything is simple here. server The production admins can obviously run it.
Production admins can do so after approvals and bowing down.
Only registered users can participate in the survey. , please.
Holy, holy, holy.
4 users voted. 3 users abstained.
Recently, I was somewhat surprised to learn that in one of the departments of the large company where I work, running the SQL profiler during business hours is prohibited.
🥇Is SQL profiler dangerous? | ProHoster
Can you run SQL Profiler during business hours?
Are any trace executions affecting performance visibility?
Source: habr.com
