Sql Scripts to Monitor another SQL Database.

[Louis Frolio]

Greetings All, I was hoping that some of you might be aware of any
free scripts that were written explicitly for the purpose of
monitoring a SQL Server database. I want to be able to determine
up/down events, Error Log updates, Long running Transactions,
Deadlocks, etc. My plan is to use a central SQL Server database as a
repository that will query (via t-sql) the target SQL Server boxes for
the events listed above. If one of the events falls outside of a
defined range I will use xp_sendmail to alert me via my pager. I have
been looking at third party tools like BMC Patrol, Quest Foglight, and
Embarcadero Performance Center and although they are very nice they
are also very EXPENSIVE. I am looing for a cheap solution. Any help
would be greatly appreciated.

Louis

[Simon Hayes]

"Louis Frolio" <fr*****@yahoo.com> wrote in message
news:94*************************@posting.google.co m...

Greetings All, I was hoping that some of you might be aware of any
free scripts that were written explicitly for the purpose of
monitoring a SQL Server database. I want to be able to determine
up/down events, Error Log updates, Long running Transactions,
Deadlocks, etc. My plan is to use a central SQL Server database as a
repository that will query (via t-sql) the target SQL Server boxes for
the events listed above. If one of the events falls outside of a
defined range I will use xp_sendmail to alert me via my pager. I have
been looking at third party tools like BMC Patrol, Quest Foglight, and
Embarcadero Performance Center and although they are very nice they
are also very EXPENSIVE. I am looing for a cheap solution. Any help
would be greatly appreciated.

Louis

All the items you mention can be found by parsing log files, using traces,
using Performance Monitor etc. So you could write your own scripts and tools
to gather the data, but you need to consider how expensive your time is
compared to the price of the existing tools. Google can probably find
scripts for some of those things, so that would be the first place to look,
I guess.

Simon