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 |
|
mikebird
Aged Yak Warrior
529 Posts |
 Posted - 2013-05-03 : 10:13:20
|
| Standard server reportscan you get the code out of the report when uou see the most busy at the top?I can select the text. Why not? Printing to a PDF file is handy but I don't want to type it all in manually to test. Is there a simple was to retrieve the SQL? |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2013-05-03 : 12:00:55
|
| Can try running profiler when you generate the report.You should be running perfmon measuring key counters at regular intervals. |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2013-05-05 : 08:30:29
|
| Profiler will let you obtain the queryJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
mikebird
Aged Yak Warrior
529 Posts |
Posted - 2013-05-07 : 06:46:30
|
| Yep. I have profiler and the second tool in the Tools menu in my Developer edition. Not in this EXPRESS edition at work. What would you do?I've put the results in .xls rather than PDF. No Excel here. No MS Office. What would you do? |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
|
|
|
|
|
IO Performace report - any others...