monitoring sql server box

I would like to find out if there are any free tools that could be used to
monitor a sql instance and list the
a. most frequently run stored procedures and how long each takes
b. most frequently run views and how long each takes
netiq used to have app manager - is that still available ?
also, which free tool can I use to monitor CPU, Memory and Netwok
Utilization for a windows box running SQL Server 2000 ?
Thanks"John Smith" <bukusu@.gmail.com> wrote in message
news:epVak7yuGHA.4756@.TK2MSFTNGP04.phx.gbl...
> I would like to find out if there are any free tools that could be used to
> monitor a sql instance and list the
> a. most frequently run stored procedures and how long each takes
> b. most frequently run views and how long each takes
> netiq used to have app manager - is that still available ?
> also, which free tool can I use to monitor CPU, Memory and Netwok
> Utilization for a windows box running SQL Server 2000 ?
> Thanks
>
Not sure about a. & b. but Windows Performance monitor (under Administrative
Tools) can monitor the rest, plus a lot of SQL specific items, too. You can
even monitor remotely.|||Hi John
You could use SQL profiler for a but I would not continually sample. You can
not "run" a view so b is not possible. You may want to look at
http://www.sqldbatips.com/showcode.asp?ID=7.
John
"John Smith" wrote:

> I would like to find out if there are any free tools that could be used to
> monitor a sql instance and list the
> a. most frequently run stored procedures and how long each takes
> b. most frequently run views and how long each takes
> netiq used to have app manager - is that still available ?
> also, which free tool can I use to monitor CPU, Memory and Netwok
> Utilization for a windows box running SQL Server 2000 ?
> Thanks
>
>|||John Smith wrote:
> I would like to find out if there are any free tools that could be used to
> monitor a sql instance and list the
> a. most frequently run stored procedures and how long each takes
> b. most frequently run views and how long each takes
> netiq used to have app manager - is that still available ?
> also, which free tool can I use to monitor CPU, Memory and Netwok
> Utilization for a windows box running SQL Server 2000 ?
> Thanks
>
You can capture stored procedure activity using Profiler, and then
analyze the resulting logs. There is a tool available for download here
(http://www.cleardata.biz/cleartrace/instructions.aspx) that will neatly
summarize the log activity, or you can do the same thing yourself, as we do.
Perfmon is your best bet for monitoring CPU, memory, and network
utilization.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||NetIQ sold th app manager for SQL off to Idera and it is now their SQLdm
product. I should say that the Idera SQMdm product started as the NetIQ App
Manager for SQL. They have spent some time and money upgrading and
updating it since purchasing the software.
www.idera.com if you want to check it out.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"John Smith" <bukusu@.gmail.com> wrote in message
news:epVak7yuGHA.4756@.TK2MSFTNGP04.phx.gbl...
>I would like to find out if there are any free tools that could be used to
>monitor a sql instance and list the
> a. most frequently run stored procedures and how long each takes
> b. most frequently run views and how long each takes
> netiq used to have app manager - is that still available ?
> also, which free tool can I use to monitor CPU, Memory and Netwok
> Utilization for a windows box running SQL Server 2000 ?
> Thanks
>

Monitoring for files

Hi,
Does anyone know of a method using File System Objects to
monitor for filenames that are date & time stamped.
The filename will always follow the form "BACS Day File [ddmmyyhhmm]"
There should only ever be ONE file present in the directory - however
because it is timestamped I am finding it difficult to
write a procedure that will monitor for it.
The various methods I have looked at don't seem to support the use
of wildcards.
Would be gratteful for any advice that is offered !!
Regards
Joe.Joe90 wrote:
> Hi,
> Does anyone know of a method using File System Objects to
> monitor for filenames that are date & time stamped.
No. However even if I did, I wouldn't use it. The FSO is an abomination.

> The filename will always follow the form "BACS Day File [ddmmyyhhmm]"
> There should only ever be ONE file present in the directory - however
> because it is timestamped I am finding it difficult to
> write a procedure that will monitor for it.
> The various methods I have looked at don't seem to support the use
> of wildcards.
Try http://vbnet.mvps.org/index.html?co...tchedfolder.htm
Regards,
Michael Cole|||Hi
Such as:
http://www.sqldts.com/default.aspx?246
Once processes archive the file, therefore any file in the input directory
can be loaded.
John
"Joe90" <matrix@.cyberdine.net> wrote in message
news:Jalde.14751$5A3.484@.newsfe4-win.ntli.net...
> Hi,
> Does anyone know of a method using File System Objects to
> monitor for filenames that are date & time stamped.
> The filename will always follow the form "BACS Day File [ddmmyyhhmm]"
> There should only ever be ONE file present in the directory - however
> because it is timestamped I am finding it difficult to
> write a procedure that will monitor for it.
> The various methods I have looked at don't seem to support the use
> of wildcards.
>
> Would be gratteful for any advice that is offered !!
> Regards
> Joe.|||On Mon, 02 May 2005 08:04:57 GMT, Joe90 <matrix@.cyberdine.net> wrote:
>Does anyone know of a method using File System Objects to
>monitor for filenames that are date & time stamped.
>The filename will always follow the form "BACS Day File [ddmmyyhhmm]"
>There should only ever be ONE file present in the directory - however
>because it is timestamped I am finding it difficult to
>write a procedure that will monitor for it.
>The various methods I have looked at don't seem to support the use
>of wildcards.
LISTING 1: Code to Capture a Command-Line Tool's Output
Set objShell = CreateObject("WScript.Shell")
Set objScriptExec = objShell.Exec("ipconfig /all")
strIpConfig = objScriptExec.StdOut.ReadAll
WScript.Echo strIpConfig
Try this with a dir and wildcard, I guess.
Good luck!
Josh|||In message <OkC06XvTFHA.2996@.TK2MSFTNGP15.phx.gbl>, Michael Cole
<noone@.hansen.com> writes
>Joe90 wrote:
>No. However even if I did, I wouldn't use it. The FSO is an abomination.
>
>Try http://vbnet.mvps.org/index.html?co...tchedfolder.htm
>
File Watcher component in .Net may work, easier to use than the API, if
using .Net of course, but the VBNet stuff is very for VB6.
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com
PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

Monitoring

Hi ,
Is there a way/tool in Sql Server 2000 SP3 to
monitor all activities going on in the Database ?
For example, I first create an empty database.
Then I have an ERWIN generated DDL to create
all views and tables. After that, I have INSERT
scripts that populate all the base tables. What I
want to monitor is success or failure for each
script.

Thanks,
N.N (N@.N.COM) writes:
> Is there a way/tool in Sql Server 2000 SP3 to
> monitor all activities going on in the Database ?
> For example, I first create an empty database.
> Then I have an ERWIN generated DDL to create
> all views and tables. After that, I have INSERT
> scripts that populate all the base tables. What I
> want to monitor is success or failure for each
> script.

The tool you are looking for is the Profiler. Look in the SQL Server
program group.

However, to check the output from build scripts, I think it's best to
save the log, and then search the output for the string "Msg".

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||"N" <N@.N.COM> wrote in message news:<17xUb.21778$_f.2385@.newssvr25.news.prodigy.com>...
> Hi ,
> Is there a way/tool in Sql Server 2000 SP3 to
> monitor all activities going on in the Database ?
> For example, I first create an empty database.
> Then I have an ERWIN generated DDL to create
> all views and tables. After that, I have INSERT
> scripts that populate all the base tables. What I
> want to monitor is success or failure for each
> script.
> Thanks,
> N.

You can use Profiler to view all SQL being sent to the database, but
it sounds like you want to add error handling to your scripts? How to
do that would depend how you run the scripts - eg. if you're using
osql, then -r might be useful. Perhaps if you can give some extra
information about how you call the scripts, and an example of the
code, then someone may be able to suggest something specific.

Simon

monitor Log Shipping

we are using sql server 2000 Log Shipping .Pl help me , tell me about how to
monitor Log Shipping and what are diffrent counters (performance and other )
Ritesh,
The best way to monitor SQL Server 2000 Enterprise Edition log shipping is
to use the built-in Log Shipping Monitor. There are no perfmon counters as
such for log shipping. But you can also monitor the SQL Agent jobs that do
the work.
Hope this helps,
Ron
Ron Talmage
SQL Server MVP
"Ritesh Gupta" <RiteshGupta@.discussions.microsoft.com> wrote in message
news:51A9CEB5-E966-4020-8FCC-9DEBF7781737@.microsoft.com...
> we are using sql server 2000 Log Shipping .Pl help me , tell me about how
to
> monitor Log Shipping and what are diffrent counters (performance and
other )
>
|||Hi Ritesh -
Please visit the link and let me know if it's helpful for you.
http://www.sql-server-performance.co...g_shipping.asp
Regards,
Surajit
"Ron Talmage" wrote:

> Ritesh,
> The best way to monitor SQL Server 2000 Enterprise Edition log shipping is
> to use the built-in Log Shipping Monitor. There are no perfmon counters as
> such for log shipping. But you can also monitor the SQL Agent jobs that do
> the work.
> Hope this helps,
> Ron
> --
> Ron Talmage
> SQL Server MVP
> "Ritesh Gupta" <RiteshGupta@.discussions.microsoft.com> wrote in message
> news:51A9CEB5-E966-4020-8FCC-9DEBF7781737@.microsoft.com...
> to
> other )
>
>

