Looking for tools to monitor sql and applications

I am looking for the right tools to do application monitoring.

I'm hoping to find one single tool that can do the entire job but if
it does not exist then a few monitoring apps would do as well.

I need the ability to do the standard things like testing for ping,
checking for windows services running and restarting them after some
threshold is met, and wmi.

Some of the more tricky things I need it to do are:

* Parse log files looking for specific error codes, and the ability to
set an alert only if it sees that error X times over some period of
time.

* Run custom slq queries like row counts and max values returned from
a query and if that condition is met X times over some period of
time.

* Run an external app that does its own custom testing and act on its
results, which could be to parse the result file from the app.

Keep in mind cost is not the isssue right now - so this can be
freeware to some type of enterprise solution that our company can use.
Does anyone know of any tools that you can point me towards?

Thanks...(reg@.yahoo.com) writes:
> I am looking for the right tools to do application monitoring.
>
> I'm hoping to find one single tool that can do the entire job but if
> it does not exist then a few monitoring apps would do as well.
>
> I need the ability to do the standard things like testing for ping,
> checking for windows services running and restarting them after some
> threshold is met, and wmi.
> Some of the more tricky things I need it to do are:
>
> * Parse log files looking for specific error codes, and the ability to
> set an alert only if it sees that error X times over some period of
> time.
> * Run custom slq queries like row counts and max values returned from
> a query and if that condition is met X times over some period of
> time.
> * Run an external app that does its own custom testing and act on its
> results, which could be to parse the result file from the app.
>
> Keep in mind cost is not the isssue right now - so this can be
> freeware to some type of enterprise solution that our company can use.
> Does anyone know of any tools that you can point me towards?

Have you looked at Microsoft Operations Manager? I can't tell that it
does all you want, but MOM is the tool Microsoft presents when you
need to monitor many servers. (It is not really clear from your post
that is what you want, though.)

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

Looking for tool to export data/definitions for later SQL setup.

Any plugable options out there that I can use to export database/table setup
and actual data to xml?
Best yet, would be a .Net class that I could use to control the process for
creating a setup file and then using my own install program to import the
defs/data.
Thanks in Advance,
Donald Adams
"Donald Adams" <BDA_2003@.hotmail.com> wrote in message
news:O0rFG$CIEHA.520@.tk2msftngp13.phx.gbl...
> Any plugable options out there that I can use to export database/table
setup
> and actual data to xml?
> Best yet, would be a .Net class that I could use to control the process
for
> creating a setup file and then using my own install program to import the
> defs/data.
Don't know of any offhand, but you could use SQLXML to export table
definitions from SQL Server (and then you could deserialize them into .Net
classes).
Bryant

Looking for tool

I'm looking for a MSSQL diagramming tool to replace the one in SQL2K.
A straight schema-import is okay, or if I can do round-trip design or
totally replace Enteprise Manager and have even more value add, that's great
too. A DB-specific tool would be better than a diagrammer w/import - but
I'm open to that if I find one that suites. (I have Viso, but not
enteprise - I'll check it out.) The main diagramming feature I want is nicer
and more informative gfx, especailly the ability to have the relationship
lines point to/from the exact field positions. Free is good, but don't mind
paying a few hundred bucks -- don't want to pay thousands. Any
recommendations?
thanks, m
Visio Enterprise might be a good option.
WinSQL has the ability to draw ER diagrams. http://www.synametrics.com/
--=20
Keith
"Mike" <vimakefile@.yahoo.com> wrote in message =
news:OQff0hdOEHA.1456@.TK2MSFTNGP09.phx.gbl...
> I'm looking for a MSSQL diagramming tool to replace the one in SQL2K.
> A straight schema-import is okay, or if I can do round-trip design or
> totally replace Enteprise Manager and have even more value add, that's =
great
> too. A DB-specific tool would be better than a diagrammer w/import - =
but
> I'm open to that if I find one that suites. (I have Viso, but not
> enteprise - I'll check it out.) The main diagramming feature I want is =
nicer
> and more informative gfx, especailly the ability to have the =
relationship
> lines point to/from the exact field positions. Free is good, but don't =
mind
> paying a few hundred bucks -- don't want to pay thousands. Any
> recommendations?
>=20
> thanks, m
>=20
>

