Monitoring the server

I am new to the forum and have a question. I would like to monitor the SQL
Server 2000 to make sure that it is running fine. Sometimes our server
couldn't be connected even the server is running. I have to re-start the SQ
L
Server in order to solve the problem. I am not sure why does this happen.
That would be nice if I could monitoring the server. Does anyone know how
to do it? Can I monitoring certain port(s)? Or ping those ports? Thanks in
advance for your help Hi
There are quite a few different ways to monitor your server, but for your
immendiate problem you will have to look at the SQL Server error log or the
event log to see if there are any messages relating to the times you are
having the problems. Going forward you may want to look at third party tools
such as Tivoli or Perfmon or SQL Server Alerts or your own scripts that
monitor various aspects of the system.
John
"Skylander" wrote:

> I am new to the forum and have a question. I would like to monitor the SQ
L
> Server 2000 to make sure that it is running fine. Sometimes our server
> couldn't be connected even the server is running. I have to re-start the
SQL
> Server in order to solve the problem. I am not sure why does this happen.
> That would be nice if I could monitoring the server. Does anyone know how
> to do it? Can I monitoring certain port(s)? Or ping those ports? Thanks
in
> advance for your help
>|||Hi John,
Thanks for your quick reply. I have an application called 'SiteScope' that
can monitoring ports and stuff (don't know the detail function of this
application). Can I setup that to monitor certain SQL Server components to
make sure it's running fine?
BTW, is SQL Server Alert part of the components of SQL Server 2000? Thanks
Vince
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> There are quite a few different ways to monitor your server, but for your
> immendiate problem you will have to look at the SQL Server error log or th
e
> event log to see if there are any messages relating to the times you are
> having the problems. Going forward you may want to look at third party too
ls
> such as Tivoli or Perfmon or SQL Server Alerts or your own scripts that
> monitor various aspects of the system.
> John
> "Skylander" wrote:
>|||Hi
Monitoring SQL Server is not really about monitoring the ports, that
tend to imply you have network issues or even a DOS attack!!!!
You can look at what alerts can do by reading books online or starting
at
http://msdn.microsoft.com/library/d...>
aem_0uwk.asp
John|||Hi
You may also find these useful
http://www.databasejournal.com/scri...cle.php/3494931
or SQLPing useful
http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=26
John
John Bell wrote:
> Hi
> Monitoring SQL Server is not really about monitoring the ports, that
> tend to imply you have network issues or even a DOS attack!!!!
> You can look at what alerts can do by reading books online or
starting
> at
>
[url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_automaem_0uwk.asp[/ur
l]
> John