monitor Log Shipping

we are using sql server 2000 Log Shipping .Pl help me , tell me about how to
monitor Log Shipping and what are diffrent counters (performance and other
)Ritesh,
The best way to monitor SQL Server 2000 Enterprise Edition log shipping is
to use the built-in Log Shipping Monitor. There are no perfmon counters as
such for log shipping. But you can also monitor the SQL Agent jobs that do
the work.
Hope this helps,
Ron
--
Ron Talmage
SQL Server MVP
"Ritesh Gupta" <RiteshGupta@.discussions.microsoft.com> wrote in message
news:51A9CEB5-E966-4020-8FCC-9DEBF7781737@.microsoft.com...
> we are using sql server 2000 Log Shipping .Pl help me , tell me about how
to
> monitor Log Shipping and what are diffrent counters (performance and
other )
>|||Hi Ritesh -
Please visit the link and let me know if it's helpful for you.
http://www.sql-server-performance.c...og_shipping.asp
Regards,
Surajit
"Ron Talmage" wrote:

> Ritesh,
> The best way to monitor SQL Server 2000 Enterprise Edition log shipping is
> to use the built-in Log Shipping Monitor. There are no perfmon counters as
> such for log shipping. But you can also monitor the SQL Agent jobs that do
> the work.
> Hope this helps,
> Ron
> --
> Ron Talmage
> SQL Server MVP
> "Ritesh Gupta" <RiteshGupta@.discussions.microsoft.com> wrote in message
> news:51A9CEB5-E966-4020-8FCC-9DEBF7781737@.microsoft.com...
> to
> other )
>
>