I had everything set up, but my process would fail with this set of messages:Ġ9/27/12 15:49:44.262 Readtrace a SQL Server trace processing utility.Ĭopyright (c) Microsoft Corporation 1997-2008. The readtrace.exe file is used to process trace files, and the commands require the trace file (input), an output directory, a SQL Server instance and a database.
I had two VMs, one with 2008R installed, one with only 2012 installed. RML Utilities will do that for you!īut, before I could get RML Utilities to do that, I had to get it to process a trace file. And I don’t mean two instances of Profiler open, I mean really compare the data. You can capture PerfMon metrics to compare Memory, CPU and I/O…but what about the performance of individual queries? You can get that from the DMVs, but it’s really nice if you can look at the information side by side.
Imagine you run a load test in your production environment, then run that same test in your development environment which might have different hardware or updated code. Yes, that’s right…compare two trace files. Today I’ve been working with it to compare two trace files. I first heard about RML Utilities years ago from Andrew Kelly ( b | t ) and have used it to analyze trace data from customers, which is really just a fraction of what it can do. But not everyone is running 2012 so until then, Trace files will still exist. I know, I know, Trace is deprecated in SQL Server 2012.
SQL SERVER 2012 PROFILER DOWNLOAD DOWNLOAD
It’s available for download and if you work with SQL Trace data at all I’d recommend giving it a look.
SQL SERVER 2012 PROFILER DOWNLOAD FREE
RML Utilities is a free utility created by Microsoft and used by the SQL Server support team.
0 kommentar(er)
