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.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 IO Performace report - any others...

Author  Topic 

mikebird
Aged Yak Warrior

529 Posts

Posted - 2013-05-03 : 10:13:20

Standard server reports

can 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.
Go to Top of Page

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2013-05-05 : 08:30:29
Profiler will let you obtain the query

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

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?
Go to Top of Page

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2013-05-07 : 13:34:54
To use SQL profiler on Express , one option is to use : xSQLProfiler from http://www.xsql.com/products/sql_server_profiler/

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page
   

- Advertisement -