Announcements
This is the first occurrence of this issue.
If anyone has any suggestions, it will be greatly appreciated.
*This post is locked for comments
Ok great!!! Thank you very much for the info.
Hi again.
Yes, it could be useful application, especially when you want to "catch" a SQL query that is attacking your database. Basically, it creates a "trace" of all the communication to a specific database.
It is an application that you have to install separately then your SQL Server, not sure if it is installed automatically. More info: https://docs.microsoft.com/en-us/sql/tools/sql-server-profiler/sql-server-profiler
Hi Antonijo,
Thank you sooo much for your reply.
Fortunately the issue was resolved. Apparently it took longer than normal for the process to complete, but it eventually did.
One question, how do you run the SQL Server Profiler? This seems to be a useful tool.
Hi Darryl. Do You get any error at the end, some message maybe? Maybe it is the SQL Server connection time-out? Try to change it in the Administrator, double the actual value You have (normally 60 sec.). Also, can You put a SQL Server profiler and maybe detect where the problem is? Any additional info is good...
BR, A.
André Arnaud de Cal...
294,208
Super User 2025 Season 1
Martin Dráb
232,970
Most Valuable Professional
nmaenpaa
101,158
Moderator