SQL Monitoring Tool  
Author Message
MajBach





PostPosted: Mon Dec 05 11:35:20 CST 2005 Top

SQL Server Developer >> SQL Monitoring Tool

Hi Guys:

Which SQL Monitoring Tool would you recommend that can be used to monitor
daily activity on SQL Servers which has the capability of sending emails as
well. I am looking to resolve some tuning issues and want to install some
software that has the capability to trace long running stored procedures or
queries etc. I tried using SQL Profiler but unfortunately duration column has
mostly blanks and no value in the column. I dont understand why though.

Any help will be appreciated.

Thanks in advance

SQL Server55  
 
 
Tony





PostPosted: Mon Dec 05 11:35:20 CST 2005 Top

SQL Server Developer >> SQL Monitoring Tool Hi Mark,

I mostly use SQL Profiler, make sure you capture the completion events
rather than the start, that will give you your duration and reads etc... you
can then use a filter to filter out long running/high io queries.

This is a link to a WMV demonstration I've done on profiler that should help
you: ->
http://www.sqlserverfaq.com/controls/kbase/store/KB_2_SQLProfiler_20050420.wmv

Tony.

--
Tony Rogerson
SQL Server MVP
http://sqlserverfaq.com - free video tutorials




> Hi Guys:
>
> Which SQL Monitoring Tool would you recommend that can be used to monitor
> daily activity on SQL Servers which has the capability of sending emails
> as
> well. I am looking to resolve some tuning issues and want to install some
> software that has the capability to trace long running stored procedures
> or
> queries etc. I tried using SQL Profiler but unfortunately duration column
> has
> mostly blanks and no value in the column. I dont understand why though.
>
> Any help will be appreciated.
>
> Thanks in advance


 
 
Mark





PostPosted: Mon Dec 05 12:40:02 CST 2005 Top

SQL Server Developer >> SQL Monitoring Tool Hi Tony:
Thanks for the response
I watched your WMV and it appeared to me that you were still talking and the
wave file finished. Duration was about 10 minutes. Is that the complete file
or am I missing something. Last thing I heard was you were looking for
records that had more than 2000 reads.

Thanks in advance.



> Hi Mark,
>
> I mostly use SQL Profiler, make sure you capture the completion events
> rather than the start, that will give you your duration and reads etc... you
> can then use a filter to filter out long running/high io queries.
>
> This is a link to a WMV demonstration I've done on profiler that should help
> you: ->
> http://www.sqlserverfaq.com/controls/kbase/store/KB_2_SQLProfiler_20050420.wmv
>
> Tony.
>
> --
> Tony Rogerson
> SQL Server MVP
> http://sqlserverfaq.com - free video tutorials
>
>


> > Hi Guys:
> >
> > Which SQL Monitoring Tool would you recommend that can be used to monitor
> > daily activity on SQL Servers which has the capability of sending emails
> > as
> > well. I am looking to resolve some tuning issues and want to install some
> > software that has the capability to trace long running stored procedures
> > or
> > queries etc. I tried using SQL Profiler but unfortunately duration column
> > has
> > mostly blanks and no value in the column. I dont understand why though.
> >
> > Any help will be appreciated.
> >
> > Thanks in advance
>
>
>
 
 
Mark





PostPosted: Mon Dec 05 13:06:02 CST 2005 Top

SQL Server Developer >> SQL Monitoring Tool How do we get rid of rows that have blanks in the data column. I have a
column that has bazillion of rows with blank data and when I filter out the
data by setting filter to Duration > 30000, it still brings records with
blank duration recrods and I am tired of hitting scrollbar to go to the
bottom of it.



> Hi Tony:
> Thanks for the response
> I watched your WMV and it appeared to me that you were still talking and the
> wave file finished. Duration was about 10 minutes. Is that the complete file
> or am I missing something. Last thing I heard was you were looking for
> records that had more than 2000 reads.
>
> Thanks in advance.
>

>
> > Hi Mark,
> >
> > I mostly use SQL Profiler, make sure you capture the completion events
> > rather than the start, that will give you your duration and reads etc... you
> > can then use a filter to filter out long running/high io queries.
> >
> > This is a link to a WMV demonstration I've done on profiler that should help
> > you: ->
> > http://www.sqlserverfaq.com/controls/kbase/store/KB_2_SQLProfiler_20050420.wmv
> >
> > Tony.
> >
> > --
> > Tony Rogerson
> > SQL Server MVP
> > http://sqlserverfaq.com - free video tutorials
> >
> >


> > > Hi Guys:
> > >
> > > Which SQL Monitoring Tool would you recommend that can be used to monitor
> > > daily activity on SQL Servers which has the capability of sending emails
> > > as
> > > well. I am looking to resolve some tuning issues and want to install some
> > > software that has the capability to trace long running stored procedures
> > > or
> > > queries etc. I tried using SQL Profiler but unfortunately duration column
> > > has
> > > mostly blanks and no value in the column. I dont understand why though.
> > >
> > > Any help will be appreciated.
> > >
> > > Thanks in advance
> >
> >
> >
 
 
jxstern





PostPosted: Mon Dec 05 15:31:58 CST 2005 Top

SQL Server Developer >> SQL Monitoring Tool On Mon, 5 Dec 2005 11:06:02 -0800, "Mark"

>How do we get rid of rows that have blanks in the data column. I have a
>column that has bazillion of rows with blank data and when I filter out the
>data by setting filter to Duration > 30000, it still brings records with
>blank duration recrods and I am tired of hitting scrollbar to go to the
>bottom of it.

Two things.

First, change the kind of traces you record so they only capture the
events you want, RPC and Batch completions.

Second, you can export the trace into a SQLServer table and then run
any kinds of queries on them you want.


Josh


 
 
Anith





PostPosted: Mon Dec 05 16:48:37 CST 2005 Top

SQL Server Developer >> SQL Monitoring Tool >> Which SQL Monitoring Tool would you recommend that can be used to monitor
>> daily activity on SQL Servers which has the capability of sending emails
>> as well.

Having used it personally, I would recommend Entegra from Lumigent. It has
capabilities for email alerts as well as facilitates overall server
monitoring, but mostly from a security prespective.

>> I am looking to resolve some tuning issues and want to install some
>> software that has the capability to trace long running stored procedures
>> or queries etc.

Profiler can trace statement completion as well as batch completion times.
For overall tuning, get a good load over a reasonable period of time during
high traffice & use ITW ( SQL 2000 ) or use DTA( SQL 2005 ) to analyze them.

--
Anith