High Duration SQL 2005 Profiler

Hello everybody,

I have a very stranger problem that I need to understand...

In last days I executed a plan SQL 2005 Profiler to review TSQL Duration. When reviewing the results encounter that a SP displays a value of 4037312 in field DURATION which are not normal.

Could to help me to identify why passes this?

SQL Server 2005 has the ability to show duration in microseconds.

This can be changed in the options of Profiler.

Maybe this option is turned on?

WesleyB

Visit my SQL Server weblog @. http://dis4ea.blogspot.com

|||The Duration Field show in microseconds is turned off. The generate value in the profiler for duration field in miliseconds is very high and not real...|||

This comes out to approximately 67 minutes. This is not necessarily wrong. A couple of things I've experienced in regards to long durations:

The job being executed is being blocked by something else and is continuously waiting on something else to complete before it can finish execution. The calling application is leaving the recordset open after calling. For example, if you use MS Access to open a table and don't bother to close it then it will show an extremely long duration (until the table is closed). Other applications could do the same thing if the author didn't properly include the code to close the recordset after retrieving the data. The client that's retrieving the data is on a particularly slow connection. Again - Duration is not the time it takes SQL Server to fulfill the request but the time it takes for the client to retrieve the data from the request and close the resultset. We once learned about a misconfigured network connection because durations were high while CPU and READs were low.|||The profiler duration field is in microseconds by default?|||No, its optional for SQL Server 2005.

Jens K. Suessmeyer.

http://www.sqlserver2005.de

Hiding Rows in Matrix

Hi,

I have a report which has got 52 rows of Week1/Week52. Depending on a field Duration (no. of weeks), I want tot display only those rows. i.e. If duration is 3 then display Row of week1, week2 and week3.

I tried to look in the visibility properties of rows in matrix report. But there is no option. Am I doing something wrong?

any help will be appreciated.

regards

Josh

Edit your row group and go to Visibility tab and use whatever expression you want there.

Shyam

|||

Thanks for your reply.

I tried that, but there is no option of visibility when I select the rows. any idea as to what might be wrong?

thanks

Josh

|||

Right click on any of your row and click on Edit Group and then go to Visibility tab.

Shyam

|||

But it shows the values as blank, does not hide the row.

regards

Josh

|||

Try using the same in visibility expressions of all the textboxes in the row.

Shyam

|||

It works then. But still it leaves the blank space. So in essence if there is data for week1 to week4, it is displayed and then for week5 to week52 there is a blank space.

Any idea how this could be avoided?

regards

Josh