SQL Trace File - high activity
CoreyLapka
Posts: 3 New member
When I expand a database in the SSMS tree, the for blue and green icon for Source Control spins.
As soon as that happens, my SQL server starts to do a lot of reads from the log_123.trc file.
When I disconnect from the database, the reads stop.
The reads are sometimes rise above 600kb/s.
I am wondering if this is normal and why it is needed.
As soon as that happens, my SQL server starts to do a lot of reads from the log_123.trc file.
When I disconnect from the database, the reads stop.
The reads are sometimes rise above 600kb/s.
I am wondering if this is normal and why it is needed.
Tagged:
Best Answer
-
David Atkinson Posts: 1,457 Rose Gold 2You should be able to uncheck this in the Setup tab (in Global Options). The option is called Indicate changed objects in the Object Explorer.David Atkinson
Product Manager
Redgate Software
Answers
Product Manager
Redgate Software
I'd like to just check for changes twice a week without impacting the server all the time.
With a default refresh rate or 25 seconds, no wonder it never was able to stop reading.
With nearly 3000 stored procedures, it is no surprise that it takes so long
Thank you for your help