skip to main
|
skip to sidebar
Developer notes
Monday, September 23, 2013
How to query SQL Profiler's trace file?
1. Read from the trace file into temp table in DB
2. Query table
SELECT
*
INTO
MyTraceTemp
FROM
::
fn_trace_gettable
(
'c:\x\MyTrace.trc'
,
default
)
SELECT
Reads
,
Duration
,
*
FROM
MyTraceTemp
ORDER
BY
Reads
DESC
see post
How to read a SQL Profiler trace file into a SQL table
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
Search This Blog
Labels
AJAX
(1)
Algorithms
(1)
ASP.NET MVC
(2)
Azure
(1)
Batch
(2)
C++
(2)
Cloud
(1)
Command
(5)
Debugging
(1)
Entity Framework
(2)
Finance
(1)
HTML
(1)
Interview questions
(2)
Java Script language
(2)
JSON
(1)
Keybord shortcut
(2)
Links
(3)
Linux
(1)
Localization
(1)
ODBC
(1)
PowerShell
(3)
Project Management
(1)
Recipies
(1)
Script
(3)
Security
(1)
SharePoint
(10)
SharePoint migration
(1)
SQL
(21)
SSIS
(2)
SSL
(1)
Technology
(2)
TFS
(1)
Tips
(10)
Tools
(16)
Troubleshooting
(1)
UnitTest
(2)
Utilities
(3)
Visual Modeling Tools
(1)
Visual Studio
(3)
VM
(1)
WCF
(2)
Windows Administration
(1)
Windows Administrator
(1)
Blog Archive
►
2018
(4)
►
July
(1)
►
April
(1)
►
March
(1)
►
February
(1)
►
2017
(4)
►
October
(1)
►
September
(2)
►
May
(1)
►
2016
(8)
►
August
(1)
►
June
(1)
►
May
(2)
►
April
(2)
►
January
(2)
►
2015
(5)
►
December
(1)
►
March
(1)
►
February
(3)
►
2014
(6)
►
October
(1)
►
July
(1)
►
April
(1)
►
March
(1)
►
February
(2)
▼
2013
(15)
►
October
(1)
▼
September
(4)
How to find when index was created?
How to query SQL Profiler's trace file?
How to find sp modified in last N dates
How to find most expensive query?
►
June
(1)
►
March
(2)
►
February
(4)
►
January
(3)
►
2012
(27)
►
November
(4)
►
October
(4)
►
September
(4)
►
July
(5)
►
June
(2)
►
May
(1)
►
April
(2)
►
March
(2)
►
February
(3)
►
2011
(15)
►
October
(1)
►
June
(2)
►
May
(5)
►
March
(3)
►
February
(2)
►
January
(2)
No comments:
Post a Comment