Need report for current heaviest queries

What tools can I use to get an immediate report of which queries are the
heavist on my sql server? Sometimes it can max for 30-40 seconds and I need
to troubleshoot where the bottleneck it.
All tips and links would be appreciated!
Thanks,
Moshe
You can use a server side trace or Profiler to capture
information on queries such as duration, cpu, reads, writes,
etc. You can use the tool or tracing in different ways but
I'm not sure what you mean by an immediate report - if you
need to see what's hardest on your server you'd need to
monitor this over some period of time. You can save the
trace results to a file and from there you can import them
to a table using fn_trace_gettable and do some analysis,
reporting, etc.
-Sue
On Mon, 6 Mar 2006 14:07:26 -0800, Moshe Rosenberg
<MosheRosenberg@.discussions.microsoft.com> wrote:

>What tools can I use to get an immediate report of which queries are the
>heavist on my sql server? Sometimes it can max for 30-40 seconds and I need
>to troubleshoot where the bottleneck it.
>All tips and links would be appreciated!
>Thanks,
>Moshe

Need report for current heaviest queries

What tools can I use to get an immediate report of which queries are the
heavist on my sql server? Sometimes it can max for 30-40 seconds and I need
to troubleshoot where the bottleneck it.
All tips and links would be appreciated!
Thanks,
MosheYou can use a server side trace or Profiler to capture
information on queries such as duration, cpu, reads, writes,
etc. You can use the tool or tracing in different ways but
I'm not sure what you mean by an immediate report - if you
need to see what's hardest on your server you'd need to
monitor this over some period of time. You can save the
trace results to a file and from there you can import them
to a table using fn_trace_gettable and do some analysis,
reporting, etc.
-Sue
On Mon, 6 Mar 2006 14:07:26 -0800, Moshe Rosenberg
<MosheRosenberg@.discussions.microsoft.com> wrote:

>What tools can I use to get an immediate report of which queries are the
>heavist on my sql server? Sometimes it can max for 30-40 seconds and I need
>to troubleshoot where the bottleneck it.
>All tips and links would be appreciated!
>Thanks,
>Moshe

Need report for current heaviest queries

What tools can I use to get an immediate report of which queries are the
heavist on my sql server? Sometimes it can max for 30-40 seconds and I need
to troubleshoot where the bottleneck it.
All tips and links would be appreciated!
Thanks,
MosheYou can use a server side trace or Profiler to capture
information on queries such as duration, cpu, reads, writes,
etc. You can use the tool or tracing in different ways but
I'm not sure what you mean by an immediate report - if you
need to see what's hardest on your server you'd need to
monitor this over some period of time. You can save the
trace results to a file and from there you can import them
to a table using fn_trace_gettable and do some analysis,
reporting, etc.
-Sue
On Mon, 6 Mar 2006 14:07:26 -0800, Moshe Rosenberg
<MosheRosenberg@.discussions.microsoft.com> wrote:
>What tools can I use to get an immediate report of which queries are the
>heavist on my sql server? Sometimes it can max for 30-40 seconds and I need
>to troubleshoot where the bottleneck it.
>All tips and links would be appreciated!
>Thanks,
>Moshe

Need immediate help with drill down on deployed reports

When using a group by in the query rendering a report, the drill down menus
donâ't work. When the collapsed icon is clicked, nothing happens. Exporting
to an Excel file shows the additional rows and they also show up in preview
mode. When exporting to a PDF they are still hidden. Has anyone else had
this problem? Any fixes?Amanda,
Are you running your query directly in the dataset Text box, or have you
saved it as a stored procedure and run it as such? If running directly, try
creating a user SP and running that. See if that makes a difference.
The only other thing I can think of is if you have your data hidden based on
a parameter and, for some reason, the Expression in your hidden property
isn't set right.
Catadmin
--
MCDBA, MCSA
Random Thoughts: If a person is Microsoft Certified, does that mean that
Microsoft pays the bills for the funny white jackets that tie in the back?
@.=)
"Amanda Adcock" wrote:
> When using a group by in the query rendering a report, the drill down menus
> donâ't work. When the collapsed icon is clicked, nothing happens. Exporting
> to an Excel file shows the additional rows and they also show up in preview
> mode. When exporting to a PDF they are still hidden. Has anyone else had
> this problem? Any fixes?
>|||Thank you for the suggestion. For anyone else having the same problem here
is the solution (at least in my case):
I found that the problem was related to my machine name. Our machine name
contained an underscore (server_name). After correcting this and making
necessary updates to my reports, the drill downs work.