Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: profiler

How to read the actual value of @P0 in SQL server profiler

By adminPosted on February 8, 2023

Question : When I use SQL server profiler to trace the SQL statement flow using SP:StmtCompleted, I can only read […]

MSSQL Server XE column client_connection_id accessible through system view/table for auditing?

By adminPosted on February 7, 2023

Question : In our .NET application we create a SqlConnection to talk to the database. After the connection is opened, […]

Is Network I/O included in the timings for “RPC complete” seen in SQL Profiler?

By adminPosted on January 29, 2023

Question : When watching results in SQL Profiler, does the RPC Complete include time to send results to the client? […]

Identifying Unused Stored Procedures

By adminPosted on January 28, 2023

Question : This next year, I am helping an effort to clean several SQL Server environments. We have about 10,000 […]

Mysterious procedure calls without parameters – but no exceptions generated

By adminPosted on January 16, 2023

Question : I’ve been tracing a handful of stored procedures with EventClass RPC:Completed that are intermittently called from .Net SqlClient […]

Diagnosing Blocking issues using Blocked Process report

By adminPosted on January 7, 2023

Question : I have an application that is going down as a result of timeouts. During these times we see […]

What is the use of trace captured via Profiler?

By adminPosted on January 2, 2023

Question : I am learning about capturing trace via profiler. I understand that the purpose of capturing trace via profiler […]

What does ‘system lock’ mean in mysql profiling a LOAD DATA INFILE statement?

By adminPosted on December 16, 2022

Question : 2M rows inserted using LOAD DATA INFILE to innodb takes 7.5min, and profiling shows 99% of that time […]

Running a sql server Trace of 1 GB using sqlcmd

By adminPosted on December 13, 2022

Question : I am load testing two sql server instances. I have a trace file from sql server 2000 database […]

Interpretation of a column in SQL Server profile trace

By adminPosted on December 2, 2022

Question : In a trace table generated by Profiler I tried to determine the origin of a lock using the […]

  • 1
  • 2
  • 3
  • …
  • 11

Recent Posts

  • Get column names and data types of a query, table or view
  • What is the effect on primary keys when moving a CLUSTERED index to a new filegroup?
  • Order of returned rows with IN statement
  • Do not want to allow Queries to take more than x minutes?
  • How would i create a report involving multiple many to many relationships
  • web interface port for oracle 11g
  • Getting the exact and closest Search using CONTAINS/CONTAINSTABLE in SQL
  • How can I check if a user have a quota on tablespace
  • Can alias in SQL Server contain slash?
  • Why store /var/lib/mysql when you can just create SQL dumps for backup purposes?
  • Fix OGR2OGR “failed when converting the varchar value to data type int” issue in the MSSQL table –
  • Sum on distinct and group by
  • Is a join optimized to a where clause at runtime?
  • Simple select is taking too long
  • GROUP BY with subqueries for a Group?
  • SERVERPROPERTY(‘Edition’) AS [Edition]
  • Do MySQL sub-queries essentially use as much overhead as separate queries?
  • select fieldvalues and column-description of a table
  • Secure database access from particular applications
  • How to optimize and estimate DB recovery times?

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding