SP for Profiler data analysis

anushahanna
anushahanna used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Kamaraj SubramanianApplication Support Analyst
Commented:
I would recommend you "performance dashboard" for good and graphical analysis if you are using sql server 2005 SP 2+

http://www.sql-server-performance.com/articles/per/bm_performance_dashboard_2005_p1.aspx
Acronis in Gartner 2019 MQ for datacenter backup

It is an honor to be featured in Gartner 2019 Magic Quadrant for Datacenter Backup and Recovery Solutions. Gartner’s MQ sets a high standard and earning a place on their grid is a great affirmation that Acronis is delivering on our mission to protect all data, apps, and systems.

Author

Commented:
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

Commented:
@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.

Author

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

Commented:
@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.

Author

Commented:
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

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

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial