How to correctly read and interpret data displayed in SQL Server Profiler - What does duration tell me?
I have a production web site that randomly hangs. I can't recreate it on test or dev servers. We therefore ordered a trace to be collected from the MS SQL Server.
When going through the trace, I noticed that sometimes, a very long duration were logged. I also noticed that the SPID number changes every time this huge duration is recorded - see image. Is it a locked/hanging process that's unresponsive for the logged duration or how do I interpret this?
I've already been to the TechNet Library and other sites, but I can't seem to find the answer to this.
I'm afraid that I don't have the time to learn all there is about the matter or spend days finding the answer.
I'm really more in the need for a Yeah, you're screwed! or Don't worry, that duration is just the time elapsed since that SPID had to access data! or something like that.
I hope there's anyone out there able to help!
Well, I can tell you that is what it is supposed to be:
http://msdn.microsoft.com/en-us/library/ms175827(v=sql.100).aspx.
It's not strange that the spid changes when there's a Logout event...that is the connection id.
It would be interesting to see if it corresponds to the beginning or end of your hang event.
- Can anyone please explain this solution of hacker rank Binary Tree Nodes?
- Nesting queries in SQL
- Extract previous row calculated value for use in current row calculations - sql
- How can I select rows from a table where the sum of rows in a joined table is greater than a number?
- Generating time series between two dates in PostgreSQL
- Dates with no time or timezone component in Java/MySQL
- Group close happening events together in ClickHouse
- Is it possible to create a temp table on a linked server?
- Get most recent using datetime
- How can I delete one of two perfectly identical rows?
- How to use SELECT DISTINCT and CONCAT in the same SQL statement
- Mysql query search a string in all columns of a table
- Are PostgreSQL column names case-sensitive?
- Django: how to effectively use select_related() with Paginator?
- PHP: exec() returns status '0' (successful) when executing failing PostgreSQL scripts
- SQL Azure import slow, hangs, but local import takes 3 minutes
- Is TRUNCATE a DML statement?
- MySQL Cannot Add Foreign Key Constraint
- Max and Rank not returning expected results
- Boolean vs tinyint(1) for boolean values in MySQL
- What is the syntax for an inner join in LINQ to SQL?
- "item has already Been added" added in audit
- Merging 2 tables from different databases using MERGE INTO
- How to query a dynamic list of strings using SQL?
- Gaps between primary key id in sql table
- DB Design: how to indicate if a column data is public or private
- SQL Server + convert to text to HEX UTF16 Little Endian
- TO_CHAR to format decimal places not working for whole numbers
- Extracting value from comma-delimited string in Teradata
- How can I shuffle rows in a SQL Server table after insert? Newid doesn't work as expected for some reasons