Analyzing SQL Profiler trace

Hi All,

I am going over the output of a Profiler trace and I've found that the duration for many occurrences of EventClass 15 (Logout) is several seconds, up to a maximum of 20 seconds. That seems excessive just to complete a logout, so my question is, does the duration figure reflect only the time to complete the logout operation or does it include the total time that the connection has been active for?

Thanks in advance
LempsterLook up "Security Audit Data Columns" in BOL. For The logout event, the duration is the approximate time the connection was in existence.|||are you sure that is not milliseconds you are looking at?|||No, definitely seconds (20,000-odd milliseconds), but McCrowley's explanation makes sense - thanks!
:)

Analyze SqlServer 7.0 trace output

In one of our SqlServer 7.0 databases we get the following
error message:
Database AllWork: Transaction Log Backup...
Destination:
[e:\SQL7Data\BACKUP\AllWork\AllWork_tlog_200403290 853.TRN]
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 4213:
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot
allow BACKUP LOG because file 'AllWork' has been subjected
to nonlogged updates and cannot be rolled forward. Perform
a full database, or differential database, backup.
[Microsoft][ODBC SQL Server Driver][SQL Server]Backup or
restore operation terminating abnormally.
After a full database backup, everything is fine for some
time, but then the problem reoccurs.
I managed to capture a full trace using Profiler. At 7:40
the transaction log backup succeeded without errors and at
7:45 the transaction log backup failed with the
errormessage shown above. Allthough the trace is only 5
minutes, it still is over 1.100.000 records. I already
looked for SELECT INTO, WRITETEXT and UPDATETEXT
statements but I can't find any.
How can I determine what causes this error message?
What should I look for in the trace?
Any help would be appreciated,
TIA,
Gerrit van Ham
Gerrit,
Is 'select into/bulk copy' switched on? If so, there may be a bcp fast load taking place. I can't remember if this gets shown in the profiler trace in SQL7 or not - I don't think it does, but you may need to check this. It sounds like a bcp operation is t
aking place with select into/bulk copy switched on.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk

Analysis Services and Reporting Services

Hello !
I am currently evaluating ability of Reporting Services (RS) to work
with output of MDX queries. RS looks very appealing when working with
relational output. But working with multidimensional output is somewhat
cumbersome. I haven't found any examples so far running against Analysis
Services.
Any thoughts\sources of information on this subject would be greatly
appreciated. We have to decide whether go with RS as UI to display output
from the cube .
Thank you in advance,
Igor.There's no real integration for AS currently in RS - just the OLAP provider
for OLE DB. This means you need to re-format the data you retrieve from cube
s and there's no query builder type implementation. What you could do is wri
te a reporting tool in .NET
to create the rdl (examples in the RS books online) and supply the MDX via a
client tool - such as a web page or desktop app. That way you can handle th
e formatting etc in the reporting tool, rather than doing every time in the
Report Designer.
HTH
Phil.|||Thanks a lot,
Igor.
"Phil Austin" <anonymous@.discussions.microsoft.com> wrote in message
news:E99A5AFD-CB71-4878-BD98-4380C528CBFC@.microsoft.com...
> There's no real integration for AS currently in RS - just the OLAP
provider for OLE DB. This means you need to re-format the data you retrieve
from cubes and there's no query builder type implementation. What you could
do is write a reporting tool in .NET to create the rdl (examples in the RS
books online) and supply the MDX via a client tool - such as a web page or
desktop app. That way you can handle the formatting etc in the reporting
tool, rather than doing every time in the Report Designer.
> HTH
> Phil.|||There are some examples in the samples folder of Reportin service to
fetch from OLAP. Try it
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!|||Hi,
I would like to suggest u to use the MS Reporting Services addin of
Panorama NovaView to have MS Analysis Services views in MS Reporting
Services with a simple wizard. On our website www.gmsbv.nl you will
find some screenshots.
Marco
"imarchenko" <imarchenko@.hotmail.com> wrote in message news:<#$1yPagBEHA.1600@.tk2msftngp13.
phx.gbl>...
> Hello !
> I am currently evaluating ability of Reporting Services (RS) to work
> with output of MDX queries. RS looks very appealing when working with
> relational output. But working with multidimensional output is somewhat
> cumbersome. I haven't found any examples so far running against Analysis
> Services.
> Any thoughts\sources of information on this subject would be greatly
> appreciated. We have to decide whether go with RS as UI to display output
> from the cube .
>
> Thank you in advance,
>
> Igor.