asked on

SP for Profiler data analysis

For the purpose of understanding/interpreting the Profiler data output, do you have any stored procedures that generates output/report for analysis.

I am mainly interested in the less often analyzed/checked areas of locks, Database, objects, performance, cursors, scans, audit, server, sessions, and transactions.

Thanks

SOLUTION

Kamaraj Subramanian

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

RiteshShah

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

shru_0409

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

brejk

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

anushahanna

ASKER

Like the Profiler can be run from a local server, and not the production one, can these tools (Performance Dashboard, RML Utilities) be run from a local server, too, to monitor a production server?

Also, can these tools help monitor a SQL Server 2000 Server?
thanks

brejk

@anushahanna: All the tools I suggested are for offline analysis. So, first you have to collect the workload and then perform the analysis. ReadTrace has its version for SQL Server 2000 - it's named Read80Trace. I'm pretty sure the other tools from my previous post will work with SQL Server 2000.

anushahanna

ASKER

brejk
If I am understanding you right, the tools you mentioned will work off the SQL table that collects my profiler data?

brejk

@anushahanna: I suggest you to collect your traces to the files rather than to the tables (because of performance and portability). You can still query trace data saved to the file using fn_trace_gettable system function.

anushahanna

ASKER

brejk,
I opened RML Utility->Reporter.
It does not like SS 2000 version database.

When I tried a 2005 db, it gave the error
Invalid object name 'ReadTrace.tblTimeIntervals'.

I do not see any option to load a trace file. It seems to only ask for Server/Baseline DB names.

The version I am using is 09.01.0109. Is that what you meant to recommend? Thanks

brejk

@anushahanna: RML Utilities is not a kind of "install and work" tool. It needs some additional configuration (which is described in the documentation).