How to collect SQL Profiler Logs to resolve any database issues?

Collect SQL Profiler: Most of the time when we want to check for any dead lock of problem in the database, we ca collect SQL profiler to check what is happening in the database. This below is the complete process on how to collect and proceed with all the steps given below.

Collect SQL Profiler

Step 1: Open SSMS and at the top you can find tools option, click on that and select profiler.

collect SQL Profiler

Step 2: Select “Database” from the server type and in the server’s name you can put SQL Server name OR Local OR Localhost OR “PC:1433” OR “127.0.0.1:1433” to connect to PBIRS Instance. Note: “1433” is my local port number for SQL which we got from above steps.

collect SQL Profiler

Step 3: Now go to event selection and select all the required event and click on “RUN” to start the traces.

SQL Profiler on PBIRS

Step 4: Make sure you check all the event selection, select the event and right click to select the event under the event. Make sure do this for all the events.

qwgfd

Step 5: Now to the PBIRS/SSRS web portal URL and re-produce the issue and make sure all the traces has been collected in the profiler. As you can see in my case, I was having problems with Scheduled refresh, so I have re produced the issue. For more about SQL profiler events click here!

SQL Profiler on PBIRS

Step 6: Go back to profiler and save the traces as mentioned in the below image and give the name to traces. Also note the timing while reproducing the issue.

Fas

TSG Links:

  1. Kerberos Issue: NT AuthorityAnonymous Login Failed -Resolve (kingfishertechtips.in)
  2. Port Number For Analysis Services – Find Ports For SSAS? (kingfishertechtips.in)
  3. RS.exe Utility: Migrate RDL Reports To Another SSRS/PBIRS (kingfishertechtips.in)
  4. Direct Query Mode ON In Tabular Model Issue – Visual Studio (kingfishertechtips.in)
  5. SMTP Server In SSRS/PBIRS |Subscribe To Email Problem/Issue (kingfishertechtips.in)
  6. SQL Server 2022 Download, Install, Connect Using SSMS Tool (kingfishertechtips.in)
  7. Creating Tabular Project & Deploy Model To Analysis Service (kingfishertechtips.in)
  8. Deploy Tabular Project To Azure Analysis Service – SSDT Tool (kingfishertechtips.in)
  9. SSRS/PBIRS – Install And Configure The Report Server On-Prem (kingfishertechtips.in)
  10. Could Not Load Folder Contents In Portal URLs – SSRSPBIRS (kingfishertechtips.in)
  11. SSRS/PBIRS – Install And Configure The Report Server On-Prem (kingfishertechtips.in)
  12. SQL Server 2022 Download, Install, Connect Using SSMS Tool (kingfishertechtips.in)
  13. Capture Fiddler Trace for Debugging the Network Traffic (kingfishertechtips.in)
  14. On-Premises Gateway: Configure/Map SQL DB To Power Bi (kingfishertechtips.in)
  15. Fixed Column/Row Header Make Visible In Any Report (kingfishertechtips.in)
  16. Self-Signed Certificate: Configure SSRS/PBIRS With SSL (kingfishertechtips.in)
  17. Create Local User Account/Local Admin User In Windows 10/11 (kingfishertechtips.in)
  18. Login With AAD/Domain/Microsoft Account To Azure VM’s/RDP (kingfishertechtips.in)
Vickey Rajpoot
Vickey Rajpoot

Hello there! I'm dedicated Microsoft Data & AI Engineer at LTIMindtree, where I thrive technology into actionable insights. Dive into my world by visiting my YouTube channel & Webiste, "Kingfisher Tech Tips".

Articles: 103

Leave a Reply

Your email address will not be published. Required fields are marked *