Looking for SQL-progammer tool?

Looking for SQL-progammer tool?You may want to be more specific.|||there is a tool call SQL-programmer , I am looking for the download URL for it|||Found it here before

http://orafaq.cs.rmit.edu.au/tools/bmc/sqlprog.htm

Looking for SQL perf analyzing tool

Can anyone recommend a good all-in-one application for analyzing the
performance of 25+ sql servers. We are looking for something that requires
minimal training and implementation time and will tell us which databases
are using the most resources and clearly indicates where tuning and hardware
is needed. Specifically we have more $ than time and dba expertise.
Thanks,
jim
Hi
SQL profiler is the tool that comes with SQL Server that can be used to
analyse this sort of thing, and there are many enhancements in SQL 2005 that
make it even more useful. Failing that you may want to look at products such
as those from Quest http://www.quest.com/sql_server/ or Embarcadero
http://www.embarcadero.com/products/...ter/index.html
John
"Jims" wrote:

> Can anyone recommend a good all-in-one application for analyzing the
> performance of 25+ sql servers. We are looking for something that requires
> minimal training and implementation time and will tell us which databases
> are using the most resources and clearly indicates where tuning and hardware
> is needed. Specifically we have more $ than time and dba expertise.
> Thanks,
> jim
>
>
|||Thanks - these are exactly what I'm looking for.
jim
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:56EEB7AC-2036-4534-9D16-5E6191EA4729@.microsoft.com...[vbcol=seagreen]
> Hi
> SQL profiler is the tool that comes with SQL Server that can be used to
> analyse this sort of thing, and there are many enhancements in SQL 2005
> that
> make it even more useful. Failing that you may want to look at products
> such
> as those from Quest http://www.quest.com/sql_server/ or Embarcadero
> http://www.embarcadero.com/products/...ter/index.html
> John
>
> "Jims" wrote:

Looking for SQL perf analyzing tool

Can anyone recommend a good all-in-one application for analyzing the
performance of 25+ sql servers. We are looking for something that requires
minimal training and implementation time and will tell us which databases
are using the most resources and clearly indicates where tuning and hardware
is needed. Specifically we have more $ than time and dba expertise.
Thanks,
jimHi
SQL profiler is the tool that comes with SQL Server that can be used to
analyse this sort of thing, and there are many enhancements in SQL 2005 that
make it even more useful. Failing that you may want to look at products such
as those from Quest http://www.quest.com/sql_server/ or Embarcadero
http://www.embarcadero.com/products/performancecenter/index.html
John
"Jims" wrote:
> Can anyone recommend a good all-in-one application for analyzing the
> performance of 25+ sql servers. We are looking for something that requires
> minimal training and implementation time and will tell us which databases
> are using the most resources and clearly indicates where tuning and hardware
> is needed. Specifically we have more $ than time and dba expertise.
> Thanks,
> jim
>
>|||Thanks - these are exactly what I'm looking for.
jim
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:56EEB7AC-2036-4534-9D16-5E6191EA4729@.microsoft.com...
> Hi
> SQL profiler is the tool that comes with SQL Server that can be used to
> analyse this sort of thing, and there are many enhancements in SQL 2005
> that
> make it even more useful. Failing that you may want to look at products
> such
> as those from Quest http://www.quest.com/sql_server/ or Embarcadero
> http://www.embarcadero.com/products/performancecenter/index.html
> John
>
> "Jims" wrote:
>> Can anyone recommend a good all-in-one application for analyzing the
>> performance of 25+ sql servers. We are looking for something that
>> requires
>> minimal training and implementation time and will tell us which databases
>> are using the most resources and clearly indicates where tuning and
>> hardware
>> is needed. Specifically we have more $ than time and dba expertise.
>> Thanks,
>> jim
>>

Looking for SQL perf analyzing tool

