Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Jay123
Yak Posting Veteran
54 Posts |
 Posted - 2010-05-11 : 11:36:45
|
| I have come to this lesson in my book:1. Launch SQL Server Profiler.2. From the File menu, choose New Trace.3. Connect to your SQL Server instance.4. On the General tab, specify the following options:A. Name of the traceB. Blank templateC. Save to file and use the default file nameD. Maximum file size of 50 MBE. Enable file rollover5. On the Events tab, select the check boxes for the following events:A. SQL:BatchCompletedB. RPC:CompletedC. Showplan XML6. Specify the following additional data columns:A. CPUB. ReadsC. WritesD. Start TimeE. End Time7. Run the trace.Now its all good up to step 6.Does this just mean organize the filters so they are at the begining.Because i cannot for the life of me find a way to add thes columns on there own. even under user configurable there is no way to select these items.I am useing sql server 2005 on windows 7.Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
question about sql server profiler.