Can anyone recommend a good all-in-one application for analyzing the
performance of 25+ sql servers. We are looking for something that requires
minimal training and implementation time and will tell us which databases
are using the most resources and clearly indicates where tuning and hardware
is needed. Specifically we have more $ than time and dba expertise.
Thanks,
jimHi
SQL profiler is the tool that comes with SQL Server that can be used to
analyse this sort of thing, and there are many enhancements in SQL 2005 that
make it even more useful. Failing that you may want to look at products such
as those from Quest http://www.quest.com/sql_server/ or Embarcadero
http://www.embarcadero.com/products...nter/index.html
John
"Jims" wrote:

> Can anyone recommend a good all-in-one application for analyzing the
> performance of 25+ sql servers. We are looking for something that require
s
> minimal training and implementation time and will tell us which databases
> are using the most resources and clearly indicates where tuning and hardwa
re
> is needed. Specifically we have more $ than time and dba expertise.
> Thanks,
> jim
>
>|||Thanks - these are exactly what I'm looking for.
jim
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:56EEB7AC-2036-4534-9D16-5E6191EA4729@.microsoft.com...[vbcol=seagreen]
> Hi
> SQL profiler is the tool that comes with SQL Server that can be used to
> analyse this sort of thing, and there are many enhancements in SQL 2005
> that
> make it even more useful. Failing that you may want to look at products
> such
> as those from Quest http://www.quest.com/sql_server/ or Embarcadero
> http://www.embarcadero.com/products...nter/index.html
> John
>
> "Jims" wrote:
>

Looking for good Migration tool which can convert Access db to SQL

I'm looking for migration tool which can convert Access database to SQL
Server. Any one which works 100%. Any suggestions would be greatly
appreciated.
Regards,
RaoRao
Linked Servers?
---
SELECT *
FROM OPENDATASOURCE(
'Microsoft.Jet.OLEDB.4.0',
'Data Source="d:\northwind.mdb";
User ID=Admin;Password='
)...Customers
"Rao" <Rao@.discussions.microsoft.com> wrote in message
news:7215F579-1C4C-4F6D-AF5B-6D0D12117772@.microsoft.com...
> I'm looking for migration tool which can convert Access database to SQL
> Server. Any one which works 100%. Any suggestions would be greatly
> appreciated.
> Regards,
> Rao
>|||You can import the database using DTS. Do mean that you want to also carry
over all the queries, etc. and have the SQL properly translated as well?
"Rao" <Rao@.discussions.microsoft.com> wrote in message
news:7215F579-1C4C-4F6D-AF5B-6D0D12117772@.microsoft.com...
> I'm looking for migration tool which can convert Access database to SQL
> Server. Any one which works 100%. Any suggestions would be greatly
> appreciated.
> Regards,
> Rao
>

Looking for existing tool/product to integrate in MS CMS/SQL based website

Hi all!
I am the IT manager for the Flemish Red Cross and I am looking for an
existing tool/product that we can use to implement a full text-search
(including webpages, Word documents and PDF's) on our new website, thta
we're building on MS CMS and SQLServer.
Any suggestions? We don't really have the time to develop something
ourselves, and I am convinced that there are existing tools or products that
can do the job.
We're willing to spend some money on it, but not in the area of 10000
USD/EUR per processor...
Any help would be greatly appreciated.
I can be e-mailed directly at werner.huysmans@.advalvas.be or
werner.huysmans@.rodekruis.be
Thx in advance!
Werner
SQL Full Text Search is optimal for this and it is free.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Werner huysmans" <werner.huysmans@.advalvas.be> wrote in message
news:pHrhf.61734$rA.54376@.blueberry.telenet-ops.be...
> Hi all!
> I am the IT manager for the Flemish Red Cross and I am looking for an
> existing tool/product that we can use to implement a full text-search
> (including webpages, Word documents and PDF's) on our new website, thta
> we're building on MS CMS and SQLServer.
> Any suggestions? We don't really have the time to develop something
> ourselves, and I am convinced that there are existing tools or products
> that
> can do the job.
> We're willing to spend some money on it, but not in the area of 10000
> USD/EUR per processor...
> Any help would be greatly appreciated.
> I can be e-mailed directly at werner.huysmans@.advalvas.be or
> werner.huysmans@.rodekruis.be
> Thx in advance!
> Werner
>